A FileMaker Pro 12 database is hosted by FileMaker Server 12. User A and User B are accessing the database at the same time. User A runs a script that loops over a set of records and makes changes to those records. During the time that the script runs, User B is editing one of the records that is also in User A's found set and is being acted on by User As script.
Which statement is true about this situation?
A. When it reaches the record User B is editing, User As script will stop if User A's script is running with Set Error Capture [On]. Otherwise User A will be prompted to either continue or cancel the running script.
B. User A's script will make changes to all records in its found set except the record being edited by User B
C. User As script will stop looping when it reaches the record User B is editing.
D. User A's script will stop looping when it reaches the record User B is editing, and will wait to continue until User B releases the record.
正解:B
質問 2:
Which three export formats are available using FileMaker Go 12? (Choose three.)
A. dBase
B. XML
C. vCard
D. Excel Workbook (.xlsx)
E. HTML
正解:A,D,E
質問 3:
Which statement are true about importing tables using FileMaker Pro 12 Advanced?
A. Using the Set up as automatic recurring import option of the Import Records > File... command will, on first layout load, update records which have changed in the source file but will not attempt to make any changes to new records in the target file.
B. When using the Import Records > File... command and choosing New Table as the Target to create a new table from a comma or tab separated file, the first row of the file cannot be used as field names in the newly created table.
C. When a layout created using the Set up as automatic recurring import option of the Import Records > File... command is first loaded it runs a script which brings up a dialog if any of the given table's records have been modified in both the source and target files.
D. Using the Import Records > File... command and choosing New Table as the Target will create a new table, new layout, and new record data.
正解:D
質問 4:
Which statement is true about File Recovery in FileMaker Pro 12?
A. A database hosted by FileMaker Server 12 which becomes corrupted will be unavailable to users and will show as "Closed" in the Databases list of the Admin Console
B. Using the Copy logical structure (same as Compacted Copy) option of Advanced Recover Options is often sufficient to correct errors reported in recover.log after performing a Consistency Check.
C. To determine if a hosted database is corrupt create a FileMaker Server Schedule to Verify the database, run the Schedule and review the notation in the Status column in the Admin Console. A status of "Failed" indicates a damaged file. "OK" indicates the file is undamaged.
D. Performing a Recover with all Advanced Recover Options enabled takes longer than performing a Consistency Check because it examines everything examined during a Consistency Check and additionally rebuilds field indexes.
正解:B
質問 5:
A FileMaker Pro 12 file contains the following script:
If this script is executed in a context where there is a found set of six records, which value will be returned from the script?
A. No value will be returned.
B. 0
C. 5
D. 1
E. 6
正解:B
質問 6:
A user finds a set of records and saves the find criteria using the Saved Finds command. The user then switches to a layout based on a different, unrelated table occurrence and attempts to perform the saved find.
What will happen next?
A. The saved find is available, but selecting it does not change the record set.
B. The user receives the alert This set of find requests cannot be processed on this layout.
C. The saved find does not appear in the list of Saved Finds.
D. The user receives the alert No records match this set of find requests
E. The find is executed on the layout on which they saved the find, and the proper found set is displayed
正解:C
質問 7:
Given the following return-delimited data in a Team field of a FileMaker Pro 12 database:
Andy Jones
Bernie Lee
Carry Lane
Which formula would result in the string "Bernie Lee" (without quotes or leading/trailing carriage returns) from Team?
A. Getltem (Team ; "|" ; 2)
B. ListValues (Team ; 2)
C. Trim (MiddleWords (Team ; 3 ; 4))
D. MiddleValues (Team ; 2 ; 1)
E. Middle (Team ; 12 ; 10)
正解:E
質問 8:
Given a custom function created in FileMaker Pro 12 Advanced defined as Explode (str):
What is the result of Explode ("Bob")?
A. B B Bo
B. Bo B
C. B Bo Bo
D. B
Bo Bob
E. Bob Bo B
正解:A
質問 9:
Which statement is true about the Relationships Graph in FileMaker Pro 12?
A. A set of relationships between tables can be created as a loop if every table occurrence in the loop has a unique name.
B. A single Relationships Graph can include references to no more than 256 external files.
C. Table occurrences can represent tables from external JDBC data sources.
D. The Allow creation of records in this table via this relationship setting can be selected between two table occurrences if the relationship includes only equality (=, or ) matches between fields.
正解:D
铃木** -
前回の試験では及ばず落ちましが4月の試験でPass4Testのこの問題集を購入して今回合格出来ました。