FileMaker FM0-307 問題集

質問 1：
Given the following Relationships Graph for a FileMaker Pro 12 database, where Employee, Manager, and Trainer are all table occurrences sharing the same source table:

The database has the following layout, based on the Trainer table occurrence:

If a developer adds the following fields to the portal:
Class:: Class Name
Employee:: Name
Manager:: Name
Which data is shown in the portal?
A. Each of the trainer's classes, the first employee enrolled in each class, and the first related manager for each employee
B. Each of the trainer's classes, the first employee enrolled in each class, and the trainer as manager for that employee
C. The first of the trainer's classes in all rows, all employees enrolled in any of the trainer's classes, and the first related manager for each employee
D. The first class each employee is enrolled in, all employees managed by the trainer, and the trainer as manager for each employee
E. The first class each employee is enrolled in, all employees enrolled in any of the trainer's classes, and the first related manager for each employee
正解：C

質問 2：
While in a FileMaker Pro 12 database on a layout based on the Invoice table occurrence, the following script is run:

Which statement is true at the conclusion of the script?
A. All "Sent" invoices have been omitted from the found set.
B. The found set will consist of all records if the first record has a status of "Pending".
C. The last record will not be omitted if it has a status of "Sent".
D. The loop will never end if every invoice has a status of "Sent".
正解：A

質問 3：
LAN users of a hosted database are reporting slow performance. A Performance Monitor log file from the FileMaker Server 12 machine reports a consistently high value on the Network Interface/Output Oueue Length Performance Object Counter.
The server has dual processors, 2Gb of RAM and three 7200 RPM hard drives configured using RAID 5.
Which two steps would most likely improve performance? (Choose two.)
A. Replace the machine with one which has four processors
B. Install an additional hard drive and configure the drive subsystem using RAID 1+0
C. Replace the network card with a model which has an on-board processor
D. Install 2Gb of additional RAM
E. Install an additional network card and team it with the existing card
正解：C,E

質問 4：
A FileMaker Pro 12 file contains the following script: If this script is executed in a context where there is found a set of six records, which value will be returned from the script?

A. 6
B. 7
C. 1
D. No value will be returned.
正解：B

質問 5：
Which two statements are true about File Recovery in FileMaker Pro 12? (Choose two.)
A. The recover.log file reports block damage that is not reported elsewhere.
B. Performing a Recover with Advanced Options requires an account with [Full Access] privileges.
C. The Recover command can be used to perform a Consistency Check on a hosted database file.
D. The information in the recover.log file can be used to determine which individual schema or structure elements are damaged, if any.
E. A standard recovery will remove all field indexes for fields, leaving them to be rebuilt as needed.
正解：A,D

質問 6：
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