FM0-305 Online Practice Questions and Answers

What is the maximum number of files that can be hosted on FileMaker Server 11 Advanced?

A. 100

B. 125

C. 250

D. 999

Given the following relationship graph: Without inspecting the data, what is known about this database?

A. There are no records in the Event table at this time.

B. The Event table occurrence references a table from an external ODBC data source.

C. There can be zero or one, but no more than one, Event record related to any Task record.

D. The corner arrows indicate all three table occurrences reference tables from external data sources.

E. From a layout based on the Event table occurrence, a portal could be drawn showing both related Task and Volunteer data.

A FileMaker Pro 11 file contains the following script: Show All Records Unsort Records Set Variable [$counter Get(FoundCount)] Go To Record/Request/Page [First] Loop Duplicate Record/Request Go To Record/Request/Page [First] Omit Record Set Variable [$counter Value: $counter 1] Exit Loop If [$counter=0] End Loop How many records will the table contain after this script is done executing, if the script begins execution in

a database table containing six records total?

A. 6

B. 12

C. 13

D. 24

E. The script will not finish executing but will loop until forcibly terminated.

A FileMaker Pro 11 database has a script called MyScript that contains only the following script step:

Install OnTimer Script [Hello World Interval:60]

From Window_01 the user runs MyScript and then creates a new window (Window_02). From

Window_02 the user creates a new window ( Window_03).

What is the status of the script Hello World?

A. The Hello World script halts immediately when Window_02 opens.

B. The Hello World script will continue to run on Window_01 and Window_02 and Window_03.

C. The Hello World script will continue to run on Window_01 but will not run on Window_02 or Window_03.

D. The Hello World script will continue to run on Window_01 until it triggers for the first time in one of the new windows.

Which two statements are true about the [Full Access] privilege set in a FileMaker Pro 11 database? (Choose two.)

A. It is the only privilege set that can use Custom Functions.

B. It is the only privilege set that can view the Relationships Graph.

C. It is the only privilege set that can modify field options in Table View.

D. It can be deleted only if another full access privilege set has been created.

Which three conditions must be met to allow user access via accounts that are externally authenticated? (Choose three.)

A. The file must be hosted from FileMaker Server.

B. Account Group Name must match a Group Name specified in the external authentication directory service.

C. The associated privilege set must have the Extended Privilege Access via FileMaker Network (fmapp).

D. The associated privilege set must have the Extended Privilege Access via External Server Authentication (fmesa).

E. The Specify Directory Service Settings in the FileMaker Server Admin Console must be configured to include the LDAP Server Address, Port, and Search Base.

For serverhosted databases, FileMaker Server 11 Advanced is required for which three operations? (Choose three.)

A. importing ODBC data

B. acting as an ODBC data source

C. sharing via Custom Web Publishing

D. sharing via Instant Web Publishing

E. accessing External SQL data sources

F. sharing to more than 250 simultaneous FileMaker Pro users

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.

Which three are necessary to access a FileMaker Pro database hosted via Instant Web Publishing (IWP)? (Choose three.)

A. JavaScript enabled in the web browser

B. a working installation of FileMaker Server

C. a supported web browser (Firefox, Internet Explorer, or Safari)

D. at least one user account in the database with the [fmiwp] extended privilege enabled

E. a web server connected to an authentication server (Apache + OpenDirectory on Mac OS, or IIS + Active Directory on Windows)

F. a web server with the correct IWP plugin (mod_iwp for Apache, or the iwp.dll ISAPI filter for IIS)

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 does not appear in the list of Saved Finds.

B. The user receives the alert No records match this set of find requests.

C. The saved find is available, but selecting it does not change the record set.

D. The user receives the alert This set of find requests cannot be processed on this layout.

E. The find is executed on the layout on which they saved the find, and the proper found set is displayed.