How to Pass Developer Essentials for FileMaker
Today, I am posting some important questions and answers of Developer Essentials for FileMaker which will help you in exam preparation.
FileMaker is a cross-platform relational database application from FileMaker Inc., formerly Claris, a subsidiary of Apple Inc. It integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms.
QUESTION 1
Which method can be used to sort related records within a portal in a FileMaker 13 solution?
ANSWER
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.
QUESTION 2
Which two actions could generate a line chart that contains multiple lines?
ANSWER
1) Set the chart to use data from Related Records and specify multiple data series, each based on a related number field.
2) Set the chart to use data from Current Found Set and specify multiple data series, each referencing a single number field.
QUESTION 3
For which two is it possible to specify conditional formatting?
ANSWER
1) A tab panel.
2) A merge symbol (e.g. {{CurrentDate}})
QUESTION 4
Which two statements are true about a Web Viewer object viewed on a layout in FileMaker Pro 13?
ANSWER
1) It can be placed in a popover object.
2) It can display web pages in List View rows, but not Table View rows.
QUESTION 5
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?
ANSWER
Change the criteria of the portal's relationship to further limit the set of records displayed in the Orders portal.
QUESTION 6
Which two statements are true regarding layout themes and styles in FileMaker Pro 13?
ANSWER
1) New custom themes can only be created from existing themes.
2) Using Copy Object Style on Button 1 followed by Paste Object Style on Button 2 will not affect the named style associated with Button 2.
QUESTION 7
Which function returns a unique, unchanging identifier of a computer using FileMaker Pro 13?
ANSWER
Get ( PecsistentID )
QUESTION 8
Which two functions should be used with a script trigger to detect when a user types a backspace character
in a field?
ANSWER
1) Code
2) Get (TriggerKeystroke)
QUESTION 9
Which is a valid use of the Let () function in a formula for a FileMaker 13 calculation field?
ANSWER
To set the value of a global variable.
QUESTION 10
Given the following function:
Substitute ( myText ; ["abc" ; "XYZ"] ; [ "XYZ" ; "abc"] )
If the field myText contains "abc-xyz", what is the result?
ANSWER
abc-xyz
QUESTION 11
When writing a script that will edit a record in FileMaker Pro 13, which test will determine if a different user had the record locked?
ANSWER
Use the Open Recocd/Request script step, and then a test to see if an error occurred.
QUESTION 12
Which two protocols are supported by the insect from URL script step in FileMaker 13?
ANSWER
1) FTPS
2) HTTPS
QUESTION 13
Which two statements are true regarding the Go to Related Recocds script step?
ANSWER
1) The script step can specify a layout in another FileMaker 13 file as the destination layout.
2) The script step has the option to show records related to the current record only or to all the records in the found set.
QUESTION 14
Which two statements are true about the [Full Access] privilege set in a FileMaker 13 solution?
ANSWER
1) It is the only privilege set that can view the Relationships Graph.
2) It is the only privilege set that can modify field options using the Field Picker.
QUESTION 15
Given Table A in File A, which condition allows a user to access data from Table A while using another file called File B?
ANSWER
The privilege set associated with the account that is logged into File A must allow access to the records in Table A.
QUESTION 16
A FileMaker Pro 13 database is hosted on FileMaker Server 13 running on Windows Server 2008. Which two will allow a FileMaker Pro 13 client on OS X to access an External Data Source through ESS in this hosted database?
ANSWER
1) The Windows ODBC driver is configured with a System DSN to the external data source on the FileMaker Server computer.
2) Authentication for the data source is set to prompt user for user name and password in the Edit Data Source dialog box for Manage External Data Sources.
QUESTION 17
Which two statements are true of security in a FileMaker 13 solution?
ANSWER
1) FileMaker account passwords are stored as a one-way hash.
2) Container data that is stored externally using Secure storage is encrypted.
QUESTION 18
According to the FileMaker Server Configuration Guide, which two practices are recommended for backing up databases hosted by FileMaker Server 13?
ANSWER
1) Use the Server Admin Console Schedule Assistant or fmsadmin tool to perform backups.
2) Upgrading the disk sub-system and increasing memory are primary considerations when trying to increase the speed of backups.
QUESTION 19
Which two actions can be performed using the fmsadmin command line interface (CLI) tool?
ANSWER
1) Verify a hosted file.
2) Stop the Web Publishing Engine
QUESTION 20
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?
ANSWER
1) Install an additional network card and team it with the existing card.
2) Replace the network card with a model which has an on-board processor.
QUESTION 21
What is needed to use the Send Mail script step to send an email from a FileMaker Server 13 hosted database, using a server-side script?
ANSWER
The Send Mail script step must have properly configured SMTP Options for Send via: SMTP Server.
QUESTION 22
Which two components are required to use all of the features of FileMaker Server 13 for Windows?
ANSWER
1) PHP engine
2) Bonjour service
QUESTION 23
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?
ANSWER
1) A compatible ODBC driver installed on the FileMaker Server 13 computer or the user's local computer
2) An External ODBC Data Source in the Manage External Data Sources dialog for the hosted FileMaker database.
QUESTION 24
Which are two valid choices for directly importing records into a FileMaker Pro 13 file?
ANSWER
1) XML Data Source
2) ODBC Data Source
QUESTION 25
Which statement is true when developing the user experience for a FileMaker WebDirect solution?
ANSWER
Custom Menus have no effect.
QUESTION 26
Which two types of fields will always be EXCLUDED from the search when a user performs a Quick Find?
ANSWER
1) Summary fields
2) Fields with global storage
QUESTION 27
Which two statements are true when a script is installed on a window using the Install OnTimer Script step?
ANSWER
1) The script will run only when the application is idle.
2) The script will run on any new window created from the initial window.
QUESTION 28
Which two statements are true about the insect From Device script step?
ANSWER
1) The Camera Options support the selection of the Front or Back camera.
2) The Bar Code Options allow the developer to select the types of bar codes scanned.
QUESTION 29
Which statement is true when using the FMP protocol in FileMaker Go 13?
ANSWER
Multiple local variables can be defined in the syntax.
QUESTION 30
What is the maximum number of files that can be hosted on FileMaker Server 13?
ANSWER
125
QUESTION 31
What is the maximum number of recursive calls that can be made utilizing a custom function in FileMaker Pro 13 Advanced?
ANSWER
50,000
QUESTION 32
Which three field options may be set for a shadow field from an External ODBC Data Source?
ANSWER
1) Validation: not empty
2) Auto-enter creation timestamp
3) Auto-enter serial number, on creation
QUESTION 33
Which two FileMaker Pro 13 objects will display data contents even if unrelated to the current layout's table occurrence?
ANSWER
1) Merge variable
2) Globally stored number field placed in a portal
QUESTION 34
Which two statements are true about field indexing in FileMaker Pro 13?
ANSWER
1) A field must be indexed in order for Auto-complete using previously entered values to function.
2) Minimal indexing indicates that either the value index or the word index has been created, but not both.
QUESTION 35
What can be done with an ExecuteSOL calculation function?
ANSWER
Count the number of unique values in a field from a set of related records.
FileMaker is a cross-platform relational database application from FileMaker Inc., formerly Claris, a subsidiary of Apple Inc. It integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms.
QUESTION 1
Which method can be used to sort related records within a portal in a FileMaker 13 solution?
ANSWER
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.
QUESTION 2
Which two actions could generate a line chart that contains multiple lines?
ANSWER
1) Set the chart to use data from Related Records and specify multiple data series, each based on a related number field.
2) Set the chart to use data from Current Found Set and specify multiple data series, each referencing a single number field.
QUESTION 3
For which two is it possible to specify conditional formatting?
ANSWER
1) A tab panel.
2) A merge symbol (e.g. {{CurrentDate}})
QUESTION 4
Which two statements are true about a Web Viewer object viewed on a layout in FileMaker Pro 13?
ANSWER
1) It can be placed in a popover object.
2) It can display web pages in List View rows, but not Table View rows.
QUESTION 5
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?
ANSWER
Change the criteria of the portal's relationship to further limit the set of records displayed in the Orders portal.
QUESTION 6
Which two statements are true regarding layout themes and styles in FileMaker Pro 13?
ANSWER
1) New custom themes can only be created from existing themes.
2) Using Copy Object Style on Button 1 followed by Paste Object Style on Button 2 will not affect the named style associated with Button 2.
QUESTION 7
Which function returns a unique, unchanging identifier of a computer using FileMaker Pro 13?
ANSWER
Get ( PecsistentID )
QUESTION 8
Which two functions should be used with a script trigger to detect when a user types a backspace character
in a field?
ANSWER
1) Code
2) Get (TriggerKeystroke)
QUESTION 9
Which is a valid use of the Let () function in a formula for a FileMaker 13 calculation field?
ANSWER
To set the value of a global variable.
QUESTION 10
Given the following function:
Substitute ( myText ; ["abc" ; "XYZ"] ; [ "XYZ" ; "abc"] )
If the field myText contains "abc-xyz", what is the result?
ANSWER
abc-xyz
QUESTION 11
When writing a script that will edit a record in FileMaker Pro 13, which test will determine if a different user had the record locked?
ANSWER
Use the Open Recocd/Request script step, and then a test to see if an error occurred.
QUESTION 12
Which two protocols are supported by the insect from URL script step in FileMaker 13?
ANSWER
1) FTPS
2) HTTPS
QUESTION 13
Which two statements are true regarding the Go to Related Recocds script step?
ANSWER
1) The script step can specify a layout in another FileMaker 13 file as the destination layout.
2) The script step has the option to show records related to the current record only or to all the records in the found set.
QUESTION 14
Which two statements are true about the [Full Access] privilege set in a FileMaker 13 solution?
ANSWER
1) It is the only privilege set that can view the Relationships Graph.
2) It is the only privilege set that can modify field options using the Field Picker.
QUESTION 15
Given Table A in File A, which condition allows a user to access data from Table A while using another file called File B?
ANSWER
The privilege set associated with the account that is logged into File A must allow access to the records in Table A.
QUESTION 16
A FileMaker Pro 13 database is hosted on FileMaker Server 13 running on Windows Server 2008. Which two will allow a FileMaker Pro 13 client on OS X to access an External Data Source through ESS in this hosted database?
ANSWER
1) The Windows ODBC driver is configured with a System DSN to the external data source on the FileMaker Server computer.
2) Authentication for the data source is set to prompt user for user name and password in the Edit Data Source dialog box for Manage External Data Sources.
QUESTION 17
Which two statements are true of security in a FileMaker 13 solution?
ANSWER
1) FileMaker account passwords are stored as a one-way hash.
2) Container data that is stored externally using Secure storage is encrypted.
QUESTION 18
According to the FileMaker Server Configuration Guide, which two practices are recommended for backing up databases hosted by FileMaker Server 13?
ANSWER
1) Use the Server Admin Console Schedule Assistant or fmsadmin tool to perform backups.
2) Upgrading the disk sub-system and increasing memory are primary considerations when trying to increase the speed of backups.
QUESTION 19
Which two actions can be performed using the fmsadmin command line interface (CLI) tool?
ANSWER
1) Verify a hosted file.
2) Stop the Web Publishing Engine
QUESTION 20
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?
ANSWER
1) Install an additional network card and team it with the existing card.
2) Replace the network card with a model which has an on-board processor.
QUESTION 21
What is needed to use the Send Mail script step to send an email from a FileMaker Server 13 hosted database, using a server-side script?
ANSWER
The Send Mail script step must have properly configured SMTP Options for Send via: SMTP Server.
QUESTION 22
Which two components are required to use all of the features of FileMaker Server 13 for Windows?
ANSWER
1) PHP engine
2) Bonjour service
QUESTION 23
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?
ANSWER
1) A compatible ODBC driver installed on the FileMaker Server 13 computer or the user's local computer
2) An External ODBC Data Source in the Manage External Data Sources dialog for the hosted FileMaker database.
QUESTION 24
Which are two valid choices for directly importing records into a FileMaker Pro 13 file?
ANSWER
1) XML Data Source
2) ODBC Data Source
QUESTION 25
Which statement is true when developing the user experience for a FileMaker WebDirect solution?
ANSWER
Custom Menus have no effect.
QUESTION 26
Which two types of fields will always be EXCLUDED from the search when a user performs a Quick Find?
ANSWER
1) Summary fields
2) Fields with global storage
QUESTION 27
Which two statements are true when a script is installed on a window using the Install OnTimer Script step?
ANSWER
1) The script will run only when the application is idle.
2) The script will run on any new window created from the initial window.
QUESTION 28
Which two statements are true about the insect From Device script step?
ANSWER
1) The Camera Options support the selection of the Front or Back camera.
2) The Bar Code Options allow the developer to select the types of bar codes scanned.
QUESTION 29
Which statement is true when using the FMP protocol in FileMaker Go 13?
ANSWER
Multiple local variables can be defined in the syntax.
QUESTION 30
What is the maximum number of files that can be hosted on FileMaker Server 13?
ANSWER
125
QUESTION 31
What is the maximum number of recursive calls that can be made utilizing a custom function in FileMaker Pro 13 Advanced?
ANSWER
50,000
QUESTION 32
Which three field options may be set for a shadow field from an External ODBC Data Source?
ANSWER
1) Validation: not empty
2) Auto-enter creation timestamp
3) Auto-enter serial number, on creation
QUESTION 33
Which two FileMaker Pro 13 objects will display data contents even if unrelated to the current layout's table occurrence?
ANSWER
1) Merge variable
2) Globally stored number field placed in a portal
QUESTION 34
Which two statements are true about field indexing in FileMaker Pro 13?
ANSWER
1) A field must be indexed in order for Auto-complete using previously entered values to function.
2) Minimal indexing indicates that either the value index or the word index has been created, but not both.
QUESTION 35
What can be done with an ExecuteSOL calculation function?
ANSWER
Count the number of unique values in a field from a set of related records.
Comments
Post a Comment