Developer Essentials for FileMaker 12 Exam
Question 1: Which FileMaker 12 component is primarily used for designing and managing databases
on a desktop?
A. FileMaker Go
B. FileMaker WebDirect
C. FileMaker Pro
D. FileMaker Server
Answer: C
Explanation: FileMaker Pro is the desktop application used to design, create, and manage databases.
Question 2: In FileMaker 12, which option allows a user to access a database from an iOS device?
A. FileMaker Pro
B. FileMaker Server
C. FileMaker Go
D. FileMaker WebDirect
Answer: C
Explanation: FileMaker Go is specifically designed for mobile iOS devices to access FileMaker databases.
Question 3: What key feature was introduced in FileMaker 12 to enhance cross-platform deployment?
A. New container field storage options
B. WebDirect for browser-based access
C. Enhanced file recovery tools
D. Automatic licensing management
Answer: B
Explanation: FileMaker 12 introduced FileMaker WebDirect, which allows users to access databases
through a web browser.
Question 4: Which FileMaker 12 deployment option is most suitable for server-hosted multi-user
environments?
A. FileMaker Go
B. FileMaker Pro
C. FileMaker WebDirect
D. FileMaker Server
Answer: D
Explanation: FileMaker Server is optimized for hosting databases for multiple users over a network.
Question 5: What is a critical requirement to run FileMaker 12 on a desktop?
A. iOS operating system
B. A compatible desktop OS with the proper system specifications
C. A cloud subscription service
D. Only a web browser
Answer: B
Explanation: FileMaker 12 requires a compatible desktop operating system along with adequate
hardware to meet system requirements.
,Question 6: In FileMaker 12, what does licensing determine?
A. The available themes for layouts
B. The number of concurrent user connections and access rights
C. The color scheme of the FileMaker interface
D. The size of container fields
Answer: B
Explanation: Licensing in FileMaker 12 defines how many users can access the system concurrently and
what access rights they have.
Question 7: When managing FileMaker files, what is the primary purpose of using file recovery
strategies?
A. To enhance the file’s visual design
B. To ensure data integrity and restore files in case of corruption
C. To increase the speed of file opening
D. To reduce the file size automatically
Answer: B
Explanation: File recovery strategies are essential to ensure data integrity and to restore corrupted or
damaged files.
Question 8: Which FileMaker file management feature assists in opening and sharing files in a
networked environment?
A. Container field encryption
B. External data source linking
C. File sharing options and network protocols
D. Calculation functions
Answer: C
Explanation: File sharing options enable multiple users to open and work on the same database across a
network.
Question 9: What does file recovery in FileMaker 12 typically involve?
A. Reformatting the database layout
B. Running a recovery process to rebuild file indexes and structure
C. Upgrading the operating system
D. Exporting the file to CSV
Answer: B
Explanation: File recovery involves rebuilding indexes and the internal structure to repair corruption.
Question 10: In FileMaker’s Manage Database dialog, what is primarily defined by a table?
A. A layout design
B. A collection of related records
C. The user interface
D. Script triggers
Answer: B
Explanation: A table represents a collection of related records and is defined in the Manage Database
dialog.
,Question 11: Which field type in FileMaker 12 is best suited for storing images and binary files?
A. Text
B. Number
C. Container
D. Date
Answer: C
Explanation: Container fields are used to store images, files, and other binary data.
Question 12: What is the role of auto-enter options in FileMaker fields?
A. They adjust the font size in layouts
B. They automatically populate field data based on predefined criteria
C. They secure the file with encryption
D. They manage user accounts
Answer: B
Explanation: Auto-enter options automatically fill in field values based on criteria such as calculations or
serial numbers.
Question 13: How does field indexing affect FileMaker 12 performance?
A. It slows down data entry
B. It enhances search and sort operations
C. It changes the layout style
D. It increases file size without benefits
Answer: B
Explanation: Indexing fields improves the speed of searches and sorting within the database.
Question 14: What is a global field in FileMaker 12 used for?
A. To store records permanently
B. To provide a variable value accessible across the entire file
C. To create relationships
D. To handle container data
Answer: B
Explanation: Global fields hold values that remain constant across all records and are accessible
throughout the file.
Question 15: In the relationships graph, what does a table occurrence represent?
A. A duplicate file
B. A unique alias for a table within the graph
C. A calculation field
D. A layout object
Answer: B
Explanation: Table occurrences serve as unique aliases of a table and are used in defining relationships.
Question 16: Which operator is commonly used to define a match field relationship in FileMaker 12?
A. +
B. =
C. *
D. <>
, Answer: B
Explanation: The equality operator (=) is typically used to match fields between table occurrences.
Question 17: What is the purpose of multi-predicate relationships in FileMaker 12?
A. To combine multiple field matches in a single relationship
B. To define layout themes
C. To manage file encryption
D. To create global variables
Answer: A
Explanation: Multi-predicate relationships allow the use of more than one field criterion for matching
records.
Question 18: How is a self-join implemented in FileMaker 12?
A. By linking a table to itself using a relationship
B. By creating duplicate files
C. By using a container field
D. By duplicating a layout
Answer: A
Explanation: A self-join occurs when a table is related to itself through an alias, facilitating hierarchical
data modeling.
Question 19: In the context of FileMaker relationships, what does relationship directionality imply?
A. The order of table creation
B. The flow of data entry between fields
C. The evaluation of context and matching records
D. The orientation of the layout
Answer: C
Explanation: Directionality affects how related data is accessed and how context is interpreted in
calculations and scripts.
Question 20: What is the main benefit of using the anchor-buoy model in FileMaker relational design?
A. It simplifies container management
B. It ensures proper context and efficient querying of related records
C. It enhances the visual appearance of reports
D. It automates script execution
Answer: B
Explanation: The anchor-buoy model helps maintain clear relationship context and improves the
efficiency of data retrieval.
Question 21: In FileMaker layouts, what is the purpose of a Header part?
A. To display repeating fields
B. To show summary information at the beginning of each page
C. To contain navigation buttons only
D. To define security settings
Answer: B
Explanation: The Header part appears at the top of each printed page and is used to display titles or
summary information.
Question 1: Which FileMaker 12 component is primarily used for designing and managing databases
on a desktop?
A. FileMaker Go
B. FileMaker WebDirect
C. FileMaker Pro
D. FileMaker Server
Answer: C
Explanation: FileMaker Pro is the desktop application used to design, create, and manage databases.
Question 2: In FileMaker 12, which option allows a user to access a database from an iOS device?
A. FileMaker Pro
B. FileMaker Server
C. FileMaker Go
D. FileMaker WebDirect
Answer: C
Explanation: FileMaker Go is specifically designed for mobile iOS devices to access FileMaker databases.
Question 3: What key feature was introduced in FileMaker 12 to enhance cross-platform deployment?
A. New container field storage options
B. WebDirect for browser-based access
C. Enhanced file recovery tools
D. Automatic licensing management
Answer: B
Explanation: FileMaker 12 introduced FileMaker WebDirect, which allows users to access databases
through a web browser.
Question 4: Which FileMaker 12 deployment option is most suitable for server-hosted multi-user
environments?
A. FileMaker Go
B. FileMaker Pro
C. FileMaker WebDirect
D. FileMaker Server
Answer: D
Explanation: FileMaker Server is optimized for hosting databases for multiple users over a network.
Question 5: What is a critical requirement to run FileMaker 12 on a desktop?
A. iOS operating system
B. A compatible desktop OS with the proper system specifications
C. A cloud subscription service
D. Only a web browser
Answer: B
Explanation: FileMaker 12 requires a compatible desktop operating system along with adequate
hardware to meet system requirements.
,Question 6: In FileMaker 12, what does licensing determine?
A. The available themes for layouts
B. The number of concurrent user connections and access rights
C. The color scheme of the FileMaker interface
D. The size of container fields
Answer: B
Explanation: Licensing in FileMaker 12 defines how many users can access the system concurrently and
what access rights they have.
Question 7: When managing FileMaker files, what is the primary purpose of using file recovery
strategies?
A. To enhance the file’s visual design
B. To ensure data integrity and restore files in case of corruption
C. To increase the speed of file opening
D. To reduce the file size automatically
Answer: B
Explanation: File recovery strategies are essential to ensure data integrity and to restore corrupted or
damaged files.
Question 8: Which FileMaker file management feature assists in opening and sharing files in a
networked environment?
A. Container field encryption
B. External data source linking
C. File sharing options and network protocols
D. Calculation functions
Answer: C
Explanation: File sharing options enable multiple users to open and work on the same database across a
network.
Question 9: What does file recovery in FileMaker 12 typically involve?
A. Reformatting the database layout
B. Running a recovery process to rebuild file indexes and structure
C. Upgrading the operating system
D. Exporting the file to CSV
Answer: B
Explanation: File recovery involves rebuilding indexes and the internal structure to repair corruption.
Question 10: In FileMaker’s Manage Database dialog, what is primarily defined by a table?
A. A layout design
B. A collection of related records
C. The user interface
D. Script triggers
Answer: B
Explanation: A table represents a collection of related records and is defined in the Manage Database
dialog.
,Question 11: Which field type in FileMaker 12 is best suited for storing images and binary files?
A. Text
B. Number
C. Container
D. Date
Answer: C
Explanation: Container fields are used to store images, files, and other binary data.
Question 12: What is the role of auto-enter options in FileMaker fields?
A. They adjust the font size in layouts
B. They automatically populate field data based on predefined criteria
C. They secure the file with encryption
D. They manage user accounts
Answer: B
Explanation: Auto-enter options automatically fill in field values based on criteria such as calculations or
serial numbers.
Question 13: How does field indexing affect FileMaker 12 performance?
A. It slows down data entry
B. It enhances search and sort operations
C. It changes the layout style
D. It increases file size without benefits
Answer: B
Explanation: Indexing fields improves the speed of searches and sorting within the database.
Question 14: What is a global field in FileMaker 12 used for?
A. To store records permanently
B. To provide a variable value accessible across the entire file
C. To create relationships
D. To handle container data
Answer: B
Explanation: Global fields hold values that remain constant across all records and are accessible
throughout the file.
Question 15: In the relationships graph, what does a table occurrence represent?
A. A duplicate file
B. A unique alias for a table within the graph
C. A calculation field
D. A layout object
Answer: B
Explanation: Table occurrences serve as unique aliases of a table and are used in defining relationships.
Question 16: Which operator is commonly used to define a match field relationship in FileMaker 12?
A. +
B. =
C. *
D. <>
, Answer: B
Explanation: The equality operator (=) is typically used to match fields between table occurrences.
Question 17: What is the purpose of multi-predicate relationships in FileMaker 12?
A. To combine multiple field matches in a single relationship
B. To define layout themes
C. To manage file encryption
D. To create global variables
Answer: A
Explanation: Multi-predicate relationships allow the use of more than one field criterion for matching
records.
Question 18: How is a self-join implemented in FileMaker 12?
A. By linking a table to itself using a relationship
B. By creating duplicate files
C. By using a container field
D. By duplicating a layout
Answer: A
Explanation: A self-join occurs when a table is related to itself through an alias, facilitating hierarchical
data modeling.
Question 19: In the context of FileMaker relationships, what does relationship directionality imply?
A. The order of table creation
B. The flow of data entry between fields
C. The evaluation of context and matching records
D. The orientation of the layout
Answer: C
Explanation: Directionality affects how related data is accessed and how context is interpreted in
calculations and scripts.
Question 20: What is the main benefit of using the anchor-buoy model in FileMaker relational design?
A. It simplifies container management
B. It ensures proper context and efficient querying of related records
C. It enhances the visual appearance of reports
D. It automates script execution
Answer: B
Explanation: The anchor-buoy model helps maintain clear relationship context and improves the
efficiency of data retrieval.
Question 21: In FileMaker layouts, what is the purpose of a Header part?
A. To display repeating fields
B. To show summary information at the beginning of each page
C. To contain navigation buttons only
D. To define security settings
Answer: B
Explanation: The Header part appears at the top of each printed page and is used to display titles or
summary information.
