FileMaker FileMaker Certification FM0-305 Questions & Answers

• Question 101:

  Consider a FileMaker Pro 11 database with the following tables and fields: Assuming only the above relationships between table occurrences, using sorting if necessary, which two actions can be performed? (Choose two.)

  

  A. create a value list that shows all Invoices for a chosen Customer

  B. create a value list on a Product layout which displays all Customers

  C. find all of the Customers who have ever ordered a specific Product

  D. create a portal to display each Product that has been ordered by a Customer

  E. display all records from the Customer table in a portal on a layout for an Invoice Item record

  Correct Answer: BE

• Question 102:

  Given the following relationship graph:

  

  Without inspecting the data, what can be assumed about this database?

  A. In the Event table, the Event ID has no index.

  B. For each Task record there will be exactly one related Volunteer record.

  C. Each record in the Task table will represent a unique combination of Volunteer ID and Event ID.

  D. The relationship between Task and Event will not allow the Allow creation of records... nor the Delete related records... settings to be enabled for the Event table.

  Correct Answer: A

• Question 103:

  Which three are directly selectable options in the Validation tab of the field options dialog in FileMaker Pro 11? (Choose three.)

  A. Existing value

  B. Member of value list

  C. Strict data type: Integer

  D. Strict data type: Time of Day

  E. Strict data type: Alphanumeric

  F. Minimum number of characters

  Correct Answer: ABD

• Question 104:

  Which two statements are true about field indexing in FileMaker Pro 11? (Choose two.)

  A. Calculation fields cannot be indexed.

  B. Indexing improves the speed at which sorts are performed.

  C. To establish a relationship between two fields, both fields are required to be indexed.

  D. A field must be indexed in order for Autocomplete using previously entered values to function.

  E. Minimal indexing indicates that either the value index or the word index has been created, but not both.

  Correct Answer: DE

• Question 105:

  Which two features require indexing in order to work? (Choose two.)

  A. List function

  B. Dynamic subsummary reports

  C. Autocomplete using existing values

  D. Dynamic value lists based on FileMaker tables

  E. Add Leading Group by in Table View

  Correct Answer: CD

• Question 106:

  Consider two FileMaker files, Collection and Item, where tables from Item are included in the Relationships Graph of Collection. Which method will preserve all functionality in the Relationships Graph of Collection after renaming the Item file to Artifact?

  A. delete referenced Item table occurrences in the Relationships Graph for Collection and recreate them for Artifact

  B. click the Repair Reference button in the Relationships Graph for Collection and reset the file path

  C. choose File > Manage > External Data Sources... for Collection and reset the file path

  D. select referenced Item table occurrences in the Relationships Graph for Collection and rightclick to choose Rename File Source...

  E. choose the File > Recover... menu in FileMaker Pro 11 Advanced, select the Collection file, then choose Repair References under Advanced Recover Options

  Correct Answer: C

• Question 107:

  Which two statements are true about FileMaker Pro 11 relationships? (Choose two.)

  A. A relationship defined with an X (cross product) will only include records with nonmatching match field values.

  B. Valid relationships can include unindexed match fields.

  C. The % (contains) operator can be used for join criteria that include one unindexed match field.

  D. When editing match fields for a relationship, no more than 16 pairs of join criteria can be used.

  E. A relationship defined with an X (cross product) match will allow the Delete related records in this table when a record is deleted in the other table option.

  Correct Answer: BE

• Question 108:

  A table in a FileMaker Pro 11 database has a field CompanyName of type Text. The following field

  validation options are set for this field:

  Validate data in this field only during data entry

  Allow user to override during data entry

  Require not empty

  Display custom message if validation fails

  A user imports a set of records into this table. Some records have no value in the CompanyName field.

  What will occur?

  A. All of the records will be imported. No error message will be displayed.

  B. The user will see the custom error message, but the import will continue if the user overrides the error.

  C. All records with a value for CompanyName will be imported. The user will also see the specified custom error message.

  D. The user will see the custom error message, but in the case of an import, overriding the error is not allowed and no records are imported.

  E. All records with a value for CompanyName will be imported. The user will see an error dialog from the FileMaker Pro application stating that some records could not be imported due to errors, along with a count of those records.

  Correct Answer: A

• Question 109:

  A Text field called FirstLast in FileMaker Pro 11 is set to autoenterb the following formula:

  FirstName and LastName.

  FirstName and LastName are Text fields in the same table. The option Do not evaluate if all referenced fields are empty is unchecked. The option Do not replace existing value of field (if any) is checked. Under which two circumstances will the value of the calculation be inserted into the FirstLast field? (Chooseb two.)

  A. a record is first created

  B. a user selects the menu item Records > Relookup Field Contents

  C. each time the value of the FirstName or LastName field is modified

  D. any field value on the record is modified and the FirstLast field is empty

  E. the FirstName or LastName field is modified and the FirstLast field is empty

  Correct Answer: AE

• Question 110:

  Given a text field myText that contains "blue", which formula extracts the word "blue" from the field?

  A. Filter (myText "color")

  B. MiddleWords (myText 2)

  C. PatternMatch (myText "blue")

  D. Middle ( myText Position ( myText "blue" 1 1 ) 4)

  Correct Answer: D