Download [FDM12B] Developer Essentials for FileMaker 12 Beta Certification Exam Study Guide and more Exams Technology in PDF only on Docsity!
FileMaker 12 Beta Certification Exam
Study Guide
Question 1. Which field type should be used to store a photograph that may be edited outside of FileMaker? A) Text B) Number C) Container (External) D) Calculation Answer: C Explanation: Container fields with external storage keep large binary data (e.g., photos) outside the .fmp12 file, allowing external editing without inflating the database size. Question 2. What does the “Do not replace existing value” option do when enabled for an Auto-Entry calculation? A) Prevents the calculation from running on new records B) Leaves the current field value unchanged when a record is edited C) Forces the field to be cleared before each calculation D) Disallows any manual entry into the field Answer: B Explanation: The toggle tells FileMaker to keep the existing value if the field already contains data, only applying the auto-entry on record creation. Question 3. Which validation rule guarantees that every record has a unique, non-blank identifier? A) Not Empty
FileMaker 12 Beta Certification Exam
Study Guide
B) Unique C) Existing D) Not Empty + Unique Answer: D Explanation: Combining “Not Empty” and “Unique” ensures the field cannot be blank and no two records share the same value. Question 4. When should you select “All” indexing for a field? A) When the field is used only for display B) When the field is part of a find request or sort operation C) When the field contains large text blobs D) When the field is a global variable Answer: B Explanation: “All” indexing creates a full index, speeding up finds and sorts that involve the field. Question 5. In the Relationship Graph, what does the “Anchor-Buoy” model describe? A) A one-to-one relationship using a self-join B) A primary table (anchor) linked to multiple related tables (buoys) C) A many-to-many relationship via a join table D) A circular relationship that causes infinite loops
FileMaker 12 Beta Certification Exam
Study Guide
Question 8. Which layout object is best suited for showing a list of related records that can be scrolled horizontally? A) Portal B) Tab Control C) Slide Control D) Web Viewer Answer: A Explanation: Portals display related records in a grid and can be set to scroll horizontally. Question 9. In FileMaker 12’s layout engine, what does a “Theme” primarily control? A) Data validation rules B) Object positioning on the layout C) Global font, color, and style settings across the file D) Script execution order Answer: C Explanation: Themes provide a consistent look (fonts, colors, borders) for all objects that use the theme. Question 10. Which layout object allows embedding a live web page inside a FileMaker layout? A) Container B) Chart
FileMaker 12 Beta Certification Exam
Study Guide
C) Web Viewer D) Pop-over Answer: C Explanation: The Web Viewer renders HTML content, enabling live web pages within a layout. Question 11. Why is the Table Occurrence (TO) assigned to a layout critical? A) It determines the file’s backup schedule B) It defines the script triggers available on the layout C) It sets the data context for fields, portals, and calculations on that layout D) It controls the file’s security privileges Answer: C Explanation: The TO establishes the context, affecting which fields are available and how related data is accessed. Question 12. Which data formatting option would you apply to show a number as currency with two decimal places? A) Date mask B) Number mask: “$#,##0.00” C) Time mask D) Custom function Answer: B
FileMaker 12 Beta Certification Exam
Study Guide
B) Define temporary variables within a calculation for readability and performance C) Create a new layout object D) Set script parameters Answer: B Explanation: Let() assigns names to intermediate results, reducing repeated calculations and improving clarity. Question 16. Which logical function evaluates multiple conditions and returns the first true result? A) If B) Case C) Choose D) Let Answer: B Explanation: Case evaluates each condition in order and returns the corresponding result for the first true condition. Question 17. How does the Context of a calculation affect its result? A) It determines which scripts can call the calculation B) It defines which table’s fields are directly accessible without explicit relationship paths C) It changes the calculation’s data type D) It sets the file’s security level
FileMaker 12 Beta Certification Exam
Study Guide
Answer: B Explanation: The starting table (context) dictates which fields are directly reachable; other tables require relationship traversals. Question 18. Which custom function type requires FileMaker Pro Advanced to create? A) Built-in function B) Script step C) Custom function (user-defined) D) Layout object Answer: C Explanation: Only FileMaker Pro Advanced provides the Custom Functions editor. Question 19. In a script, which step would you use to prevent the script from halting on an error? A) Set Error Capture [On] B) Perform Script C) Exit Script D) Set Variable Answer: A Explanation: Set Error Capture suppresses default error dialogs, allowing the script to handle errors manually.
FileMaker 12 Beta Certification Exam
Study Guide
D) All variables persist Answer: B Explanation: Global variables ($$) exist for the session and are cleared when the user logs out or the file is closed. Question 23. Which extended privilege allows a user to run scripts on a WebDirect session? A) fmapp B) fmwebdirect C) fmschedule D) fmdatabase Answer: B Explanation: The fmwebdirect privilege enables script execution and other actions in a WebDirect environment. Question 24. To restrict a user to view only their own orders, which technique is most appropriate? A) Set a password on the Orders table B) Use a calculation in the privilege set’s “Record Access” that compares $ $AccountName to the Order’s Owner field C) Hide the Orders layout D) Delete all other records Answer: B
FileMaker 12 Beta Certification Exam
Study Guide
Explanation: Record-level security can use a calculation comparing the current user’s account name to a field that identifies ownership. Question 25. Which backup strategy is recommended for a production FileMaker Server environment? A) Manual backup once a month B) Automated nightly backups with a retention period of at least 30 days C) Backup only when a file is closed D) No backup needed if using cloud storage Answer: B Explanation: Regular automated backups protect against data loss; a 30-day retention window provides recovery options. Question 26. When optimizing a file for FileMaker Go, which layout feature should be avoided? A) Tab Controls B) Pop-overs C) Fixed-width objects that extend beyond the screen width D) Conditional formatting Answer: C Explanation: Fixed-width objects that exceed the device screen cause horizontal scrolling and poor UX on mobile devices.
FileMaker 12 Beta Certification Exam
Study Guide
C) Microsoft Access Driver D) SQLite ODBC Driver Answer: A Explanation: The MySQL ODBC driver enables FileMaker to communicate with MySQL via ESS. Question 30. What is the primary purpose of the FileMaker API for PHP? A) To create native iOS apps B) To enable custom web publishing, allowing PHP scripts to interact with FileMaker data C) To generate PDF reports automatically D) To manage server backups Answer: B Explanation: The PHP API provides functions for connecting to a FileMaker server, executing finds, and manipulating records via web applications. Question 31. Which field option should you enable to ensure a field’s value is automatically trimmed of leading and trailing spaces? A) Auto-Enter Calculation: Trim( Self ) B) Validation: Not Empty C) Indexing: Minimal D) Storage: Global
FileMaker 12 Beta Certification Exam
Study Guide
Answer: A Explanation: Using an Auto-Enter calculation with Trim() removes unwanted spaces each time the field is saved. Question 32. Which relationship type is required to model a many-to-many association between Students and Courses? A) Direct one-to-many B) Self-join C) Join table (e.g., Enrollments) with two one-to-many relationships D) Circular relationship Answer: C Explanation: A join table holds the linking records, creating two one-to-many relationships that together represent many-to-many. Question 33. When using the “Lookup” auto-entry option, what data is retrieved? A) The value from the same field in the current record B) The value from the first related record in the lookup relationship C) The result of a calculation defined in the field options D) The maximum value of the field across all records Answer: B Explanation: Lookup pulls the value from the first related record based on the defined lookup relationship.
FileMaker 12 Beta Certification Exam
Study Guide
D) && (logical AND) Answer: C Explanation: Exponentiation (^) is evaluated before multiplication, addition, and logical operators. Question 37. Which script trigger runs each time a user clicks out of a field on a layout? A) OnObjectEnter B) OnObjectExit C) OnObjectSave D) OnObjectModify Answer: B Explanation: OnObjectExit fires when focus leaves a layout object, such as a field. Question 38. What is the effect of setting a field’s storage to “Global”? A) The field is stored in each record separately B) The field’s value is shared across all records and windows for the current user session C) The field cannot be indexed D) The field is read-only Answer: B
FileMaker 12 Beta Certification Exam
Study Guide
Explanation: Global fields hold a single value per user session, accessible from any record. Question 39. Which option in the Relationship Graph controls whether related records are automatically sorted when displayed in a portal? A) Sort related records by field B) Allow creation of records in this table via this relationship C) Delete related records in this table when parent is deleted D) Use portal filter Answer: A Explanation: “Sort related records by field” defines the order of related records shown in portals. Question 40. Which calculation function would you use to replace all occurrences of “cat” with “dog” in a text string? A) Substitute( text ; “cat” ; “dog” ) B) Replace( text ; “cat” ; “dog” ) C) Filter( text ; “cat” ) D) Trim( text ) Answer: A Explanation: Substitute performs a find-and-replace operation on the entire string. Question 41. When creating a script that loops through all records in a found set, which step must appear inside the loop to move to the next record?
FileMaker 12 Beta Certification Exam
Study Guide
D) Slide Controls Answer: B Explanation: Large portals require many server-side queries and can significantly slow WebDirect pages. Question 44. Which script step can be used to temporarily suppress the display of a dialog box that would otherwise appear due to an error? A) Set Error Capture [On] b) Show Custom Dialog c) Perform Script d) Exit Script Answer: A Explanation: Set Error Capture disables the default error dialog, allowing the script to handle the error programmatically. Question 45. Which function returns the ISO-8601 week number for a given date? A) WeekOfYear( date ) B) ISOWeekNumber( date ) c) Weekday( date ) d) DayOfYear( date ) Answer: A
FileMaker 12 Beta Certification Exam
Study Guide
Explanation: WeekOfYear returns the week number according to ISO- 8601 standards. Question 46. What does the “Allow creation of records in this table via this relationship” setting do when the related field is a portal? A) It disables portal editing B) It enables users to add new child records directly from the portal C) It forces the portal to be read-only D) It deletes portal rows when the parent is deleted Answer: B Explanation: Enabling this setting lets users create new related records by interacting with the portal’s empty row. Question 47. Which script trigger runs when a user opens a new window from the File menu? A) OnFirstWindowOpen B) OnWindowOpen C) OnLayoutEnter D) OnModeEnter Answer: B Explanation: OnWindowOpen fires each time a new window is opened, whereas OnFirstWindowOpen only runs for the first window of the session. Question 48. Which calculation operator concatenates two text strings?
