FileMaker FM0-308 Exam Questions

Question 6 of 112

Consider a FileMaker 13 solution with the following tables and fields:
Exam FM0-308: Question 6 - Image 1

Assuming only the above relationships between table occurrences, using sorting if necessary, which two actions can be performed? (Choose two.)

Create a value list that shows all Invoices for a chosen Customer

Create a value list on a Product layout which displays all Customers

Find all of the Customers who have ever ordered a specific Product

Create a portal to display each Product that has been ordered by a Customer

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

Correct Answer: B, E

Question 7 of 112

A table in a FileMaker 13 solution has a text field CompanyName. 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?

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

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

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

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

Correct Answer: A

Question 8 of 112

A new solution is created with Iwo tables, Client and Contracts. The only modification made on the Relationships Graph is to establish a relationship between them which is set to delete related records in Contracts when a record in Client is deleted.
Exam FM0-308: Question 8 - Image 1

What happens when the Client table occurrence is deleted from the Relationships Graph?

Since it is the only occurrence of the Client table on the graph, it cannot be deleted.

Any records in the Contracts table that were related to matching Client records are deleted.

The formula in the calculation field Name Full (defined as Name First & " & Name Last) will be broken.

Any records in the Contracts table that were related to matching Client records will have values in the Client ID field deleted.

Correct Answer: C

Question 9 of 112

Which two FileMaker Pro 13 objects will display data contents even if unrelated to the current layout’s table occurrence? (Choose two.)

Merge variable

Indexed timestamp field

A text field from a shadow table

Globally stored number field placed in a portal

A container field defined with the Store as reference only option enabled

Correct Answer: A, D

Question 10 of 112

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

Calculation fields cannot be indexed.

Indexing improves the speed at which sorts are performed.

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

A field must be indexed in order for Auto-complete using previously entered values to function.

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

Correct Answer: D, E