Download FileMaker Pro Developer Essentials Exam Questions and Answers and more Exams Technology in PDF only on Docsity!
Question 1: In FileMaker Pro, which component is primarily responsible for the visual display of data? A. Script Workspace B. Layouts C. Relationships D. Calculation Engine Correct Answer: B Explanation: Layouts define how data appears on screen and are used for data entry, browsing, and reporting in FileMaker Pro. Question 2: What is the FileMaker Server used for? A. Designing user interfaces B. Managing file sharing and hosting databases C. Writing calculation formulas D. Debugging scripts
Correct Answer: B Explanation: FileMaker Server is designed to host databases, manage file sharing, and provide secure access to FileMaker solutions. Question 3: FileMaker Go is primarily designed for which platform? A. Desktop computers B. Mobile devices C. Cloud services D. Web browsers Correct Answer: B Explanation: FileMaker Go is a mobile application that allows users to access FileMaker solutions on iOS devices. Question 4: In the FileMaker ecosystem, which tool is used for web publishing? A. FileMaker Pro
Question 6: What is a primary key used for in a FileMaker database? A. To store images B. To uniquely identify a record C. To design layouts D. To trigger scripts Correct Answer: B Explanation: A primary key is a unique identifier for a record in a table, ensuring each entry can be distinctly referenced. Question 7: Which of the following is NOT a basic component of a FileMaker solution? A. Fields B. Layouts C. Scripts D. Operating System Drivers
Correct Answer: D Explanation: FileMaker solutions are built using fields, layouts, scripts, and relationships—not operating system drivers. Question 8: What is the function of the FileMaker Script Workspace? A. To manage table relationships B. To create, edit, and run scripts C. To design web layouts D. To import external data Correct Answer: B Explanation: The Script Workspace provides an environment for building, debugging, and running scripts that automate tasks in FileMaker. Question 9: Which type of field is best used for storing a photograph in FileMaker?
Question 11: In FileMaker, which script step would you use for conditional execution? A. Go to Layout B. If/Else C. Set Field D. Commit Records Correct Answer: B Explanation: The If/Else script step allows you to specify conditions and execute different actions based on whether the condition is met. Question 12: How do global variables differ from regular variables in FileMaker scripting? A. They can be used without initialization B. They remain accessible across layouts and scripts during a session C. They are read-only D. They are only available in a single layout
Correct Answer: B Explanation: Global variables are accessible across different scripts and layouts within the same session, unlike local variables which have a limited scope. Question 13: Which option best describes a one-to-many relationship in FileMaker? A. One record in a table is associated with one record in another table B. One record is related to multiple records in another table C. Multiple records are linked to multiple records in another table D. No relationship between tables Correct Answer: B Explanation: A one-to-many relationship means that one record in a parent table can be linked to many records in a related child table.
Correct Answer: A Explanation: Auto-enter options in FileMaker allow fields to automatically capture values such as timestamps when records are created or modified. Question 16: What is the primary purpose of FileMaker calculations? A. To format layout objects B. To process and compute data based on defined formulas C. To manage relationships between tables D. To design database schemas Correct Answer: B Explanation: Calculations in FileMaker are used to compute values dynamically based on expressions, formulas, or functions. Question 17: Which FileMaker function is used to perform aggregate calculations on related records?
A. Sum() B. Get() C. Left() D. Upper() Correct Answer: A Explanation: The Sum() function aggregates numeric values, often used in summary fields to total values from related records. Question 18: How can FileMaker developers import external data into a FileMaker database? A. Using the Print Setup B. Through the Import Records function C. With the Relationship Graph D. Via the Calculation Engine Correct Answer: B Explanation: The Import Records feature in FileMaker allows you to
B. Get(CurrentUser) C. Left() D. Sum() Correct Answer: C Explanation: The Left() function returns a specified number of characters from the beginning of a text string. Question 21: In the context of FileMaker’s interface, what does the Navigator Pane allow you to do? A. Edit scripts B. Switch between layouts, tables, and scripts C. Run calculations D. Monitor file performance Correct Answer: B Explanation: The Navigator Pane provides quick access to different parts of a FileMaker solution, including layouts, tables, and scripts.
Question 22: Which term describes a stored FileMaker script that can be executed to automate tasks? A. Script Parameter B. Custom Function C. Script Trigger D. Stored Procedure Correct Answer: C Explanation: A script trigger executes a stored script automatically in response to a defined event, such as a field modification or a layout change. Question 23: What is the purpose of FileMaker Data API? A. To configure security settings B. To allow external applications to interact with FileMaker databases C. To design layout templates D. To perform auto-entry calculations
Question 25: In a one-to-many relationship, which key is used in the child table to connect with the primary key of the parent table? A. Foreign key B. Summary key C. Calculation key D. Global key Correct Answer: A Explanation: The foreign key in the child table stores the value of the parent table’s primary key to establish the relationship between the two tables. Question 26: Which FileMaker security feature restricts user access to specific records or fields? A. Layout themes B. Privilege sets C. Calculation fields D. Import options
Correct Answer: B Explanation: Privilege sets allow administrators to configure security permissions, thereby restricting users’ access to certain records, fields, or layout functions. Question 27: How is encryption typically applied within a FileMaker solution? A. On layout design only B. Through file-level encryption and field-level encryption settings C. By altering calculation scripts D. Via custom function modifications Correct Answer: B Explanation: FileMaker solutions use file-level encryption for securing the database file and provide field-level encryption to protect sensitive information.
Correct Answer: A Explanation: Committing records saves any changes made to a record’s fields, ensuring data is written to the database. Question 30: Which FileMaker field type is best suited for performing summations and aggregate operations? A. Text field B. Number field C. Container field D. Global field Correct Answer: B Explanation: Number fields are used for arithmetic and aggregation operations, making them ideal for summing data. Question 31: What is the significance of a “join table” in a many-to- many relationship?
A. It simplifies layout design B. It acts as an intermediary table linking records from two tables C. It enhances script performance D. It is used for auto-entry calculations Correct Answer: B Explanation: A join table is a relational table that connects two tables in a many-to-many relationship by holding pairs of primary keys from each table. Question 32: In FileMaker, what are portal filters used for? A. To calculate numerical fields B. To limit the records displayed in a portal C. To encrypt data D. To define script triggers Correct Answer: B Explanation: Portal filters allow you to restrict or limit the subset of
