Download Developer Essentials for FileMaker 12 Exam and more Exams Technology in PDF only on Docsity!
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.
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 22: Which layout mode is used for modifying the design of a FileMaker 12 database? A. Browse Mode B. Find Mode C. Layout Mode D. Preview Mode Answer: C Explanation: Layout Mode is used to design and modify the appearance of FileMaker layouts. Question 23: How does FileMaker 12 support conditional formatting on layouts? A. Through auto-enter options only B. By using script triggers exclusively C. Via formatting rules that change appearance based on data D. By modifying user accounts Answer: C Explanation: Conditional formatting rules allow layout objects to change their appearance based on data values. Question 24: What is the significance of using themes in FileMaker 12 layouts? A. They control the licensing of the application B. They ensure a consistent visual style across layouts C. They determine file storage locations D. They manage database relationships Answer: B Explanation: Themes help maintain a consistent design and style across multiple layouts. Question 25: Which FileMaker 12 tool is primarily used to automate repetitive tasks? A. Calculation engine B. Script workspace C. Relationship graph D. Container field manager Answer: B Explanation: The script workspace allows developers to create and manage scripts that automate tasks within FileMaker. Question 26: In scripting, what is the purpose of the “If” script step in FileMaker 12? A. To export data B. To create a new table C. To evaluate a condition and execute steps accordingly D. To change file permissions Answer: C Explanation: The “If” script step is used to evaluate a condition and run different script steps based on whether the condition is true. Question 27: What does the “Loop” script step allow you to do in FileMaker scripting? A. Execute a set of script steps repeatedly until a condition is met B. Create a relationship between tables C. Format text fields
Question 33: What is the role of the Let statement in FileMaker calculations? A. To assign a temporary value to a variable within the calculation B. To define a new layout C. To create a relationship D. To set security privileges Answer: A Explanation: The Let statement allows you to define variables for use in calculations, improving readability and efficiency. Question 34: How does FileMaker handle null and empty values in calculations? A. It treats them as identical to zero B. It ignores them completely C. It provides functions and logic to manage them explicitly D. It converts them to text automatically Answer: C Explanation: FileMaker includes functions and logical operators to handle null and empty values appropriately in calculations. Question 35: Which of the following is a summary function in FileMaker 12? A. Average B. Replace C. LeftWords D. Trim Answer: A Explanation: Summary functions such as Average are used to perform calculations on groups of records. Question 36: What is the main purpose of sub-summary parts in FileMaker reports? A. To provide detailed record information B. To display grouped summary data when records are sorted C. To create layout backgrounds D. To manage file permissions Answer: B Explanation: Sub-summary parts are used to display summary information for groups of records when the data is appropriately sorted. Question 37: How do sorting records affect summary reports in FileMaker 12? A. Sorting does not affect summaries B. Sorting organizes records so that sub-summary parts display accurate grouped data C. Sorting only changes the file size D. Sorting converts text fields to numbers Answer: B Explanation: For sub-summary parts to display correctly, records must be sorted by the field that defines the grouping. Question 38: What is a key consideration when designing cross-tab reports in FileMaker 12? A. The number of container fields B. The use of relationships and calculations to display matrix data
C. The file recovery settings D. The installation path of FileMaker Server Answer: B Explanation: Cross-tab reports rely on relationships and calculations to display data in a matrix format, grouping and summarizing information effectively. Question 39: Which mode in FileMaker 12 allows you to view how a report will appear when printed? A. Layout Mode B. Find Mode C. Browse Mode D. Preview Mode Answer: D Explanation: Preview Mode displays the report as it will appear in print, allowing final adjustments before printing. Question 40: What is the purpose of managing accounts in FileMaker 12 security? A. To design new layouts B. To control user access and permissions C. To manage container data D. To automate scripts Answer: B Explanation: Managing accounts ensures that users have the appropriate permissions and access levels to the database. Question 41: How do privilege sets contribute to FileMaker 12 security? A. They define the visual layout of the database B. They set detailed access rights and limitations for users C. They optimize calculation performance D. They encrypt container data Answer: B Explanation: Privilege sets specify what actions users can perform and what data they can access, forming a crucial part of the security model. Question 42: What are extended privileges in FileMaker 12 used for? A. To define additional layout themes B. To enable advanced access such as modifying scripts or running server-side operations C. To manage file backups D. To adjust performance settings Answer: B Explanation: Extended privileges allow administrators to grant extra capabilities beyond basic user access, such as performing administrative tasks. Question 43: How can record-level access control be implemented in FileMaker 12? A. By using conditional formatting B. Through calculation-based criteria in privilege sets C. By modifying container fields D. Through external file references
Explanation: ODBC/JDBC connectivity enables FileMaker to interact with external SQL databases, broadening integration capabilities. Question 49: Which protocol is used for FileMaker’s custom web publishing? A. FTP B. HTTP/HTTPS C. SMTP D. SNMP Answer: B Explanation: FileMaker uses HTTP/HTTPS protocols for custom web publishing, allowing web-based interactions with FileMaker data. Question 50: What does the FileMaker Data API allow developers to do? A. Design new layouts B. Interact with FileMaker data using web services C. Encrypt database files D. Create container fields automatically Answer: B Explanation: The Data API enables web services to access and manipulate FileMaker data externally. Question 51: In FileMaker Go development, what is a primary design consideration? A. Maximizing file size B. Optimizing layouts for smaller, touch-based screens C. Increasing the number of table occurrences D. Using desktop-specific functions only Answer: B Explanation: FileMaker Go layouts must be optimized for the smaller screens and touch interactions of iOS devices. Question 52: How do container fields behave differently on iOS devices in FileMaker Go? A. They do not support file attachments B. They are optimized for touch interactions and may support in-app image capture C. They automatically compress files D. They are converted to text fields Answer: B Explanation: Container fields on iOS devices are designed for touch-based interactions, including capturing images and signatures. Question 53: Which mobile feature is often integrated with FileMaker Go for capturing handwritten signatures? A. Barcode scanning B. Signature capture C. Voice recognition D. GPS tracking Answer: B Explanation: FileMaker Go supports signature capture, allowing users to sign directly on the mobile device.
Question 54: What is an important consideration for offline data capture in FileMaker Go? A. The availability of FileMaker Server B. The design of local data caching and sync strategies C. The use of desktop-only scripts D. The file encryption method Answer: B Explanation: Offline data capture requires effective local caching and synchronization methods to merge data when connectivity returns. Question 55: Which hosting solution is used for deploying FileMaker databases to multiple users? A. FileMaker Pro B. FileMaker Server C. FileMaker Go D. FileMaker WebDirect Answer: B Explanation: FileMaker Server is the primary hosting solution for deploying databases for multiple users. Question 56: What is one key difference between peer-to-peer and server-based file sharing in FileMaker 12? A. Peer-to-peer supports more concurrent users B. Server-based sharing offers centralized management and better performance for multiple users C. Peer-to-peer encrypts files automatically D. Server-based sharing does not support mobile access Answer: B Explanation: Server-based sharing, using FileMaker Server, provides centralized management and improved performance over peer-to-peer setups. Question 57: What is the purpose of scheduling backups in FileMaker Server? A. To update layout themes automatically B. To ensure that data is regularly saved and recoverable in case of failure C. To adjust calculation performance D. To manage user accounts Answer: B Explanation: Regular backup schedules protect data integrity by ensuring that recent changes are saved and can be restored if necessary. Question 58: Which FileMaker feature assists in monitoring system performance and detecting issues? A. Layout mode B. Server log file monitoring C. Calculation fields D. Global variables Answer: B Explanation: Monitoring log files through FileMaker Server helps administrators detect and diagnose performance issues or errors. Question 59: What does file cloning in FileMaker 12 refer to? A. Creating a backup copy of a database
C. It automatically updates user accounts D. It creates new layout themes Answer: B Explanation: Version control enables developers to track changes, revert to earlier versions, and collaborate more effectively. Question 65: What tool does FileMaker provide for debugging scripts? A. Data Viewer B. Script Debugger C. Layout Mode D. Calculation Monitor Answer: B Explanation: The Script Debugger is designed to step through and troubleshoot scripts in FileMaker. Question 66: How does the Data Viewer assist in troubleshooting in FileMaker 12? A. By displaying the file’s graphical layout B. By monitoring variable values and calculation results during script execution C. By encrypting the database D. By managing file sharing Answer: B Explanation: The Data Viewer allows developers to observe variable contents and calculation results in real time for debugging purposes. Question 67: What is a common cause of performance bottlenecks in FileMaker 12? A. Excessive use of container fields without proper indexing B. Overuse of global fields in layouts C. Poorly optimized scripts and calculations D. Too many layout themes Answer: C Explanation: Unoptimized scripts and calculations can lead to slow performance, especially with large datasets. Question 68: Which technique can help resolve record locking issues in FileMaker 12? A. Increasing container field size B. Implementing proper scripting controls and conflict resolution methods C. Changing layout themes D. Disabling encryption Answer: B Explanation: Effective scripting and conflict management strategies help reduce record locking problems in multi-user environments. Question 69: In FileMaker 12, what is the role of script triggers in debugging? A. They automatically fix errors B. They initiate scripts in response to certain actions, which can be monitored for debugging C. They compress the database file D. They create new user accounts Answer: B
Explanation: Script triggers execute scripts when specific events occur, making it easier to pinpoint when and where errors happen. Question 70: Which FileMaker 12 feature helps ensure data consistency across related records? A. Unindexed fields B. Relationship graph integrity C. Random field assignment D. Manual data entry only Answer: B Explanation: A well-designed relationship graph ensures data consistency by correctly linking related records across tables. Question 71: What does FileMaker 12 use to represent a relationship between two tables visually? A. Layout palette B. Relationships graph C. Script workspace D. Calculation editor Answer: B Explanation: The relationships graph visually represents how tables are connected within the database. Question 72: When creating a new FileMaker file, what is a best practice regarding file naming? A. Use a generic name like “Database1” B. Use descriptive names that indicate the file’s purpose and content C. Include special characters to increase complexity D. Use the same name as previous projects Answer: B Explanation: Descriptive and consistent naming conventions improve organization and future maintenance. Question 73: How can file security be enhanced at the operating system level for FileMaker files? A. By disabling encryption B. By setting proper file permissions and access rights on the host system C. By using global fields exclusively D. By increasing the file size limit Answer: B Explanation: Setting correct OS-level permissions ensures that only authorized users can access the physical database files. Question 74: What is one advantage of using external data sources in FileMaker 12? A. They reduce the need for table occurrences B. They allow data to be integrated from outside systems, enhancing flexibility C. They automatically create layouts D. They eliminate the need for scripting Answer: B Explanation: External data sources enable integration of data from various systems, broadening the database’s utility.
Question 80: How do gesture support and screen size considerations affect FileMaker Go layout design? A. They require additional container fields B. They necessitate simplified and touch-friendly interface designs C. They mandate the use of desktop layouts D. They limit the use of scripts Answer: B Explanation: Touch-based interfaces and varying screen sizes mean layouts need to be optimized for ease of use on mobile devices. Question 81: What is one key aspect of deploying FileMaker databases using FileMaker Server? A. Reducing file encryption B. Configuring server-side scripts and backup schedules C. Disabling all script triggers D. Removing user accounts Answer: B Explanation: FileMaker Server deployment involves configuring server-side processes such as scheduled backups and script execution to ensure smooth operation. Question 82: What is an important consideration when managing file versioning in FileMaker 12 deployment? A. Using the same file name for all versions B. Keeping clear version records to track changes and facilitate rollbacks C. Avoiding backups entirely D. Increasing file size limits manually Answer: B Explanation: Version management helps developers track changes and revert to earlier versions if issues arise, ensuring stability. Question 83: Which deployment method is best for ad hoc file sharing without a central server? A. FileMaker Server hosting B. Peer-to-peer sharing C. FileMaker Go only D. WebDirect exclusively Answer: B Explanation: Peer-to-peer sharing allows users to share files directly without relying on a central server, although it is less scalable. Question 84: How does FileMaker Server enhance user concurrency? A. It restricts user access to one at a time B. It manages multiple simultaneous connections efficiently C. It converts container fields to text D. It disables script triggers Answer: B Explanation: FileMaker Server is optimized to handle numerous concurrent connections, ensuring smooth multi-user experiences.
Question 85: Which backup strategy is recommended for FileMaker Server? A. Manual backups only B. Scheduled, automated backups to minimize data loss C. No backup strategy D. Relying solely on cloud storage Answer: B Explanation: Scheduled automated backups ensure that data is regularly saved, reducing the risk of data loss in case of failure. Question 86: What is the purpose of file consistency checks in FileMaker 12? A. To improve layout design B. To verify the integrity of database files and detect corruption C. To generate new relationships D. To automate data entry Answer: B Explanation: Consistency checks help identify and repair any issues within the file’s structure, ensuring data integrity. Question 87: How does cloning a FileMaker file aid in database maintenance? A. It creates a new layout automatically B. It provides a safe copy for testing and recovery without affecting the live file C. It encrypts the database permanently D. It merges multiple files into one Answer: B Explanation: Cloning creates a duplicate file that can be used for testing or restoration, safeguarding the production database. Question 88: Which practice contributes to maintaining clean and readable FileMaker scripts? A. Avoiding any comments B. Using descriptive names and inserting comments for clarity C. Combining all operations into one long script D. Relying on default names only Answer: B Explanation: Descriptive naming and thorough commenting help maintain clarity and ease future modifications. Question 89: What is one benefit of using third-party add-ons in FileMaker 12 development? A. They increase file size without benefits B. They extend functionality and can simplify complex tasks C. They remove the need for scripting D. They are required for basic operations Answer: B Explanation: Third-party add-ons provide additional tools and features that can streamline development and add functionality beyond the base product. Question 90: How does collaboration benefit from well-documented FileMaker development practices?
B. Number C. Date D. Container Answer: C Explanation: The Date field type is appropriate for storing dates, and calculations involving dates benefit from this format. Question 96: How can you improve search performance in a FileMaker 12 database? A. Avoid using indexes on search fields B. Index key fields that are frequently searched C. Use global fields for every search D. Disable relationships Answer: B Explanation: Indexing fields that are commonly used in searches can greatly improve search performance. Question 97: What is the purpose of using validation settings on FileMaker fields? A. To adjust layout colors B. To ensure that data entered meets specific criteria and prevents errors C. To automatically create relationships D. To compress file size Answer: B Explanation: Validation settings enforce data integrity by checking that input meets defined rules before it is saved. Question 98: Which FileMaker 12 calculation function would you use to convert text to uppercase? A. Lower B. Upper C. Trim D. Substitute Answer: B Explanation: The Upper function converts text strings to uppercase, which is useful for standardizing data. Question 99: What is one benefit of using the Data Viewer during script execution? A. It formats layouts automatically B. It displays real-time variable and calculation values for troubleshooting C. It encrypts the script D. It creates new relationships Answer: B Explanation: The Data Viewer allows developers to see the live values of variables and calculations, making it easier to debug scripts. Question 100: Which of the following best describes a portal in FileMaker 12 layouts? A. A method to encrypt data B. A layout object that displays related records from another table C. A type of calculation field
D. A user account management tool Answer: B Explanation: A portal is used to display and interact with a set of related records from a related table occurrence. Question 101: In FileMaker 12, what does the term “context” refer to when working with calculations? A. The visual style of a layout B. The table occurrence that determines which data is available for the calculation C. The encryption method used D. The network protocol in use Answer: B Explanation: Context in FileMaker calculations is determined by the table occurrence from which the calculation is executed, affecting the available fields and relationships. Question 102: Which FileMaker 12 function is used to obtain the current user’s account name? A. Get (CurrentUser) B. Get (UserName) C. AccountName D. UserAccount Answer: B Explanation: The Get (UserName) function returns the account name of the current user logged into the FileMaker file. Question 103: What does the “Exit Loop If” script step do? A. Exits the script entirely B. Terminates a loop when a specified condition is met C. Resets global variables D. Exports data to a file Answer: B Explanation: “Exit Loop If” stops the execution of a loop when its condition evaluates to true, preventing infinite loops. Question 104: How can you pass data between scripts in FileMaker 12? A. Using file-level encryption B. By using script parameters and setting script results C. Through layout themes D. By exporting CSV files Answer: B Explanation: Script parameters and results allow data to be passed between scripts, making them more modular and interactive. Question 105: Which FileMaker 12 field storage option helps optimize performance for container data? A. Storing container data externally B. Storing container data internally C. Using text fields instead of container fields
