FileMaker FM1-306 問題集

質問 1：
Which two statements are true about using Current Found Set as the data source for a chart in FileMaker Pro 12? (Choose two.)
A. A user can generate a stacked bar chart if they specify one or more fields that contain a return-delimited list as the data series.
B. A user can generate a scatter chart if they specify more than one Y-Axis that contains a return-delimited list as the data series.
C. If a user selects the option Summarized groups of records, sorts the data by two criteria, and puts the chart in a Subsummary part based on the first sort criteria, the chart will display one data point per secondary sort group.
D. If a user selects the option Summarized groups of records, sorts the data, and puts the chart in a Trailing Grand Summary, the chart will display one data point per sort group.
正解：C,D

質問 2：
What can be retrieved using one of the Get functions?
A. The list of FileMaker plug-ins installed on the user's computer
B. The list of script triggers defined for a named object on a layout
C. The list of fields in the current sort order
D. The list of users logged into a file
E. The list of unique IDs for the current window's found set of records
正解：A

質問 3：
A FileMaker Pro 12 file has a Customer table and a related Contact table. The relationship from Customer to Contact is configured to create related records in the Contact table. On the Relationships Graph, an external table occurrence called Invoice is referenced and is related to the Customer table. The file has layouts based on the Customer, Contact, and Invoice table occurrences. The following script is used:
Script A:
New Record/Request
A button that performs Script A has been placed on the Customer layout in a portal that displays the related Contact records.
Which two statements are true about this situation? (Choose two.)
A. If the user is on the Contact layout and runs Script A from the Scripts menu, a new record will be created in the Contact table.
B. Without a Go to Layout script step, Script A cannot be run from the Scripts menu and create a new record in the Invoice table.
C. When the button is clicked, a new record is created in the Contact table
D. If the user is on the Customer layout and runs Script A from the Scripts menu, a new record is created in the Customer table, and a new related record is created in the Contact table.
E. When the button is clicked, a new record is created in the Customer table.
正解：A,E

質問 4：
Given a custom function created in FileMaker Pro 12 Advanced defined as Explode (str):

What is the result of Explode ("Bob")?
A. Bo
B
B. B
Bo
Bo
C. B
Bo
Bob
D. Bob
Bo
B
E. B
B
Bo
正解：E

質問 5：
Consider a FileMaker Pro 12 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 on a Product layout which displays all Customers
B. Display all records from the Customer table in a portal on a layout for an Invoice Item record
C. Create a portal to display each Product that has been ordered by a Customer
D. Find all of the Customers who have ever ordered a specific Product
E. Create a value list that shows all Invoices for a chosen Customer
正解：A,B

質問 6：
Which two statements are true regarding object styles in FileMaker 12? (Choose two.)
A. The Alternate Record state is unique to the Body part.
B. A text box will not display Hover state styles.
C. Only the Normal State will function in Table View for fields in the Body part.
D. Hover state styles for a field will supersede Conditional Formatting styles when a mouse pointer is hovering over the field.
E. Only the Normal State is recognized for object styles in FileMaker Go 12.
正解：B,C