FM0-308 - Developer Essentials for FileMaker 13
Go back to FileMaker
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?
A delimited list of all image metadata
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.)
Install an additional network card and team it with the existing card
Replace the network card with a model which has an on-board processor
Which two statements are true about the insect From Device script step? (Choose two.)
The Camera Options support the selection of the Front or Back camera.
The Bar Code Options allow the developer to select the types of bar codes scanned.
Which is a valid use of the Let () function in a formula for a FileMaker 13 calculation field?
To set the value of a global variable
Which are two valid choices for directly importing records into a FileMaker Pro 13 file? (Choose two.)
XML Data Source
ODBC Data Source
Which method can be used to sort related records within a portal in a FileMaker 13 solution?
Change the Sort records setting in the Edit Relationship dialog for the last relationship leading to the portal's table occurrence from the context of the layout's table occurrence on the Relationships Graph
Which three conditions must be met to allow user access via accounts that are externally authenticated? (Choose three)
The file must be hosted from FileMaker Server 13.
Account Group Name must match a Group Name defined on the external authentication server.
The associated privilege set must have the Extended Privilege Access via FileMaker Network (fmapp).
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.)
A compatible ODBC driver installed on the FileMaker Server 13 computer or the user's local computer
An External ODBC Data Source in the Manage External Data Sources dialog for the hosted FileMaker database
What can be done with an ExecuteSOL calculation function?
Count the number of unique values in a field from a set of related records.
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?
Middle (Team ; 12 ; 10)
Which statement is true about enabling database encryption in FileMaker Pro 13 Advanced?
To prevent repeated encryption password entry, two unhosted files must have both the same encryption password and Shared ID.
Which two statements are true about publishing data to the web using the FileMaker 13 platform? (Choose two.)
FileMaker WebDirect security and file visibility can be configured in FileMaker Pro 13.
FileMaker Pro 13 can export static HTML pages that can be further customized with HTML.
Which three methods can be used to access an ODBC data source from within FileMaker Pro 13? (Choose three.)
Execute SQL script step
Import Records script step
File > Manage > External Data Sources... menu item
Which two techniques could be used to successfully generate the data points for a pie chart? (Choose two.)
Concatenate multiple number fields from the current record into a return-delimited list.
Specify a summary field from the current found set as the data series and put the chart in a Leading Grand Summary layout part.
Which two actions can be performed using the fmsadmin command line interface (CLI) tool? (Choose two.)
Verify a hosted file
Stop the Web Publishing Engine
Which two features of FileMaker Pro 13 require indexing in order to work? (Choose two.)
Auto-complete using existing values
Dynamic value lists based on FileMaker tables
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.)
If a record is being edited in one window, it cannot be edited in the other window.
A find performed in one window will be available as a Recent Find in the other window.
Which two statements are true about a Web Viewer object viewed on a layout in FileMaker Pro 13? (Choose two.)
It can be placed in a popover object.
It can display web pages in List View rows, but not Table View rows.
Which two statements are true about OnTimer triggers? (Choose two.)
They only run when the application is idle.
Different OnTimer scripts can be installed in different windows.
Which statement is true about a container field set to Store container data externally in FileMaker 13?
Data will not be stored externally if the file is transferred to an iOS device and used via FileMaker Go 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.)
Specify username and password by calculation for each DSN
For the Windows client use the Use Windows Authentication (Single Sign-on)
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?
In a multi-machine FileMaker Server 13 deployment, network traffic between the Database Server and the Web Publishing Engine can be encrypted.
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.)
The script will run only when the application is idle.
The script will run on any new window created from the initial window.
Which statement is true about enabling database encryption in FileMaker 13?
Open storage can be enabled on encrypted files when hosted on FileMaker Server 13.
Which two actions can be performed via scripts? (Choose two.)
Delete an account
Change the password of another user's account
Which statement is true about the Filter Portal Records feature in FileMaker Pro 13?
Aggregate functions (e.g., Sum, Count) based on the portal's relationship will not be affected by the portal's filter formula.
Which two statements are true about the [Full Access] privilege set in a FileMaker 13 solution? (Choose two.)
It is the only privilege set that can view the Relationships Graph.
It is the only privilege set that can modify field options using the Field Picker
Which three statements are true about FileMaker WebDirect? (Choose three.)
It is possible to create a custom FileMaker WebDirect Home Page.
It is possible to create a URL that links directly to a FileMaker WebDirect solution, bypassing the home page.
It is possible to limit the list of databases visible on the FileMaker WebDirect Home Page to just the specific databases the current user may access.
Which statement is true about supplemental fields added to a shadow table based on an External ODBC Data Source that uses MySQL?
These fields may only be of type Summary or Calculation.
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.)
GetValue ( Substitute ( myText ; "_"; "¶" ) ; 2)
Middle ( myText ; Position ( myText "-" ; 1 ; 1 )+ 1 ; 4)
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.)
The System-level Script must reside in the Scripts subdirectory of FileMaker Server 13.
Using a Script Sequence, a System-level Script can be run before and after a FileMaker script.
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?
Any time the CompanyID field on the Customer record is modified
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?
The last value that was saved while the file was opened locally.
Which two statements are true of security in a FileMaker 13 solution? (Choose two.)
FileMaker account passwords are stored as a one-way hash.
Container data that is stored externally using Secure storage is encrypted.
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.)
The Perform Quick Find custom menu item must be installed.
The Get (QuickFindText ) function will return the text entered into the Quick Find box.
Which statement is true when developing the user experience for a FileMaker WebDirect solution?
Custom Menus have no effect.
Which two FileMaker Pro 13 objects will display data contents even if unrelated to the current layout's table occurrence? (Choose two.)
Globally stored number field placed in a portal
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 record is first created
The FirstName or LastName field is modified and the FirstLast field is empty
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?
All of the records will be imported, No error message will be displayed.
In which two cases will the object name of a button be available to a script that is performed by the button? (Choose two.)
When the button's object name is hard-coded into the script parameter associated with the button's script
When the button is tabbed to and then activated from the keyboard and the Get ( ActiveLayoutObjectName ) function is used in the script
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?
Change the criteria of the portal's relationship to further limit the set of records displayed in the Orders portal
Given Table A in File A, which condition allows a user to access data from Table A while using another file called File B?
The privilege set associated with the account that is logged into File A must allow access to the records in Table A.
Which two types of fields will always be EXCLUDED from the search when a user performs a Quick Find? (Choose two.)
Fields with global storage
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.)
When the button is clicked, a new record is created in the Customer table.
If the user is on the Contact layout and runs Script A from the Scripts menu, a new record will be created in the Contact table.