FM0-308 - Developer Essentials for FileMaker 13

Go back to FileMaker

Example Questions

The table Model has the container field Portrait. The following calculation is called: GetContainerAttribute (Model: : Portrait ; "image") Assuming Model::Portrait contains an image, what is returned? LAN users of a hosted database are reporting slow performance. A Performance Monitor log file from the FileMaker Server 13 machine reports a consistently high value on the Network Interface/Output Queue Length Performance Object Counter. The server has dual processors, 4GB of RAM and three 7200 RPM hard drives configured using RAID 5. Which two steps would most likely improve performance? (Choose two.) Which two statements are true about the insect From Device script step? (Choose two.) Which is a valid use of the Let () function in a formula for a FileMaker 13 calculation field? Which are two valid choices for directly importing records into a FileMaker Pro 13 file? (Choose two.) Which method can be used to sort related records within a portal in a FileMaker 13 solution? Which three conditions must be met to allow user access via accounts that are externally authenticated? (Choose three) What is the maximum number of files that can be hosted on FileMaker Server 13? Which two are required for a FileMaker Pro 13 user to access a supported external SQL Source (ESS) from a file being hosted by FileMaker Server 13? (Choose two.) What can be done with an ExecuteSOL calculation function? Given the following return-delimited data in a Team field of a FileMaker 13 solution: - Andy Jones - Bernie Lee - Carry Lane Which formula would result in the string "Bernie Lee" (without quotes or leading/trailing carriage returns) from Team? Which statement is true about enabling database encryption in FileMaker Pro 13 Advanced? Which two statements are true about publishing data to the web using the FileMaker 13 platform? (Choose two.) Which three methods can be used to access an ODBC data source from within FileMaker Pro 13? (Choose three.) Which two techniques could be used to successfully generate the data points for a pie chart? (Choose two.) Which two actions can be performed using the fmsadmin command line interface (CLI) tool? (Choose two.) Which two features of FileMaker Pro 13 require indexing in order to work? (Choose two.) Which two statements are true if two windows in a solution accessed by FileMaker Pro 13 display records based on the same layout? (Choose two.) Which two statements are true about a Web Viewer object viewed on a layout in FileMaker Pro 13? (Choose two.) Which two statements are true about OnTimer triggers? (Choose two.) Which statement is true about a container field set to Store container data externally in FileMaker 13? Which two options are available for providing credentials when connecting, via ESSI to a Microsoft SQL Server external ODBC data source in FileMaker 13? (Choose two.) Which two functions should be used with a script trigger to detect when a user types a backspace character in a field? (Choose Two) What is the maximum number of recursive calls that can be made utilizing a custom function in FileMaker Pro 13 Advanced? Which statement is true about encrypting network traffic in FileMaker 13? Which two are valid types listed in the FileMaker Pro 13 Export Records to File dialog? (Choose two.) Which two statements are true when a script is installed on a window using the Install OnTimer Script step? (Choose two.) Which statement is true about enabling database encryption in FileMaker 13? Which two actions can be performed via scripts? (Choose two.) Which statement is true about the Filter Portal Records feature in FileMaker Pro 13? Which two statements are true about the [Full Access] privilege set in a FileMaker 13 solution? (Choose two.) Which three statements are true about FileMaker WebDirect? (Choose three.) Which statement is true about supplemental fields added to a shadow table based on an External ODBC Data Source that uses MySQL? Given a text field myText that contains "red-blue-green", which two formulas could be used to extract the word "blue" from the field? (Choose two.) Given the following function: Substitute ( myText ; ["abc" ; "XYZ"] ; [ "XYZ" ; "abc"] ) If the field myText contains "abc-xyz", what is the result? Which two statements are true about setting up a System-level Script to run as a scheduled script in FileMaker Server 13? (Choose two.) A FileMaker 13 solution 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 solution hosted on FileMaker Server 13 contains a text field called ColorChoice that uses global storage. User A and User B are using the file. User A runs a script that changes the value in the ColorChoice field. User A logs off and User B continues working. User B runs a script that modifies the ColorChoice field after User A has logged off. If there is no other activity in the database, when User A logs back in, which value will User A see in the ColorChoice field? Which two statements are true of security in a FileMaker 13 solution? (Choose two.) Which two statements are true about overriding the default behavior of the Quick Find box available in the Status Toolbar in FileMaker Pro 13? (Choose two.) Which statement is true when developing the user experience for a FileMaker WebDirect solution? Which two FileMaker Pro 13 objects will display data contents even if unrelated to the current layout's table occurrence? (Choose two.) A text field called FirstLast in FileMaker Pro 13 is set to auto-enter the following formula: FirstName & " " & LastName FirstName and LastName 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 table in a FileMaker 13 solution has a text field CompanyName. The following field validation options are set for this field: - Validate data in this field only during data entry - Allow user to override during data entry - Require not empty - Display custom message if validation fails A user imports a set of records into this table. Some records have no value in the CompanyName field. What will occur? In which two cases will the object name of a button be available to a script that is performed by the button? (Choose two.) Which two protocols are supported by the Insert from IJRL script step in FileMaker 13? (Choose two) A solution has a Customer table and an Order table. On a layout based on the Customer table there is a portal showing related orders for the current calendar year. The portal does not include a filter formula. There is a calculation field in the Customer table. zSumOrders, that adds up the total amount of all the customer's orders for the year. zSumOrders is included on the layout. Assuming no changes to the data, what may cause the displayed value of zSumOrders on a customer record to change? Given Table A in File A, which condition allows a user to access data from Table A while using another file called File B? Which two types of fields will always be EXCLUDED from the search when a user performs a Quick Find? (Choose two.) A FileMaker 13 solution has a Customer table and a related Contact table. The relationship from Customer to Contact is configured to create related records in the Contact table. On the Relationships Graph, an external table occurrence called Invoice is referenced and is related to the Customer table. The solution has layouts based on the Customer, Contact, and Invoice table occurrences. The following script is used: Script A: New Record/Request A button that performs Script A has been placed on the Customer layout in a portal that displays the related Contact records. Which two statements are true about this situation? (Choose two.)