Developer Essentials for FileMaker Questions + Answers Part 1

[answerhappygod]

QUESTION 1
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. Thefilenameoftheimage
B. Adelimitedlistofallimagemetadata
C. The image file as BaseG4 encoded text
D. The type of the image file (jpeg, png, gif, etc)
Correct Answer: B Section: (none) Explanation
Explanation/Reference:
QUESTION 2
What can be done with an ExecuteSOL calculation function?
A. Countthenumberofuniquevaluesinafieldfromasetofrelatedrecords.
B. Populateafieldinasetofrelatedrecordswiththeresultofacalculationfunction.
C. Find the number of records in the current found set that match certain query criteria. D. Insert a new record into a table and populate it with values from global script variables.
Correct Answer: A Section: (none) Explanation
Explanation/Reference:
QUESTION 3
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?
A. ListValues (Team ; 2)
B. Middle (T eam ; 12 ; 10)
C. GetValue (Team ; ¶ ; 2)
D. MiddleValues (Team ; 2 ; 1)
E. Trim(Middlewords(Team;3;4))
Correct Answer: B Section: (none) Explanation
Explanation/Reference:
QUESTION 4
The following formula in a calculation field returns a Text result: Let( tmp = "2 * 5" Evaluate( Quote ( tmp ) ) )
What value will be returned?
A. 10
B. 2*5
C. "10", quotes included D. "2 * 5", quotes included
Correct Answer: B Section: (none) Explanation

Explanation/Reference:
answer is corrected.
QUESTION 5
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.)
A. Filter ( myT ext ; "blue" )
B. MiddleValues(myText;2;1
C. PatternMatch ( myText ; "blue"
D. GetValue ( Substitute ( myText ; "_"; "¶" ) ; 2)
E. Middle(myText;Position(myText"-";1;1)+1;4)
Correct Answer: DE Section: (none) Explanation
Explanation/Reference:
QUESTION 6
Which formula returns the calendar quarter (1. 2. 3, 4) of a date contained in a field called myDate?

A. Option A B. OptionB C. Option C D. Option D
Correct Answer: C Section: (none) Explanation
Explanation/Reference:
QUESTION 7
Given a custom function created in FileMaker Pro 13 Advanced defined as Explode (str):

What is the result of Explode (Bob)?
A. Bo B
B. B Bo
C. B B
D. B Bo
Bo
Bo
Bob
E. Bob Bo
B
Correct Answer: C Section: (none) Explanation
Explanation/Reference:
QUESTION 8
The tab control object shown below is configured with an OnPanelSwitch script trigger.


Which formula could be used in a conditional test to detect if the user clicked on the "Map" tab panel?
A. Get(ActivePanel)=4
B. Get(TriggerTargetPanel)="Map"
C. GetValue ( Get (TriggerTargetPanel) ; 1 ) = 4 D. PatternCount ( Get (ActivePanel) ; "Map" ) > 0
Correct Answer: C Section: (none) Explanation

Explanation/Reference:
QUESTION 9
Which two actions can be performed via scripts? (Choose two.)
A. Deleteanaccount
B. Deactivateaprivilegeset
C. Create an extended privilege
D. Enable an extended privilege for a privilege set E. Changethepasswordofanotheruser'saccount
Correct Answer: AE Section: (none) Explanation
Explanation/Reference:
QUESTION 10
Which two protocols are supported by the Insert from IJRL script step in FileMaker 13? (Choose two)
A. XML
B. FTPS C. SMTP D. WSDL E. HTTPS
Correct Answer: BE Section: (none) Explanation
Explanation/Reference:
QUESTION 11
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?
A. Novalue:thefieldwillbeempty.
B. ThelastvaluethatUserA'sscriptenteredintothefield.
C. The last value that User B's script entered into the field.
D. The last value that was saved while the file was opened locally.
Correct Answer: D Section: (none) Explanation
Explanation/Reference:
QUESTION 12
Given a FileMaker Pro 13 solution containing the following two scripts:
When Script A executes, how many beeps will be heard?

A. 3 B. 4 C. 5 D. 6
Correct Answer: C Section: (none) Explanation
Explanation/Reference:
QUESTION 13
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.)
A. Whenthebuttonisclicked,anewrecordiscreatedintheContacttable.
B. Whenthebuttonisclicked,anewrecordiscreatedintheCustomertable.
C. 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.
D. Without a Go to Layout script step, Script A cannot be run from the Scripts menu and create a new record in the Invoice table.
E. IftheuserisontheCustomerlayoutandrunsScriptAfromtheScriptsmenu,anewrecordiscreatedintheCustomertable,andanewrelatedrecordis created in the Contact table.
Correct Answer: BC Section: (none) Explanation
Explanation/Reference:
QUESTION 14

In which two cases will the object name of a button be available to a script that is performed by the button? (Choose two.)
A. WhentheSelffunctionisusedasthescriptparameterassociatedwiththebutton'sscript
B. Whenthebutton'sobjectnameishard-codedintothescriptparameterassociatedwiththebutton'sscript
C. When the button is clicked and the Get ( ActiveLayoutObjectName ) function is used in the script
D. When the button is tabbed to and then activated from the keyboard and the Get ( ActiveLayoutObjectName ) function is used in the script
Correct Answer: BD Section: (none) Explanation
Explanation/Reference:
QUESTION 15
A FileMaker 13 solution contains the following script:


How many records will the table contain after this script is done executing, if the script begins execution in a database table containing six records total?
A. 6
B. 11
C. 12
D. 13
E. Thescriptwillnotfinishexecutingbutwillloopuntilforciblyterminated.
Correct Answer: C Section: (none) Explanation
Explanation/Reference:
QUESTION 16
Given a solution hosted on FileMaker Server 13 with tables Employee and Asset. Employee and Asset are related (one to many) based on an Employee ID field with no cascading delete rule. There is one layout associated with each table as well as the following scripts.

There are 5 records in Employee {Andrew;Bob;Cara;David;Edward}. Each employee has exactly 3 related Asset records, for 15 total assets. A user opens the database and navigates to the fifth record {Edward}, then runs the script Remove Employee Assets.
What will be true after the script completes running?
A. Employeehas2records.Assethas15records.TheuserisviewingBobinEmployee.
B. Employeehas2records.Assethas15recordsTheuserisviewingEdwardinEmployee. C. Employee has 5 records. Asset has 12 records. The user is viewing Andrew in Employee. D. Employee has 5 records. Asset has 12 records. The user is viewing Edward in Employee. E. Employeehas5records.Assethas15records.TheuserisviewingthefirstrecordinAsset

Correct Answer: B Section: (none) Explanation
Explanation/Reference:
QUESTION 17
Which statement is true about script parameters in FileMaker 13?
A. Scriptparameterscanincludeanynumberofrepetitions.
B. Asub-scriptinheritsthescriptparameterofthescriptthatcalledit.
C. Scripts set to run OnFirstWindowOpen cannot include script parameters.
D. Get ( ScriptParameter ) results in a return-delimited list of script parameters for all currently running scripts in a window's script stack.
E. WhenchoosingscriptsfromtheScriptsmenu,scriptparameterscanbeaddedbyholdingdowntheOption(OSX)orAlt(Windows)keyS
Correct Answer: C Section: (none) Explanation
Explanation/Reference:
QUESTION 18
Which statement is true about enabling database encryption in FileMaker 13?
A. SharedIDsarerequiredtomatchforopeningmultiplefiles.
B. OpenstoragecanbeenabledonencryptedfileswhenhostedonFileMakerServer13.
C. A container field's external storage setting (open or secure) cannot be modified after the database is encrypted.
D. FileMaker Pro 13 clients will need to supply the encryption password, and a valid account name and password to open a file hosted on FileMaker Server 13. E. SelectingAutomaticallyopendatabases(onserver)afteruploadwillopenencryptedfilesontheserverwhenaserverAdministratoraccountisusedtoupload.
Correct Answer: B Section: (none) Explanation
Explanation/Reference:

QUESTION 19
Which three conditions must be met to allow user access via accounts that are externally authenticated? (Choose three)
A. ThefilemustbehostedfromFileMakerServer13.
B. AccountGroupNamemustmatchaGroupNamedefinedontheexternalauthenticationserver.
C. The associated privilege set must have the Extended Privilege Access via FileMaker Network (fmapp).
D. The associated privilege set must have the Extended Privilege Access via External Server Authentication (fmesa).
E. TheSpecifyDirectoryServiceSettingsintheFileMakerServerAdminConsolemustbeconfiguredtoincludetheLDAPServerAddress,Port,andSearchBase.
Correct Answer: ABC Section: (none) Explanation
Explanation/Reference:
answer is valid.
QUESTION 20
Which statement is true about encrypting network traffic in FileMaker 13?
A. NetworktrafficbetweenFileMakerServer13andanODBCclientcanbeencrypted.
B. NetworktraffictoFileMakerWebDirectclientsisencryptedregardlessoftheRequiresecureconnectionssettingintheServerAdminConsole.
C. In a multi-machine FileMaker Server 13 deployment, network traffic between the Database Server and the Web Publishing Engine can be encrypted.
D. Progressive downloads of container field data will always be encrypted regardless of the Require secure connections setting in the Server Admin Console.
Correct Answer: C Section: (none) Explanation
Explanation/Reference:
QUESTION 21
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.)


A. SpecifyusernameandpasswordbycalculationforeachDSN
B. FortheMacintoshclientusetheUseOpenDirectory(SingleSign-on)
C. For the Windows client use the Use Windows Authentication (Single Sign-on)
D. Create an extended privilege for each DSN and assign it to each privilege set needing access
E. SpecifytheusernameandpasswordintheextendedprivilegessectionoftheprivilegesetfortheDSNbeingaccessed
Correct Answer: AC Section: (none) Explanation
Explanation/Reference:
QUESTION 22
Assuming no File Access restrictions have been applied, what is the minimal requirement to add an external FileMaker Data Source table occurrence of Inventory from a file called DEPT to the Relationships Graph of a file called PROD?
A. Anactiveaccountassociatedwiththe[FullAccess]privilegesetinbothPRODandDEPT
B. AnactiveaccountassociatedwithaprivilegesetthathastheManageExternalDataSourcesoptioncheckedinbothPRODandDEPT
C. AnactiveaccountassociatedwithanyprivilegesetinPROD,andanactiveaccountassociatedwithaprivilegesetthathasviewrecordaccessfortheInventory table
D. An active account in DEPT associated with a privilege set that has the Manage External Data Sources option checked, and an active account with the [Full Access] privilege set in PROD
E. Anactiveaccountassociatedwiththe[FullAccess]privilegesetinPRODandanactiveaccountinDEPTassociatedwithaprivilegesetthathasviewrecord access for the Inventory table
Correct Answer: E Section: (none) Explanation

Explanation/Reference:
QUESTION 23
Which three statements are true when configuring a FileMaker Server 13 two-machine deployment for FileMaker Pro, FileMaker Go, and FileMakerWebDirect access? (Choose three.)
A. TheWorkermachinecanbeconfiguredasthedatabaseserver.
B. AWorkermachinerunstheWebPublishingEngineandthewebserveronly.
C. The FileMaker Script Engine (FMSE) can be installed on the Worker machine.
D. No existing websites should exist on the Master or Worker machines that use port 80 or 443.
E. TheMastermachinecanbeconfiguredbeforeinstallingFileMakerServer13ontheWorkermachine.
F. TheFileMakerServeruseraccountcanbethedefaultLocalSystem(Windows)/fmserver(OSX)oranalternateaccountwithsufficientprivileges.
Correct Answer: BDF Section: (none) Explanation
Explanation/Reference:
QUESTION 24
Which two statements are true about a Daily Backup Schedule that includes the option to keep a maximum of seven backups? (Choose Iwo.)
A. Ontheeighthbackup,FileMakerServermovestheoldestbackupcreatedbythatscheduletoanarchivefolder.
B. Ontheeighthbackup,FileMakerServerdeletestheoldestbackupcreatedbythatscheduleandreplacesitwithanewbackup.
C. FileMaker Server creates a subfolder each time the schedule is run and places all backups created at that time in the subfolder.
D. FileMaker Server creates a subfolder for the schedule and saves all backups to it, appending a timestamp to the name of each backed up file.
Correct Answer: BC Section: (none) Explanation
Explanation/Reference:
QUESTION 25
Which three are required to use all of the features of FileMaker Server 13 for OS X? (Choose three.)

A. SSH
B. PHPengine
C. Apache web server
D. The Console application
E. QuickTimePlug-inforMacintosh F. JavaRuntimeEnvironment(JRE)
Correct Answer: BCF Section: (none) Explanation
Explanation/Reference:
QUESTION 26
Which two statements are true about the Administrator Groups feature in FileMaker Server 13? (Choose two.)
A. AdministratorGroupsprovideanadditionallayerofdatasecurity.
B. AgivendatabasefilemayonlybepartofoneAdministratorGroupatatime.
C. A user must have full access privileges in a file before being made a member of that file's Administrator Group.
D. Administrator Groups may be used to grant additional administrators the ability to open, close and back up specific sets of hosted databases.
Correct Answer: BD Section: (none) Explanation
Explanation/Reference:
QUESTION 27
The FileMaker 13 file Customers is hosted from the FileMaker Server 13 default Data\Databases directory. Customers includes the table Rewards with a container field Photo, which uses external file storage.
By default, where in the directory structure does FileMaker Server 13 store the files for Photo?
A. ..\Data\Databases\RC_Data_FMS\Customers\Rewards\Photo\
B. ..\Common\Databases\MC_Data_FMS\Customers\Rewards\Photo\ C. . .\Database Server\FMSexternal_storage\Customers\Rewards\Photo\

D. . .\Data\Databases\FMS_managed_storage\Customers\Rewards\Photo\
Correct Answer: A Section: (none) Explanation
Explanation/Reference:
QUESTION 28
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. System-levelScriptscannotexecutefmsadmincommandlinecalls.
B. TheSystem-levelScriptmustresideintheScriptssubdirectoryofFileMakerServer13.
C. Using a Script Sequence, a System-level Script can be run before and after a FileMaker script.
D. By default the script will run as the user name specified for the Admin Console account under General Settings.
Correct Answer: BC Section: (none) Explanation
Explanation/Reference:
QUESTION 29
Which three field options may be set for a shadow field from an External ODBC Data Source? (Choose three.)
A. Validation:uniquevalue
B. Validation:existingvalue
C. Auto-enter: creation date
D. Storage: Minimal Indexing
E. Validation:validatedbycalculation
F. Auto-enter: serial number, on commit
Correct Answer: CEF Section: (none) Explanation
Explanation/Reference:

QUESTION 30
Which two are required for a user to successfully run a script that uses the Execute SQL script step? (Choose two.)
A. INSERT,UPDATE,andDELETEprivilegesinthedatasource
B. AcompatibleODBCdriveronthecomputerexecutingthescript
C. A table occurrence on the relationship graph to the shadow table
D. An ODBC Data Source Name (DSN) on the computer executing the script
Correct Answer: BD Section: (none) Explanation
Explanation/Reference:
QUESTION 31
Which three methods can be used to access an ODBC data source from within FileMaker Pro 13? (Choose three.)
A. ExecuteSQLscriptstep
B. ImportRecordsscriptstep
C. File > Sharing > ODBC/JDBC menu item
D. File > Import Records > Folder... menu item
E. File>Manage>ExternalDataSources...menuitem
Correct Answer: ABE Section: (none) Explanation
Explanation/Reference:
QUESTION 32
Which two are valid types listed in the FileMaker Pro 13 Export Records to File dialog? (Choose two.)
A. PDF B. XSL C. DBF

D. HTML Table
E. MDB(MicrosoftAccess)
Correct Answer: CD Section: (none) Explanation
Explanation/Reference:
QUESTION 33
Which three script steps are compatible with FileMaker WebDirect? (Choose three.)
A. AdjustWindow
B. InsertfromURL
C. Perform Quick Find
D. Enter Preview Mode
E. SetScriptAnimation
F. PerformScriptonServer
Correct Answer: BCF Section: (none) Explanation
Explanation/Reference:
up-to-date.
QUESTION 34
Which statement is true about FileMaker WebDirect?
A. Animationsaredisplayedonlayoutobjects.
B. Afileupto4GBcanbeinsertedintoacontainerfield.
C. Values in a value list can be edited using the "Edit" option.
D. Web Viewers are supported on layouts viewed in FileMaker WebDirect.
E. TheRefreshbuttonofthewebbrowsercanbeusedtorefreshthecurrentrecord.
Correct Answer: D Section: (none)

Explanation Explanation/Reference:
QUESTION 35
Which two statements are true about publishing data to the web using the FileMaker 13 platform? (Choose two.)

A. FileMakerPro13canbethehostofuptofiveFileMakerWebDirectclients.
B. FileMakerWebDirectsecurityandfilevisibilitycanbeconfiguredinFileMakerPro13.
C. FileMaker Pro 13 can export static HTML pages that can be further customized with HTML.
D. Custom Web Publishing users count as concurrent connections when using FileMaker Server 13.
E. EitherInstantWebPublishingorFileMakerWebDirectcanbeenabledonFileMakerServer13,butnotboth.
Correct Answer: BC Section: (none) Explanation
Explanation/Reference:
QUESTION 36
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.)
A. ThePerformQuickFindcustommenuitemmustbeinstalled.
B. TheShow/HideQuickFindscriptstepwillallowtheusertohidetheQuickFindbox.
C. The Get (QuickFindText ) function will return the text entered into the Quick Find box.
D. The OnModeExit script trigger can be used to override a find request issued from the Quick Find box.
Correct Answer: AC Section: (none)

Explanation Explanation/Reference:
QUESTION 37
Given a FileMaker Pro 13 solution with the following characteristics:
Named Clients.fmp12
Contains an active [Full Access] account named dev1 with the password p0werU$er
Contains a script named ListClients
Is hosted from a server with the IP address 17.182.101.135 Is hosted from a server with a DNS name FM_Host.FileMaker.com Which statement is true when entering a URL into a web browser on a client machine connected to the same local area network'?

A. Option A B. OptionB C. Option C

D. Option D
Correct Answer: B Section: (none) Explanation
Explanation/Reference:
QUESTION 38
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.)
A. Ifarecordisbeingeditedinonewindow,itcannotbeeditedintheotherwindow.
B. AfindperformedinonewindowwillbeavailableasaRecentFindintheotherwindow.
C. If a custom menu set is installed in one window, it will become the active menu set in the other window as well.
D. If a new record is created in one window, it will become the active record in both windows after it has been committed in the original window.
E. Ifarecordisbeingeditedinonewindow,theuserwillbepromptedtosaveorreverttherecordwhentheyattempttoswitchtothesamerecordinthesecond window.
Correct Answer: AB Section: (none) Explanation
Explanation/Reference:
QUESTION 39
A developer creates a solution with the following Custom Menu setting installed as the file default:
The Delete Record command has an override title of Delete Order Assume the delete button is on the Status Toolbar. The file is hosted and subsequently opened by a user with a privilege set which prohibits deletion of records.
Which statement is true about this situation?
A. TheDeleteOrderbuttonisnotvisible.
B. TheDeleteRecordbuttonisnotvisible.
C. The Delete Order button is visible but grayed out.
D. The Delete Record button is visible but grayed out.
E. TheDeleteOrderbuttonisvisiblebutgeneratesanerrorwhenclicked. F. TheDeleteRecordbuttonisvisiblebutgeneratesanerrorwhenclicked.

Correct Answer: C Section: (none) Explanation
Explanation/Reference:
QUESTION 40
Which three statements are true about installing and updating plug-ins in FileMaker Pro 13? (Choose three.)
A. Thefmppluginextendedprivilegemustbeenabledtoinstallanewplug-in.
B. AFileMakerplug-incanbeinsertedintoacontainerfieldandinstalledonaclientmachine.
C. A plug-in can be removed using a script that includes the Uninstall Plug-In File script step.
D. The Allow Solutions to Install Files checkbox must be enabled in the Plug-Ins tab of Preferences.
E. Aplug-inmustbestoredontheserverhostingthedatabasetobeautomaticallyinstalledonclientmachines.
F. A plug-in can be automatically installed on a client machine by using OnFirstWindowOpen to trigger a script that tests for the presence of the plug-in with the Install Plug-In File script step.
Correct Answer: BDF Section: (none) Explanation
Explanation/Reference:
QUESTION 41
Which two statements are true about Touch keyboard types? (Choose two.)
A. Thekeyboardcanbesuppressed.
B. ThesettinghasnoimpactonclientsusingFileMakerPro.
C. The keyboard assigned to a field can be installed via a script.
D. The default keyboard for a field can be set under Field Options.
E. ThedefaultkeyboardfornewlayoutobjectsisDefaultforDataType.
Correct Answer: BE Section: (none) Explanation

Explanation/Reference:
QUESTION 42
A user is connected remotely to a FileMaker database with FileMaker Go 13 with an extended privilege of fmreauthenticate0. The user presses the Home button. After 10 seconds, the user multitasks back to the FileMaker Go 13 app.
Which statement is true in this situation?
A. Thedatabasewillopenwithoutreauthentication.
B. Theuserwillbepromptedtosupplyausernameandpassword.
C. The user will be prompted to supply only the password for the current account.
D. The user will be left disconnected from the database and be put at the file selection menu.
Correct Answer: B Section: (none) Explanation
Explanation/Reference:
QUESTION 43
Which two conditions must be true to enable a FileMaker Go 13 client to access a solution hosted with FileMaker Server 13? (Choose two.)

A. EnablemobileaccessmustbecheckedintheFileOptionsdialog.
B. TheremustbeanavailableconcurrentlicenseonFileMakerServer13.
C. Enable FileMaker Go must be checked in the Server Admin Console.
D. The fmgo Extended Privilege must be assigned to at least one Privilege Set. E. ThefmappExtendedPrivilegemustbeassignedtoatleastonePrivilegeSet.
Correct Answer: BE

Section: (none) Explanation
Explanation/Reference:
QUESTION 44
Which two features of FileMaker Pro 13 require indexing in order to work? (Choose two.)
A. TheListfunction
B. Auto-completeusingexistingvalues
C. Dynamic value lists based on FileMaker tables
D. Dynamic subsummary reports in Browse mode
E. TheExecuteSQLcalculationfunctionwithaJOINinthequery
Correct Answer: BC Section: (none) Explanation
Explanation/Reference:
QUESTION 45
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. AnytimetheCustomerrecordismodified
B. AnytimetheindexoftheCompany::CompanyIDfieldisrebuilt
C. AnytimetherelatedCompany::CompanyNamefieldismodified
D. AnytimetheCompanyIDfieldontheCustomerrecordismodified
E. AnytimeauserchoosesRefreshWindowfromtheRecordsmenuwhileviewingtheCustomerrecord
Correct Answer: D Section: (none)

Explanation Explanation/Reference:
QUESTION 46
Which statement is true about supplemental fields added to a shadow table based on an External ODBC Data Source that uses MySQL?
A. ThesefieldsmayonlybeoftypeSummaryorCalculation.
B. ThesefieldsmaybeindexedunlesstheyareoftypeSummary.
C. These fields will be added to the table definitions within MySQL when the Sync button in the FileMaker Pro 13 Manage Database dialog is used.
D. These fields will be lost if the schema of the MySQL table is changed and then the Sync button in the FileMaker Pro 13 Manage Database dialog is used.
Correct Answer: A Section: (none) Explanation
Explanation/Reference:
QUESTION 47
Given the following relationship graph
Without inspecting the data, what is known about this solution?
A. TheEventtableoccurrencereferencesatablefromanexternalODBCDataSource.
B. Therecanbezeroorone,butnomorethanone,EventrecordrelatedtoanyTaskrecord.
C. The corner arrows indicate all three table occurrences reference tables from external data sources.
D. From a layout based on the Event table occurrence, a portal could be drawn showing both related Task and Volunteer data.
Correct Answer: D Section: (none)

Explanation Explanation/Reference:
QUESTION 48
For which field type can the field validation setting Strict data type: Numeric Only be applied?
A. Text
B. Date
C. Integer
D. Summary E. Timestamp
Correct Answer: A Section: (none) Explanation
Explanation/Reference:
QUESTION 49
A user manually switches from one layout to another.
Which two script triggers, if set on both layouts, will always activate? (Choose two.)
A. OnLayoutExit
B. OnPanelSwitch C. OnRecordLoad D. OnViewChange E. OnLayoutChange
Correct Answer: AC Section: (none) Explanation
Explanation/Reference:

QUESTION 50
Which method can be used to sort related records within a portal in a FileMaker 13 solution?
A. InLayoutMode,selecttheportalthenchooseSortrecordsintheBehaviorsectionoftheDatataboftheInspector
B. IntheRelationshipsGraph,changetheSortrecordssettingintheSpecifyTabledialogfortheportal'stableoccurrence
C. Run a script using the Sort Records by Field script step, choosing one of the portal's related fields and checking the Sort only related records option
D. 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
Correct Answer: D Section: (none) Explanation
Explanation/Reference:
QUESTION 51
Which two actions could generate a line chart that contains multiple lines? (Choose two.)
A. SetthecharttousedatafromRelatedRecordsandspecifymultipledataseries,eachbasedonarelatednumberfield
B. SetthecharttousedatafromCurrentFoundSetandspecifymultipledataseries,eachreferencingasinglenumberfield
C. Set the chart to use data from Current Found Set and specify a single data series that contains a return delimited list of values
D. Display a found set of data in Table View, sort by two fields, then click on the header of one of the sort fields and create a Quick Chart using both sorted fields
Correct Answer: AB Section: (none) Explanation
Explanation/Reference:
QUESTION 52
Given the following Relationships Graph for a FileMaker 13 solution, where Employee. Manager, and Trainer are all table occurrences sharing the same source table:

Assuming the relevant fields also exist in these tables, which two sets of data can be shown in portals without modifying the graph? (Choose two.)
A. Aportalofstudentsthathavenotenrolledinaclass
B. Aportaloftrainersthathavetaughttheirownmanager
C. A portal of the classes that have been attended by a manager's employees
D. A portal showing a non-repeating list of courseware titles taught by a trainer
E. Aportalofclassesinwhichamanagerenrolledwithoneormoreofthemanager'semployees
Correct Answer: CD Section: (none) Explanation
Explanation/Reference:
QUESTION 53
For which two is it possible to specify conditional formatting? (Choose two.)
A. Atabpanel
B. Thebodypartofalayout
C. The title of a chart object
D. A merge symbol (e.g. {{CurrentDate}})


E. Aninsertedgraphicformattedasabutton
F. A rectangle object being used as a graphical background
Correct Answer: AD Section: (none) Explanation
Explanation/Reference:
QUESTION 54
The text field productCode has a script trigger set to activate OnObjectKeystroke and runs the following script:
The field productCode has the value of 12-1415. A FileMaker Pro 13 user types a 6 in the field at the end of the value.
What is the resulting value in the field after the script trigger has processed?
A. 12-1415 B. 12-1415- C. 12-14156 D. 12-14156- E. 12-1415-6
Correct Answer: E Section: (none) Explanation
Explanation/Reference:
QUESTION 55
Which two statements are true about a Web Viewer object viewed on a layout in FileMaker Pro 13? (Choose two.)

A. Itcanbeplacedinapopoverobject.
B. ItcandisplayaFileMakerWebDirectsolution.
C. It can display web pages in List View rows, but not Table View rows.
D. It can be configured to show a Back button in the Web Viewer Setup dialog.
E. Itcanbeconfiguredtologintoasecuredwebsitebysendingthecurrentuser'sFileMakeraccountnameandpassword.
Correct Answer: AC Section: (none) Explanation
Explanation/Reference:
QUESTION 56
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?
A. InLayoutMode,movethezSumOrdersfieldintotheOrdersportalrow
B. AddoneormoresortcriteriatotherelationshiponwhichtheOrdersportalisbased
C. AddaportalfilterusingFilterPortalRecordssoonlyunpaidorderswillbedisplayed
D. Change the criteria of the portal's relationship to further limit the set of records displayed in the Orders portal
Correct Answer: D Section: (none) Explanation
Explanation/Reference:
QUESTION 57
Which two statements are true regarding layout themes and styles in FileMaker Pro 13? (Choose two.)
A. Newcustomthemescanonlybecreatedfromexistingthemes.
B. Textobjectsandbuttonscanbeformattedusingsameavailablestylesfromatheme.
C. Updates saved to a theme are applied to layouts using the same theme across files hosted on the same FileMaker Server.

D. 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.
Correct Answer: AD Section: (none) Explanation
Explanation/Reference:
QUESTION 58
Which function returns a unique, unchanging identifier of a computer using FileMaker Pro 13?
A. Get(uuid)
B. Get(PecsistentID)
C. Get ( Device )
D. Get ( SystemNICAddress ) E. Get(SystemMACAddress)
Correct Answer: B Section: (none) Explanation
Explanation/Reference:
corrected and modified.
QUESTION 59
Which two functions should be used with a script trigger to detect when a user types a backspace character in a field? (Choose Two)
A. Char
B. Code
C. GetLastKeystroke


D. Get (TriggerKeystroke) E. GetLayoutObjectAttribute
Correct Answer: BD Section: (none) Explanation
Explanation/Reference:
QUESTION 60
Which is a valid use of the Let () function in a formula for a FileMaker 13 calculation field?
A. Tosetthevalueofaglobalvariable
B. TolimittheiterationsofaLoop()function
C. To modify data in a text field referenced elsewhere
D. To define a custom function that can be used in other calculation formulas
Correct Answer: A Section: (none) Explanation
Explanation/Reference:
QUESTION 61
Given the following function:
What is returned?

A. ,Ltd B. Ltd., C. hers, D. thers E. Wainr
Correct Answer: A Section: (none) Explanation
Explanation/Reference:
QUESTION 62
Given a one-to-many relationship between a Customer table and an Invoice table with the following fields:
Customer pk_Customer: ID
Invoice pk_InvoiceID fk_Customer: ID InvoiceDate
Which formula can be used as the definition for a calculation in the Customer table that will count the number of invoices generated in the past 180 days?

A. Option A B. OptionB C. Option C D. Option D
Correct Answer: B Section: (none) Explanation
Explanation/Reference:
QUESTION 63
Given the following function:
Substitute ( myText ; ["abc" ; "XYZ"] ; [ "XYZ" ; "abc"] )
If the field myText contains "abc-xyz", what is the result? A. abc-abc

B. abc-xyz C. XYZ-abc D. XYZ-xyz
Correct Answer: B Section: (none) Explanation
Explanation/Reference:
QUESTION 64
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?
A. ChecktoseeifthevalueofGet(RecotdOpenState)isnotzero.
B. SetascriptvariabletotheUUIDoftherecord,andthenusetheformulaPattetnCount(Get(LockedRecocdIDs);$myVar)>0 C. Attempttomodifyafieldwithglobalstorage,andthenatesttoseeifanerroroccurred.
D. Use the Open Recocd/Request script step, and then a test to see if an error occurred.
E. Attempttosetascriptvariabletoavaluefromtherecord,andthentesttoseeifanerroroccurred.
F. IncludeanOnErrorscriptstepaftertheSetFieldbutbeforetheCommitRecotd/Requeststep
Correct Answer: D Section: (none) Explanation
Explanation/Reference:
QUESTION 65
The following script is run from a record on a layout based on a table occurrence that is not related to the Product table occurrence:

What happens after the script is run?
A. Norecordsaredeleted.
B. Allrecordsinthecurrenttablearedeleted.
C. All records in the Product table are deleted.
D. All records in the current found set are deleted.
E. AllrecordsinthecurrentfoundsetfortheProducttablearedeleted.
Correct Answer: D Section: (none) Explanation
Explanation/Reference:
QUESTION 66
A FileMaker 13 solution has a script called MyScript that contains only the following script step:
Install OnTimer Sctipt [Hello Wotld; Interval:60]
From Window_01 the user runs MyScript and then creates a new window (Window_02). From Window_02 the user creates a new window ( Window_03). What is the status of the script Hello World?
A. Itrunsimmediatelywheneachnewwindowopens.
B. ItwillcontinuetorunonWindow_01andWindow_02andWindow_03.
C. It will continue to run on Window_01 but will not run on Window_02 or Window_03.
D. It will continue to run on Window_01 until it triggers for the first time in one of the new windows.
Correct Answer: B Section: (none) Explanation
Explanation/Reference:
QUESTION 67
Given the following script:

Which conclusion can be made?
A. Everyuserwillseeatleasttwodialogs.
B. Everyuserwillseethe"Youaredone!"dialog.
C. No user will see the "You selected Red!" dialog.
D. Users will see "You selected Black!" if they click the default button
Correct Answer: C Section: (none) Explanation
Explanation/Reference:
QUESTION 68
Given a FileMaker 13 solution with the following script:

Which two statements are true if there are no records where the Customer: :Name field contains "Smith"? (Choose two.)
A. UnlessaSetErrorCapture[On]stepisaddedatthebeginningofthescript,Get(LastError)willnotreturnanerrorvalue.
B. AddingaSetErrorCapture[On]steptothebeginningofthescriptwillcausethescripttoexitafterthecustomdialogdisplaysitserrormessage.
C. Adding a Set Error Capture [On] step to the beginning of the script has no effect on whether or not the custom dialog displays its error message.
D. Adding a Set Error Capture [On] step to the beginning of the script will suppress the default FileMaker error stating that no records match this set of find requests.
Correct Answer: CD Section: (none) Explanation
Explanation/Reference:
QUESTION 69
Which two protocols are supported by the insect from URL script step in FileMaker 13? (Choose two.)
A. XML
B. FTPS C. SMTP D. WSDL E. HTTPS
Correct Answer: BE Section: (none) Explanation
Explanation/Reference:
QUESTION 70
Which two statements are true regarding the Go to Related Recocds script step? (Choose two.)

A. Thescriptstepcandisplaytherelatedrecordsinanyofthefile'sexistingwindows.
B. Iftherearenorelatedrecords,thedestinationlayoutwillhave0recordsinthefoundset.
C. The script step can specify a layout in another FileMaker 13 file as the destination layout.
D. The script step has the option to show records related to the current record only or to all the records in the found set.
E. TheGotoRelatedRecordsscriptstepwillnotworkifthedestinationtableisbasedonanExternalDataSourceoftypeODBC.
Correct Answer: CD Section: (none) Explanation
Explanation/Reference:
QUESTION 71
Which two statements are true about the [Full Access] privilege set in a FileMaker 13 solution? (Choose two.)
A. ItistheonlyprivilegesetthatcanuseCustomFunctions.
B. ItistheonlyprivilegesetthatcanviewtheRelationshipsGraph.
C. It can be deleted only if another full access privilege set has been created. D. It is the only privilege set that can modify field options using the Field Picker
Correct Answer: BD Section: (none) Explanation
Explanation/Reference:
QUESTION 72
Given Table A in File A, which condition allows a user to access data from Table A while using another file called File B?


A. FileAandFileBmusthaveanaccountwiththesamenameandpassword.
B. FileAmusthaveauthorizedFileBintheFileAccesstabofManageSecurity.
C. The privilege set associated with the account that is logged into File A must allow access to the records in Table A. D. The privilege set associated with the account that is logged into File B must allow access to the records in Table A.
Correct Answer: C Section: (none) Explanation
Explanation/Reference:
QUESTION 73
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? (Choose two.)
A. Enableplug-insischeckedintheServerPlug-InstaboftheServerAdminConsole.
B. TheWindowsandOSXODBCdriversareinstalledintheFileMakerServer13extensionsfolder.
C. Enable ODBC/JDBC is checked in the ODBC/JDBC configurations tab of the Server Admin Console.
D. The Windows ODBC driver is configured with a System DSN to the external data source on the FileMaker Server computer.
E. AuthenticationforthedatasourceissettopromptuserforusernameandpasswordintheEditDataSourcedialogboxforManageExternalDataSources.
Correct Answer: DE Section: (none) Explanation
Explanation/Reference:
QUESTION 74
Which two statements are true of security in a FileMaker 13 solution? (Choose two.)
A. FileMakeraccountpasswordsarestoredasaone-wayhash.
B. ContainerdatathatisstoredexternallyusingSecurestorageisencrypted.
C. Container field data can be securely encrypted using the Base64Encode function.
D. Data that has been stored in an encrypted format in MySQL cannot be imported into a FileMaker solution.

E. DatainatextfieldisstoredencryptedwhenthefieldoptionischeckedforstoragetoUseencryptedstorage.
Correct Answer: AB Section: (none) Explanation
Explanation/Reference:
QUESTION 75
Which statement is true about enabling database encryption in FileMaker Pro 13 Advanced?
A. Databaseencryptionwillsecurenetworktrafficwhenusingpeer-to-peersharing.
B. ExternalcontainerdatawillautomaticallybesettouseSecureStoragewhenencryptingthedatabase.
C. To prevent repeated encryption password entry, two unhosted files must have both the same encryption password and Shared ID. D. If an encrypted file is hosted on FileMaker Server 13, every user who opens the file will be required to enter the encryption password.
Correct Answer: C Section: (none) Explanation
Explanation/Reference:
QUESTION 76
According to the FileMaker Server Configuration Guide, which two practices are recommended for backing up databases hosted by FileMaker Server 13? (Choose two.)
A. UsethirdpartybackupsoftwaretocopytheentireDatafoldertoaremotestoragelocation.
B. UsetheServerAdminConsoleScheduleAssistantorfmsadmintooltoperformbackups.
C. Save Progressive Backups to a separate machine from the master machine for high traffic systems.
D. Configure backup schedules to direct the backup of hosted databases directly to another computer or storage device.
E. Upgradingthedisksub-systemandincreasingmemoryareprimaryconsiderationswhentryingtoincreasethespeedofbackups.
Correct Answer: BE Section: (none) Explanation
Explanation/Reference:

QUESTION 77
Which two actions can be performed using the fmsadmin command line interface (CLI) tool? (Choose two.)
A. Verifyahostedfile
B. Enableserverlogging
C. Download a hosted file
D. Stop the Web Publishing Engine
E. ResetthepasswordoftheAdminConsoleaccount
Correct Answer: AD Section: (none) Explanation
Explanation/Reference:
QUESTION 78
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.)
A. Install4GBofadditionalRAM
B. Replacethemachinewithonewhichhasfourprocessors
C. Install an additional network card and team it with the existing card
D. Replace the network card with a model which has an on-board processor
E. InstallanadditionalharddriveandconfigurethedrivesubsystemusingRAID1+0
Correct Answer: CD Section: (none) Explanation
Explanation/Reference:
QUESTION 79

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?
A. TheSendMailscriptstepmustbesettoSendvia:ServerE-MailClient.
B. TheSendMailscriptstepmusthaveaverifiedemailaddressintheTo:field.
C. The Send Mail script step must have properly configured SMTP Options for Send via: SMTP Server.
D. SMTP Information must be properly configured in the General Settings tab of the Server Admin Console
Correct Answer: C Section: (none) Explanation
Explanation/Reference:
QUESTION 80
Which two components are required to use all of the features of FileMaker Server 13 for Windows? (Choose two.)
A. PHPengine
B. Bonjourservice
C. Apache web server
D. Microsoft Management Console E. QuickTimePlug-inforWindows
Correct Answer: AB Section: (none) Explanation
Explanation/Reference:
QUESTION 81
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. TheODBC/JDBCsettingenabledintheServerAdminConsole
B. The[fmxdbc]extendedprivilegeassignedtotheuser'sprivilegeset
C. A validated path to the Data Source listed under the File Path List in the Edit Data Source dialog
D. A compatible ODBC driver installed on the FileMaker Server 13 computer or the user's local computer
E. AnExternalODBCDataSourceintheManageExternalDataSourcesdialogforthehostedFileMakerdatabase
Correct Answer: DE Section: (none) Explanation
Explanation/Reference:
QUESTION 82
Which are two valid choices for directly importing records into a FileMaker Pro 13 file? (Choose two.)
A. vCard
B. HTML Table
C. XML Data Source D. JDBC Data Source E. ODBCDataSource
Correct Answer: CE Section: (none) Explanation
Explanation/Reference:
QUESTION 83


Which statement is true when developing the user experience for a FileMaker WebDirect solution?
A. CustomMenushavenoeffect.
B. TheNewwindowscriptstepisnotsupported.
C. The Show Custom Dialog script step is not supported.
D. Table View is only available when the Status Toolbar is visible.
E. CustomthemesarenotsupportedandrenderusingClassicthemestyles
Correct Answer: A Section: (none) Explanation
Explanation/Reference:
QUESTION 84
Which three statements are true about FileMaker WebDirect? (Choose three.)
A. ItispossibletocreateacustomFileMakerWebDirectHomePage.
B. ItispossibletocreateaURLthatlinksdirectlytoaFileMakerWebDirectsolution,bypassingthehomepage.
C. The appearance of most FileMaker WebDirect pages can be altered using Cascading Style Sheets (CSS]
D. 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.
E. ItispossibletodisplaydatabasesfrommultipleinstancesofFileMakerServer13onthedefaultFileMakerWebDirectHomePageiftheservershavebeen configured to work with a directory service.
Correct Answer: ABD Section: (none) Explanation
Explanation/Reference:
QUESTION 85
Which two statements are true about solutions served via Custom Web Publishing (CWP)? (Choose two.)
A. TheycanexecuteFileMaker13scripts.
B. TheycanonlybeaccessedusingChrome,Safari,orInternetExplorer. C. They are not limited with respect to the number of simultaneous users.

D. They rely on the layouts that have been defined within the hosted FileMaker 13 files.
E. Theycanonlybeaccessedbyaccountsforwhichthefmphpextendedprivilegeisenabled.
Correct Answer: AD Section: (none) Explanation
Explanation/Reference:
QUESTION 86
Which two statements are true about the Status Toolbar when using FileMaker Pro 13? (Choose two.)
A. RecordnavigationviatheStatusToolbarcanbepreventedbyinstallingaCustomMenu.
B. Thenameand/orfunctionofastatustoolbarbuttoncanbechangedbyinstallingaCustomMenu.
C. The ability to add or remove buttons on the Status Toolbar can be prevented by installing a Custom Menu.
D. Users whose privilege set has Available menu commands set to Minimum cannot customize the Status Toolbar
E. TheinitialsettingsoftheStatusToolbararestoredwiththedatabasefileandsharedwithallusersofthehostedfile.
F. CustomizationoftheStatusToolbarcanbepreventedbyrunningascriptwhichcontainstheShow/HideStatusArea[Lock;Show]scriptstep.
Correct Answer: AB Section: (none) Explanation
Explanation/Reference:
QUESTION 87
A script executed by a FileMaker Server 13 schedule running on a Windows server exports a group of records to a tab-delimited file. The resulting file needs to be saved to the FileMaker Server Documents folder and the filename must contain a current timestamp appended to the word "orders_" (e.g. "orders__02152012065656.tab")
Which two statements are true about this situation? (Choose two.)

A. Option A B. OptionB C. Option C D. Option D E. OptionE
Correct Answer: AC Section: (none) Explanation

Explanation/Reference:
QUESTION 88
Which two types of fields will always be EXCLUDED from the search when a user performs a Quick Find? (Choose two.)
A. Mergefields
B. Summaryfields
C. Unindexed fields
D. Fields with global storage
E. Fieldstotherightofthelayoutedge
Correct Answer: BD Section: (none) Explanation
Explanation/Reference:
QUESTION 89
Which two statements are true when a script is installed on a window using the Install OnTimer Script step? (Choose two.)
A. Thewindowmustbeclosedtouninstallthescript.
B. Thescriptwillrunonlywhentheapplicationisidle.
C. The script will run on any new window created from the initial window.
D. The script will pause when a window is hidden and resume when it is restored.
E. Inawindowwithmorethanoneinstalledscript,thescriptswillbeperformedintheorderinwhichtheywereinstalled.
Correct Answer: BC Section: (none) Explanation
Explanation/Reference:
QUESTION 90
Which two statements are true about the insect From Device script step? (Choose two.) A. TheCameraOptionssupporttheselectionoftheFrontorBackcamera.

B. ItissupportedonFileMakerGoandFileMakerWebDirectonmobilebrowsers.
C. The Bar Code Options allow the developer to specify a Bluetooth barcode scanner.
D. The Bar Code Options allow the developer to select the types of bar codes scanned.
E. TheSignatureOptionsallowthedevelopertocustomizethetextbelowthesignatureline
Correct Answer: AD Section: (none) Explanation
Explanation/Reference:
QUESTION 91
Which statement is true when using the FMP protocol in FileMaker Go 13?
A. Scriptnamesarecasesensitive.
B. Filenamescontainingspacesarenotsupported.
C. Multiple local variables can be defined in the syntax.
D. The .fmp12 extension is required when specifying the database name
Correct Answer: C Section: (none) Explanation
Explanation/Reference:
QUESTION 92
A layout has a script trigger assigned to activate OnRecordCommit and a field on the same layout with script triggers assigned to activate on OnObjectSave, OnObjectExit and OnObjectValidate. The field is modified and the user exits the field without navigating to another object on the layout.
In which order will the script triggers activate?
Select and Place:

Correct Answer:
Section: (none) Explanation

Explanation/Reference:
QUESTION 93
Match the FileMaker Server 13 hosting technology with maximum tested simultaneous connections according to the FileMaker Server 13 Technical Specifications. (Options may be used more than once.)
Select and Place:
Correct Answer:

Section: (none) Explanation
Explanation/Reference:
QUESTION 94
What is the maximum number of files that can be hosted on FileMaker Server 13?
A. 100 B. 125 C. 250 D. 999
Correct Answer: B Section: (none) Explanation
Explanation/Reference:

QUESTION 95
What is the maximum number of recursive calls that can be made utilizing a custom function in FileMaker Pro 13 Advanced?
A. 10,000 B. 32,000 C. 50,000 D. 64.000
Correct Answer: C Section: (none) Explanation
Explanation/Reference:
QUESTION 96
Which statement is true about a container field set to Store container data externally in FileMaker 13?
A. DatawillnotbestoredexternallyifthefileistransferredtoaniOSdeviceandusedviaFileMakerGo13.
B. ExternallystoredcontainerdatawillnotbebackedupbyFileMakerServer13scheduledbackuproutines.
C. When hosted on FileMaker Server, external container data must be stored in a subdirectory of the database folder. D. Externally stored container data will be embedded in the file when it is downloaded via the Server Admin Console.
Correct Answer: A Section: (none) Explanation
Explanation/Reference:
QUESTION 97
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. Arecordisfirstcreated
B. EachtimethevalueoftheFirstNameorLastNamefieldismodified
C. A user selects the menu item Records> Relookup Field Contents
D. AnyfieldvalueontherecordismodifiedandtheFirstLastfieldisempty
E. TheFirstNameorLastNamefieldismodifiedandtheFirstLastfieldisempty
Correct Answer: AE Section: (none) Explanation
Explanation/Reference:
QUESTION 98
Which three field options may be set for a shadow field from an External ODBC Data Source? (Choose three.)
A. Validation:notempty
B. Validation:uniquevalue
C. Validation: existing value
D. Auto-enter creation timestamp
E. Auto-enterserialnumber,oncreation
F. Storage:automaticallycreateindexesasneeded
Correct Answer: ADE Section: (none) Explanation
Explanation/Reference:
QUESTION 99
Consider a FileMaker 13 solution with the following tables and fields:

Assuming only the above relationships between table occurrences, using sorting if necessary, which two actions can be performed? (Choose two.)
A. CreateavaluelistthatshowsallInvoicesforachosenCustomer
B. CreateavaluelistonaProductlayoutwhichdisplaysallCustomers
C. Find all of the Customers who have ever ordered a specific Product
D. Create a portal to display each Product that has been ordered by a Customer
E. DisplayallrecordsfromtheCustomertableinaportalonalayoutforanInvoiceItemrecord
Correct Answer: BE Section: (none) Explanation
Explanation/Reference:
QUESTION 100
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?
A. Alloftherecordswillbeimported,Noerrormessagewillbedisplayed.
B. Theuserwillseethecustomerrormessage,buttheimportwillcontinueiftheuseroverridestheerror.
C. All records with a value for CompanyName will be imported. The user will see the specified custom message.
D. All records with a value for CompanyName will be imported. The user will see an error dialog from the FileMaker Pro application stating that some records could not be imported due to errors, along with a count of those records.
Correct Answer: A

Section: (none) Explanation
Explanation/Reference:
QUESTION 101
A new solution is created with Iwo tables, Client and Contracts. The only modification made on the Relationships Graph is to establish a relationship between them which is set to delete related records in Contracts when a record in Client is deleted.
What happens when the Client table occurrence is deleted from the Relationships Graph?
A. SinceitistheonlyoccurrenceoftheClienttableonthegraph,itcannotbedeleted.
B. AnyrecordsintheContractstablethatwererelatedtomatchingClientrecordsaredeleted.
C. The formula in the calculation field Name Full (defined as Name First & " & Name Last) will be broken.
D. Any records in the Contracts table that were related to matching Client records will have values in the Client ID field deleted.
Correct Answer: C Section: (none) Explanation
Explanation/Reference:
QUESTION 102
Which two FileMaker Pro 13 objects will display data contents even if unrelated to the current layout's table occurrence? (Choose two.)
A. Mergevariable
B. Indexedtimestampfield
C. A text field from a shadow table

D. Globally stored number field placed in a portal
E. AcontainerfielddefinedwiththeStoreasreferenceonlyoptionenabled
Correct Answer: AD Section: (none) Explanation
Explanation/Reference:
QUESTION 103
Which two statements are true about field indexing in FileMaker Pro 13? (Choose two.)
A. Calculationfieldscannotbeindexed.
B. Indexingimprovesthespeedatwhichsortsareperformed.
C. To establish a relationship between two fields, both fields are required to be indexed.
D. A field must be indexed in order for Auto-complete using previously entered values to function.
E. Minimalindexingindicatesthateitherthevalueindexorthewordindexhasbeencreated,butnotboth.
Correct Answer: DE Section: (none) Explanation
Explanation/Reference:
QUESTION 104
Which two formatting options can be controlled by a layout's theme? (Choose two.)
A. Theanchoring/resizingsettingsforatabcontrol
B. Conditionalformattingforavalueinanumberfield
C. The text color of a button when tapped in FileMaker Go
D. The inner shadow of a portal that is In Focus in Browse mode
E. ThebackgroundcolorofarecordinListViewwhenamousepointerhoversoverit
Correct Answer: CD Section: (none) Explanation

Explanation/Reference:
corrected.
QUESTION 105
Which statement is true about the Filter Portal Records feature in FileMaker Pro 13?
A. Theportalfilterformulamustrefertoatleastonefieldintheimmediatelyrelatedtable.
B. ThefeaturerequiresoneormoreadditionalrelationshipstobeaddedtotheRelationshipsGraph.
C. The portal filter formula may not refer to any globally stored fields, summary fields, or unstored calculation fields.
D. There can be one unique filter formula applied for each portal state (Normal State, In Focus, Hover, or Pressed).
E. Aggregatefunctions(e.g.,Sum,Count)basedontheportal'srelationshipwillnotbeaffectedbytheportal'sfilterformula.
Correct Answer: E Section: (none) Explanation
Explanation/Reference:
QUESTION 106
Given the following Relationships Graph for a FileMaker are all table occurrences sharing the same source table:
The solution has the following layout based on the Trainer table occurrence:

If a developer modifies the layout to be based on the Manager table occurrence instead of Trainer, what happens to the data that is displayed?
A. Thename,phone,andaddressfieldswillnolongerdisplaydata,andtheportalwillshowallemployeesrelatedtothemanagerrecord.
B. Thename,phone,andaddressfieldswillchangetoshowthemanager'sdata,andtheportalshowsallemployeesrelatedtothemanagerrecord.
C. The name, phone, and address fields will change to show the manager's data, but the portal will need to be edited to Show related records from: the Manager table occurrence as well.
D. The name, phone, and address fields will now show data for the first related trainer of the first class of the first employee of the current manager, and the portal will show all employees related to the manager record.
E. Thename,phone,andaddressfieldswillnowshowdataforthefirstrelatedtrainerofthefirstclassofthefirstemployeeofthecurrentmanager,andtheportal will show all employees that have been enrolled in that trainer's classes.
Correct Answer: D Section: (none) Explanation
Explanation/Reference:
QUESTION 107
Given the following Relationships Graph in a FileMaker 13 solution:

A layout is based on the table occurrence Class and a portal shows records from the table occurrence Employee. If the field Trainer: : Name is placed into the portal, what is the result?
A. Thetext<FieldMissing>isdisplayedineachrowoftheportal.
B. Eachrowshowsthenameofeachenrolledemployee'sfirstrelatedtrainer.
C. The name of the first related trainer for the class is repeated in each row of the portal.
D. The name of the trainer for the first class enrolled by the first Employee record of the portal is repeated in each row of the portal.
Correct Answer: C Section: (none) Explanation
Explanation/Reference:
QUESTION 108
Which two techniques could be used to successfully generate the data points for a pie chart? (Choose two.)
A. Concatenatemultiplenumberfieldsfromthecurrentrecordintoareturn-delimitedlist.
B. Setupmultipledataseries,eachofwhichpointstoanumberfieldinthecurrentrecord.
C. Specify a summary field from a related set of records as the data series and put the chart in a Subsummary layout part.
D. Specify a summary field from the current found set as the data series and put the chart in a Leading Grand Summary layout part.
Correct Answer: AD Section: (none) Explanation
Explanation/Reference:
QUESTION 109
Which two statements are true about OnTimer triggers? (Choose two.)
A. Theyonlyrunwhentheapplicationisidle.
B. OnTimertriggersareconfiguredintheFileOptionsdialog.
C. Different OnTimer scripts can be installed in different windows.
D. Days and times can be specified when the OnTimer script activates.

Correct Answer: AC Section: (none) Explanation
Explanation/Reference: