1092 お客様のコメント
質問 1：
Given a FileMaker Pro 12 database with the following script:
Show Custom Dialog ["No records found"; "No records matched your find criteria."] End If
Which two statements are true if there are no records where the Customer::Name field contains "Smith"? (Choose two.)
A. Adding a Set Error Capture [On] step to the beginning of the script has no effect on whether or not the custom dialog displays its error message.
B. Unless a Set Error Capture [On] step is added at the beginning of the script. Get (LastError) will not return an error value.
C. Adding a Set Error Capture [On] step to the beginning of the script will suppress the default FileMaker error stating that no records match this set of find requests.
D. Adding a Set Error Capture [On] step to the beginning of the script will cause the script to exit after the custom dialog displays its error message.
正解：A,C
質問 2：
A database has a Customer table and an Order table. On a layout based on the Customer table there is a portal showing related orders for the current calendar year. The portal does not include a filter formula. There is a calculation field in the Customer table, zSumOrders, that adds up the total amount of all the customer's orders for the year. zSumOrders is included on the layout.
Assuming no changes to the data, what may cause the displayed value of zSumOrders on a customer record to change?
A. Change the criteria of the portal's relationship to further limit the set of records displayed in the Orders portal
B. Add one or more sort criteria to the relationship on which the Orders portal is based
C. In Layout Mode, move the zSumOrders field into the Orders portal row
D. Add a portal filter using Filter Portal Records so only unpaid orders will be displayed
正解：A
質問 3：
Which statement is true given two FileMaker Pro 12 files, Vendors and Products, if a table from Products appears on the Vendors Relationships Graph?
A. Scripts in Vendors can reference data from global variables defined in Products.
B. Layouts from Products can be displayed in the same window as layouts from Vendors.
C. A table occurrence from Products is required on the Vendors Relationships Graph in order to call a script in Products from Vendors
D. Vendors can contain multiple valid external FileMaker Data Sources referencing Products.
正解：D
質問 4：
Which formula returns the calendar quarter (1, 2, 3, 4) of a date contained in a field called myDate?
A. Mod(Month(myDate); 3)+ 1
B. Let(m = Month(myDate);
Case(m > 0 ; 1 ; m > 3 ; 2 ; m > 6 ; 3 ; 4)
)
C. Int(Month(myDate)/ 3)
D. Let(m = Month(myDate);
Choose(m ; 1 ; 1 ; 1 ; 2 ; 2 ; 2 ; 3 ; 3 ; 3 ; 4 ; 4 ; 4) )
E. Ceiling(Month(myDate)/ 3)
正解：E
質問 5：
Which two statements are true about container fields that are configured to Store container data externally in FileMaker Pro 12? (Choose two)
A. FileMaker Pro 12 can store a maximum of 64 million external files per database file.
B. Once a container field has been configured to store data internally, the data must be re-imported if the field is changed to store data externally.
C. Container data stored externally using Secure storage is encrypted.
D. It is possible to customize the directory location where FileMaker Pro 12 will store external container data.
正解：C,D
Given a FileMaker Pro 12 database with the following script:
Show Custom Dialog ["No records found"; "No records matched your find criteria."] End If
Which two statements are true if there are no records where the Customer::Name field contains "Smith"? (Choose two.)
A. Adding a Set Error Capture [On] step to the beginning of the script has no effect on whether or not the custom dialog displays its error message.
B. Unless a Set Error Capture [On] step is added at the beginning of the script. Get (LastError) will not return an error value.
C. Adding a Set Error Capture [On] step to the beginning of the script will suppress the default FileMaker error stating that no records match this set of find requests.
D. Adding a Set Error Capture [On] step to the beginning of the script will cause the script to exit after the custom dialog displays its error message.
正解：A,C
質問 2：
A database has a Customer table and an Order table. On a layout based on the Customer table there is a portal showing related orders for the current calendar year. The portal does not include a filter formula. There is a calculation field in the Customer table, zSumOrders, that adds up the total amount of all the customer's orders for the year. zSumOrders is included on the layout.
Assuming no changes to the data, what may cause the displayed value of zSumOrders on a customer record to change?
A. Change the criteria of the portal's relationship to further limit the set of records displayed in the Orders portal
B. Add one or more sort criteria to the relationship on which the Orders portal is based
C. In Layout Mode, move the zSumOrders field into the Orders portal row
D. Add a portal filter using Filter Portal Records so only unpaid orders will be displayed
正解：A
質問 3：
Which statement is true given two FileMaker Pro 12 files, Vendors and Products, if a table from Products appears on the Vendors Relationships Graph?
A. Scripts in Vendors can reference data from global variables defined in Products.
B. Layouts from Products can be displayed in the same window as layouts from Vendors.
C. A table occurrence from Products is required on the Vendors Relationships Graph in order to call a script in Products from Vendors
D. Vendors can contain multiple valid external FileMaker Data Sources referencing Products.
正解：D
質問 4：
Which formula returns the calendar quarter (1, 2, 3, 4) of a date contained in a field called myDate?
A. Mod(Month(myDate); 3)+ 1
B. Let(m = Month(myDate);
Case(m > 0 ; 1 ; m > 3 ; 2 ; m > 6 ; 3 ; 4)
)
C. Int(Month(myDate)/ 3)
D. Let(m = Month(myDate);
Choose(m ; 1 ; 1 ; 1 ; 2 ; 2 ; 2 ; 3 ; 3 ; 3 ; 4 ; 4 ; 4) )
E. Ceiling(Month(myDate)/ 3)
正解：E
質問 5：
Which two statements are true about container fields that are configured to Store container data externally in FileMaker Pro 12? (Choose two)
A. FileMaker Pro 12 can store a maximum of 64 million external files per database file.
B. Once a container field has been configured to store data internally, the data must be re-imported if the field is changed to store data externally.
C. Container data stored externally using Secure storage is encrypted.
D. It is possible to customize the directory location where FileMaker Pro 12 will store external container data.
正解：C,D
Hazuki -
FM0-306がいいだと思う。試験の準備中なので、友達からこのPass4Testを聞いたから、買いたい