FM0-305 Online Practice Questions and Answers

Which script trigger could provide the functionality to prevent invalid data from being committed while allowing the ability to revert the record?

A. OnObjectSave

B. OnObjectExit

C. OnObjectModify

D. OnObjectValidate

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

A. a Web Viewer

B. a merge variable

C. a layout's body part

D. the title of a chart object.

E. an inserted graphic formatted as a button

F. a rectangle object being used as a graphical background

For which two actions will FileMaker Pro 11 NOT preserve Sort Order for records being browsed, by reordering or resorting the found set following the action? (Choose two.)

A. selecting the Records > Show Omitted Only menu item

B. adding records to the table using File > Import Records > File...

C. modifications to a field's data caused by choosing Relookup Field Contents for a field used to specify the current sort order

D. modifications to schema for instance redefining a field type from Number to Text when that field is used to specify the current sort order

E. in Browse mode, rightclick a field that is used as a a field used to specify the current sort order and choose the Extend Found Set popup menu item to add some matching records to the found set

Which two are true about using Current Found Set as the data source for a bar chart in FileMaker Pro 11? (Choose two.)

A. A user will generate a stacked bar chart if they specify one or more fields that contains a returndelimited list as the data series.

B. Unless a user selects the option to Show data points for groups of records when sorted, the chart will maximally include the first 250 records (based on the sort order) of the found set.

C. If a user selects the option to Show data points for groups of records when sorted, sorts the data, and puts the chart in a Trailing Grand Summary, the chart will display one data point per sort group.

D. If a user selects the option to Show data points for groups of records when sorted, 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.

Given the following formula in a calculation field that returns a Text result: Let( tmp = "2 * 5" Evaluate( Quote ( tmp ) ) ) What will be returned?

A. the value 10

B. the value "10", quotes included

C. the value tmp

D. the value "tmp", quotes included

E. the value 2 * 5

F. the value "2 * 5", quotes included

Given the following function: Position ( "Bobby Bubbles" "B" 2 2 ) What is returned?

A. 0

B. 3

C. 4

D. 7

A FileMaker Pro 11 file contains the following script:

Set Variable [$counter Value:1]

Go To Record/Request/Page [First]

Loop

Go To Record/Request/Page [Next]

Exit Loop If [$counter > Get(RecordNumber)]

Set Variable [$counter Value: $counter + 1]

End Loop

#

Exit Script [Result: $counter]

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

B. 6

C. 7

D. 8

E. No value will be returned.

Which two statements regarding the Go to Related Records script step are true? (Choose two.)

A. The script step can specify a layout in another FileMaker Pro file as the destination layout.

B. If there are no related records, the destination layout will have 0 records in the found set.

C. The script step has the option to display the related records in any of the file's existing windows.

D. The script step has the option to show records related to the current record only or to all the records in the found set.

E. The Go to Related Records script step will not work if the destination table is based on an External Data Source of type ODBC.

A hosted FileMaker Pro 11 file contains a text field called ColorChoice that uses global storage. User A and User B are using the file. User A runs a script that changes the value in the ColorChoice field.

User A logs off and User B continues working. User B runs a script that modifies the ColorChoice field after User A has logged off.

If there is no other activity in the database, when User A logs back in, which value will User A see in the

ColorChoice field?

A. No value: the field will be empty.

B. The last value that User A's script entered into the field.

C. The last value that User B's script entered into the field.

D. The last value that was saved in a session that was running on the file's host.

Which two statements are true when FileMaker Server 11 is set to Secure connections to FileMaker Server? (Choose two.)

A. Secure Sockets Layer (SSL) is used by FileMaker Pro 11 client connections.

B. Connections between FileMaker Server 11 and FileMaker Pro 11 are encrypted.

C. Connections between FileMaker Server 11 Advanced and XML clients are encrypted.

D. Connections between FileMaker Server 11 Advanced and ODBC clients are encrypted.

E. Connections between FileMaker Server 11 Web Publishing Engine and the web server are encrypted.

Which two will allow an account to perform a serverside script in FileMaker Server 11? (Choose two.)

A. The specified script is set to Run with Full Access.

B. The Extended Privilege Access via Server Scripts [fmsscript] is checked.

C. The Extended Privilege Access via FileMaker Network [fmapp] is checked.

D. The Allow Enabled Schedules to Run is checked in the FileMaker Server Admin Console.

E. The account under which the script is run must have privileges to execute the specified script.

The components of FileMaker Server 11 or FileMaker Server 11 Advanced may be installed on how many servers?

A. 1 server only

B. 1 or 2 servers only

C. 1, 2, or 3 servers only

D. 1, 2, 3, or 4 servers

Which two statements are true about solutions served via Custom Web Publishing (CWP) in the FileMaker Pro product line? (Choose two.)

A. They can execute FileMaker Pro scripts.

B. They can only be accessed using Firefox, Safari, or Internet Explorer.

C. They are not limited with respect to the number of simultaneous users.

D. They rely on the layouts that have been defined within the hosted FileMaker Pro files.

E. They can only be accessed by accounts for which the [fmphp] extended privilege is enabled.

How should a database be configured so that users will NOT be prompted for a user name and password when accessing the database via Instant Web Publishing (IWP)?

A. replace the default IWP login page with a custom home page

B. enable the [Guest] account and ensure that it is the only active account with the [fmiwp] extended privilege enabled

C. ensure that at least one user account has the [fmiwp] extended privilege and that the password for the account is blank

D. create a script that uses the Relogin script step to log all users in as the [Guest] user, and set that script to run when the file opens

Which two statements are true about windows in a FileMaker database? (Choose two.)

A. A given user may have a maximum of 100 windows open concurrently.

B. Creation of a new window will activate an OnLayoutEnter script trigger.

C. On the Windows platform, only the currently active window can be maximized.

D. The Adjust Window script step can be used to move a window to a location specified by a calculation formula.