Latest FileMaker FM0-307 Exam Dumps Free Download with PDF & VCE

Developer Essentials for FileMaker 12 Exam: FM0-307 Exam
FM0-307 Questions & Answers
Exam Code: FM0-307
Exam Name: Developer Essentials for FileMaker 12 Exam
Q & A: 210 Q&As

QUESTION 1
What is the maximum number of recursive calls that can be made utilizing a custom function in
FileMaker Pro 12 Advanced?
A. 10, 000
B. 32, 000
C. 50, 000
D. 64, 000
Answer: D

QUESTION 2
What is the maximum number of files that can be hosted on FileMaker Server 12 Advanced?
A. 100
B. 125
C. 250
D. 999
Answer: B

QUESTION 3
What is the theoretical maximum record count in a FileMaker Pro 12 file?
A. 100 million records
B. 4 billion records
C. 8 trillion records
D. 64 quadrillion records
E. 128 quadrillion records
Answer: A

QUESTION 4
Which two statements are true about fields using global storage in FileMaker Pro 12? (Choose
two.)
A. Globally stored fields are always empty at the start of a user’s session.
B. Fields using global storage can be used as match fields in a relationship.
C. A container field using global storage may not be configured to store its data externally.
D. Globally stored fields can only be accessed from within the file in which they are defined.
E. Changes to data in globally stored fields in a shared file are stored when the server cache is flushed.
Answer: BC

QUESTION 5
Which two statements are true about field indexing in FileMaker Pro 12? (Choose two.)
A. Calculation fields cannot be indexed.
B. Indexing improves the speed at which sorts are performed.
C. To establish a relationship between two fields, both fields are required to be indexed.
D. A field must be indexed in order for Auto-complete using previously entered values to function.
E. Minimal indexing indicates that either the value index or the word index has been created, but not both
Answer: DE

QUESTION 6
Which statement is true about the Relationships Graph in FileMaker Pro 12?
A. Table occurrences can represent tables from external JDBC data sources.
B. A single Relationships Graph can include references to no more than 256 external files.
C. A set of relationships between tables can be created as a loop if every table occurrence in the loop has
a unique name.
D. The Allow creation of records in this table via this relationship setting can be selected between two table
occurrences if the relationship includes only equality (=, or ) matches between fields.
Answer: D

QUESTION 7
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. Vendors can contain multiple valid external FileMaker Data Sources referencing Products.
D. A table occurrence from Products is required on the Vendors Relationships Graph in order to call a script
in Products from Vendors
Answer: C

QUESTION 8
Which two statements are true about container fields that are configured to Store container data
externally in FileMaker Pro 12? (Choose two)
A. Container data stored externally using Secure storage is encrypted.
B. FileMaker Pro 12 can store a maximum of 64 million external files per database file.
C. It is possible to customize the directory location where FileMaker Pro 12 will store external container data.
D. 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.
Answer: AC

QUESTION 9
For which field type can the field validation setting Strict data type: Numeric Only be applied?
A. Text
B. Date
C. Integer
D. Summary
E. Timestamp
Answer: A

QUESTION 10
Which two statements are true about FileMaker Pro 12 relationships? (Choose two.)
A. Valid relationships can include unindexed match fields.
B. The % (contains) operator can be used for join criteria that include one unindexed match field.
C. When editing match fields for a relationship, no more than 16 pairs of match fields can be used.
D. A relationship defined with an X (cross product) will only include records with non-matching match
field values.
E. A relationship defined with an X (cross product) match will allow the Delete related records in this
table when a record is deleted in the other table option.
Answer: AE

QUESTION 11
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. The option Do not evaluate if all
referenced fields are empty is unchecked. The option Do not replace existing value of field (if any)
is checked.
Under which two circumstances will the value of the calculation be inserted into the FirstLast field?
(Choose two.)
A. a record is first created
B. each time the value of the FirstName or LastNarne field is modified
C. a user selects the menu item Records > Relookup Field Contents
D. any field value on the record is modified and the FirstLast field is empty
E. the FirstName or LastNarne field is modified and the FirstLast field is empty
Answer: AE

QUESTION 12
Which statement is true about supplemental fields added to a table occurrence based on an
External ODBC Data Source that uses MySQL?
A. These fields may only be of type Summary or Calculation
B. These fields may be indexed unless they are of type Summary.
C. These fields will be added to the table definitions within MySQL when the Sync button in the FileMaker
Pro 12 Manage Database dialog is used.
D. These fields will be lost if the schema of the MySQL table is changed and then the Sync button in the
FileMaker Pro 12 Manage Database dialog is used.
Answer: A

QUESTION 13
A FileMaker Pro 12 database has two tables called Company and Customer. Both tables have a
number field called CompanyID. The two tables have a relationship between them formed by the
condition Company:: CompanyID = Customer:: CompanyID. Each table also has a text field called
CompanyName. The CompanyName field in the Customer table is defined to Auto-enter
calculated value, with the formula: Company:: CompanyName and the option Do not replace
existing value of field unchecked.
Under which circumstances will the value of the CompanyName field on a Customer record be
refreshed with data from the related Company record?
A. any time the Customer record is modified
B. any time the index of the Company:: CompanyID field is rebuilt
C. any time the related Company:: CompanyName field is modified
D. any time the CompanyID field on the Customer record is modified
E. any time a user chooses Refresh Window from the Records menu while viewing the Customer
record
Answer: D

QUESTION 14
Which statement is true about container fields in FileMaker Pro 12?
A. If one container field in a given database file is set to Store container data externally, all container
fields in that file must store their data externally
B. If a file larger than a database’s Maximum container file size value is inserted into a container field.
FileMaker Pro 12 will automatically compress the inserted file.
C. If a container field is set to Store container data externally, then the Store only a reference to the file
option is automatically selected for any file inserted into that field.
D. If the setting Generate and store thumbnails for images is chosen in the Manage Containers dialog
for a given database file, all container fields in that file will have thumbnails generated.
Answer: D

QUESTION 15
Which two are directly selectable options in the Validation tab of the field options dialog in
FileMaker Pro 12? (Choose two.)
A. Existing value
B. Strict data type: Integer
C. Strict data type: Time of Day
D. Strict datatype: Alphanumeric
E. Minimum number of characters
Answer: AC

…go to http://www.lead2pass.com/fm0-307.html to download the full version Q&As.

         

Comments are closed.