FM0-307 Exam Questions

Which two statements are true about the Admin account created in a new FileMaker Pro 12 database? (Choose two.)

For which field type can the field validation setting Strict data type: Numeric Only be applied?

Which statement is true regarding applying object styles in FileMaker Pro 12?

Given the following two custom functions: SeriesSum (num) = Case (num > 0 ; num + SeriesSum (num - 1)) SeriesSum2 (num; total) = Case (num > 0; SeriesSum2 (num - 1; total + num); t...

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

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

Which default layout theme will be chosen by FileMaker Pro 12 for layouts automatically created when a new table is added to the file?

FileMaker FM0-307 : Practice Test most conditions?

Given a FileMaker Pro 12 database with the following characteristics: named Clients.fmp12 contains an active [Full Access] account named dev1 with the password pOwerU$er contains a...

A text field called FirstLast in FileMaker Pro 12 is set to auto-enter the following formula: FirstName & " " & LastNarne FirstName and LastNarne are text fields in the same table....

A file has the following script specified for OnLastWindowClose: Allow User Abort [Off] Exit Script [Result; False] Commit Records/Requests [No dialog] FileMaker FM0-307 : Practice...

Given the following function: What is returned?

Given two tables in FileMaker Pro 12 with the following fields and table occurrences: FileMaker FM0-307 : Practice Test What two methods can be used to add a portal to a layout bas...

Which statement is true of a container field set to Store container data externally in FileMaker Pro 12?

Given a custom function created in FileMaker Pro 12 Advanced defined as Explode (str): What is the result of Explode ("Bob")?

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

What is the FileMaker recommended strategy to avoid potential performance issues in FileMaker Server 12 with progressive backups enabled?

FileMaker FM0-307 : Practice Test Which two actions can be performed via scripts? (Choose two.)

Consider two FileMaker files, Collection and Item, where tables from Item are included in the Relationships Graph of Collection. Which method will preserve all functionality in the...

Which two are required to get XML data, using a Web browser, from a FileMaker Pro 12 database hosted by FileMaker Server 12? (Choose two.)

Upon conversion from earlier versions of FileMaker Go to FileMaker Go 12, the conversion will make which two changes? (Choose two.)

A user is connected remotely to a FileMaker database with FileMaker Go 12, with an extended privilege of fmreauthenticate0. The user presses the Home button. After 10 seconds, the...

A layout contains a portal that is based on a relationship configured to allow creation of related records. The portal object has the name Porta1_1. Which technique can be used to...

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

Which operation requires a database file to be open in FileMaker Pro 12?

What can be done with an ExecuteSOL calculation function?

Given the following function: Substitute (myText ; ["abc" ; "XYZ"] ; [ "XY2" ; "abc"]) If the field myText contains "abc-xyz", what is the result?

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

What is needed to a use the Send Mail script step to send an email from a FileMaker Server 12 hosted database, using a server-side script?

Which statement is true about the Filter Portal Records feature in FileMaker Pro 12?

Assume the user has full privileges to view and modify all data in the file. Which two statements are true in this situation? (Choose two.)

Which two statements are true concerning Administrator Groups in FileMaker Server 12? (Choose two.) FileMaker FM0-307 : Practice Test

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

Which two statements are true when considering encrypted storage of data in a FileMaker Pro 12 database? (Choose two.)

For which two script triggers can the processing of the triggering event be canceled using Exit script [False]? (Choose two.)

Which two statements are true about overriding the default behavior of the Quick Find box available in the Status Toolbar? (Choose two.)

Which formula returns "05-2012" given a date field myDate that contains the date May 20, 2012?

Which statement is true about the Relationships Graph in FileMaker Pro 12?

A FileMaker Pro 12 file named Arctic has Require full access privileges to create references to this file checked. Arctic has authorized a file named Pacific. The owner of Pacific...

A FileMaker Pro 12 file is hosted by FileMaker Server 12. In the course of working with the file, users run scripts that access and update a global variable called $$currentTransac...

Which two statements are true about fields using global storage in FileMaker Pro 12? (Choose two.)

Which two statements are true about the Administrator Groups feature in FileMaker Server 12 Advanced? (Choose two.)

Given the following relationship graph: Without inspecting the data, what can be assumed about this database?

Given a custom function created in FileMaker Pro 12 Advanced defined as myFunction (str): Case (Length (str) > 0; Right (str; 1) & myFunction (Left (str ; Length (str) - 1)); str)...

What is the minimal requirement to add an external FileMaker Data Source table occurrence of Inventory from a file called DEPT to the Relationships Graph of a file called PROD?

In FileMaker Pro 12 Advanced, which three statements are true about the Data Viewer and Script Debugger? (Choose three.)

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

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

Which three export formats are available using FileMaker Go 12? (Choose three.)

A FileMaker Pro 12 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 run...