Developer Essentials for FileMaker 12 Beta Exam (FM1-306) Free Practice Test

Question 1

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. 6

C. 0

D. 5

E. 1

Correct Answer: C

Question 2

What is the maximum number of recursive calls that can be made utilizing a custom function in FileMaker Pro 12 Advanced?

A. 50, 000

B. 64, 000

C. 32, 000

D. 10, 000

Correct Answer: B

Question 3

DRAG DROP
Match the FileMaker Server 12 hosting technology with the maximum number of concurrent client connections.

Correct Answer:

Explanation:

Question 4

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. When the button is clicked, a new record is created in the Customer 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. 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.

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 Contact table

Correct Answer: A,C

Question 5

For which two is it possible to specify conditional formatting? (Choose two.)

A. An inserted graphic formatted as a button

B. The body part of a layout

C. A Tab panel

D. A merge symbol (e.g. < CurrrentDate >)

E. A rectangle object being used as a graphical background

F. The title of a chart object

Correct Answer: C,D

Question 6

The following script is run from a record on a layout based on a table occurrence that is not related to the Product table occurrence:
Go to Related Record [Show only related records; Match found set; From table: "Product"; Using layout: "Product" (Product)] Delete All Records [No dialog] What happens after the script is run?

A. All records in the current found set are deleted.

B. All records in the current table are deleted.

C. All records in the Product table are deleted.

D. All records in the current found set for the Product table are deleted.

Correct Answer: A

Question 7

According to the FileMaker Server Configuration Guide, which two are considered best practices for backing up databases hosted by FileMaker Server 12? (Choose two.)

A. Use the Server Admin Console Schedule Assistant or fmsadmin tool to perform backups

B. Configure backup schedules to direct the backup of hosted databases directly to another computer or storage device

C. Use enterprise-class backup software to do an incremental system backup of the FileMaker Server 12 at least once a day

D. Use enterprise-class backup software to do a full system backup of the FileMaker Server 12 at least once a week

E. Include the option to Verify backup integrity in backups performed during off-peak hours

Correct Answer: A,E

Question 8

Which method can be used to sort related records within a portal in a FileMaker Pro 12 database?

A. change the Sort records setting in the Edit Relationship dialog for the last relationship leading to the portal's table occurrence from the context of the layout's table occurrence on the Relationships Graph

B. in the Relationships Graph, change the Sort records setting in the Specify Table dialog for the portal's table occurrence

C. in Layout Mode, select the portal then choose Sort records in the Behavior section of the Data tab of the Inspector

D. in Browse Mode, right-click on a field in the portal and choose Sort Ascending from the contextual pop-up menu

E. run a script using the Sort Records by Field script step, choosing one of the portal's related fields and checking the Sort only related records option

Correct Answer: A

Question 9

Which three are valid choices for directly importing records into a FileMaker Pro 12 file?
(Choose three.)

A. JDBC Data Source

B. Bento

C. ODBC Data Source

D. HTML Table

E. XML Data Source

F. vCard

Correct Answer: B,C,E

Question 10

Which two statements are true about accounts and privileges in FileMaker Pro 12?
(Choose two.)

A. Each privilege set must be associated with at least one account.

B. An account can be associated with only one privilege set.

C. The default privilege sets in a new database can be set to Inactive.

D. There can be multiple accounts associated with the [Full Access] privilege set.

Correct Answer: B,D

Question 11

Given two tables, Customer and Invoice, related such that customer:: CustomerID = Invoice:: CustomeriD, and a summary field in Invoice, InvoiceCount, defined to count the InvoicelD field.
Which two functions could be used as a field definition in the Customer table to count the number of related invoices? (Choose two.)

A. GetSummary (Invoice::InvoiceCount)

B. ExecuteSQL ("Select Count (CustomeriD) from Invoice where CustomeriD = ?" ; "" ;
"" ; Customer::CustomerID)

C. Count (Invoice::CustomerID)

D. ValueCount (List (CustomerID))

E. ExecuteSQL ("Select Count (Invoice::CustomerID) from Invoice"; " " ; " ")

Correct Answer: B,C

Question 12

DRAG DROP
A layout has a script trigger assigned to activate OnRecordCommit and a field on the same layout with script triggers assigned to activate on OnObjectSave, OnObjectExit and OnObjectValidate. The field is modified and the user exits the field without navigating to another object on the layout.

Correct Answer:

Explanation:

C:\Pasban Work\Cert Paper Exams\FileMaker\FM0-306\FM306\FM306\49.JPG

Question 13

Which two FileMaker Pro 12 objects will display data contents even when unrelated to the current layout's table occurrence? (Choose two.)

A. Globally stored number field placed in a portal

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

C. Indexed tirnestarnp field

D. A text field from a shadow table

E. Merge variable

Correct Answer: A,E

Question 14

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. User A's script will make changes to all records in its found set except the record being edited by User B

B. 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.

C. 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.

D. User As script will stop looping when it reaches the record User B is editing.

Correct Answer: A

Welcome to TestSimulate

FileMaker Developer Essentials for FileMaker 12 Beta (FM1-306) Free Practice Test