Developer Essentials for FileMaker Questions + Answers Part 2
Posted: Fri Feb 25, 2022 3:32 am
QUESTION 1
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: QUESTION 2
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 3
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 4
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 5
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 6
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: QUESTION 7
Which two statements are true about using popover objects in FileMaker 13? (Choose two.)
A. Apopoverobjectcanhaveitsownlayoutcontext.
B. Apopoverobjectcanbeaddedtoanylayoutobject.
C. A popover object can have script triggers applied to it.
D. A popover button that is located inside a portal cannot contain a slide control.
Correct Answer: CD Section: (none) Explanation
Explanation/Reference:
QUESTION 8
DRAG DROP
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 9
A layout is using a theme that sets a field to have a text color of “green” and a text style of “bold”. FieldA has conditional formatting where the text color is “red” when the data in FieldB = 1. A new style is created and applied to FieldA where the text color is “blue” and the text style is “italic” but the style is not saved to the theme.
If FieldB = 1, how would the data in FieldA be formatted?
A. Thetextcoloris“red”andthetextstyleis“italic”.
B. Thetextcoloris“red”andthetextstyleis“bold”.
C. The text color is “blue” and the text style is “italic”.
D. The text color is “green” and the text style is “bold”.
E. Thetextcoloris“red”andthetextstyleis“bold”and“italic”. F. Thetextcoloris“blue”andthetextstyleis“bold”and“italic”.
Correct Answer: A Section: (none) Explanation
Explanation/Reference:
QUESTION 10
A layout contains a single portal that is based on a relationship configured to allow creation of related records. The portal contains one field (FieldA), which is not used anywhere else on the layout. The portal object has the name Portal_1.
Which technique can be used to navigate to FieldA in the empty row at the end of Portal_1?
A. UsetheGoToFieldscriptsteptargetingFieldA,thenusetheGoToPortalRow[Last]scriptstep.
B. AssumingFieldAisinthetaborder,usethearrowkeystoactivatetheportal,thentabtoFieldAinthedesiredrow.
C. Use the Go to Object [Object Name: “portal_1” script step, followed by the script step Go to Portal Row [Select; Last].
D. Use the Go To Portal [Portal 1] script step, followed by the Go To Portal Row [Last] script step and the Go To Field script step targeting FieldA.
Correct Answer: A Section: (none) Explanation
Explanation/Reference: QUESTION 11
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 12
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 13
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 14
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: QUESTION 15
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 16
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 17
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 18
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 19
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 20
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 21
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 22
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 23
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 24
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 25
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 26
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 27
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 28
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 29
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: QUESTION 30
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 31
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 32
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 33
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 34
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 35
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 36
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 37
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 38
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 39
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 40
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 41
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: QUESTION 42
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 43
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 44
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 45
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 46
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 47
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 48
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 49
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 50
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 51
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 52
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 53
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 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
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 57
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 58
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 59
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 60
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. Set a script variable to the UUID of the record, and then use the formula PattetnCount ( 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 61
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.
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: QUESTION 2
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 3
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 4
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 5
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 6
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: QUESTION 7
Which two statements are true about using popover objects in FileMaker 13? (Choose two.)
A. Apopoverobjectcanhaveitsownlayoutcontext.
B. Apopoverobjectcanbeaddedtoanylayoutobject.
C. A popover object can have script triggers applied to it.
D. A popover button that is located inside a portal cannot contain a slide control.
Correct Answer: CD Section: (none) Explanation
Explanation/Reference:
QUESTION 8
DRAG DROP
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 9
A layout is using a theme that sets a field to have a text color of “green” and a text style of “bold”. FieldA has conditional formatting where the text color is “red” when the data in FieldB = 1. A new style is created and applied to FieldA where the text color is “blue” and the text style is “italic” but the style is not saved to the theme.
If FieldB = 1, how would the data in FieldA be formatted?
A. Thetextcoloris“red”andthetextstyleis“italic”.
B. Thetextcoloris“red”andthetextstyleis“bold”.
C. The text color is “blue” and the text style is “italic”.
D. The text color is “green” and the text style is “bold”.
E. Thetextcoloris“red”andthetextstyleis“bold”and“italic”. F. Thetextcoloris“blue”andthetextstyleis“bold”and“italic”.
Correct Answer: A Section: (none) Explanation
Explanation/Reference:
QUESTION 10
A layout contains a single portal that is based on a relationship configured to allow creation of related records. The portal contains one field (FieldA), which is not used anywhere else on the layout. The portal object has the name Portal_1.
Which technique can be used to navigate to FieldA in the empty row at the end of Portal_1?
A. UsetheGoToFieldscriptsteptargetingFieldA,thenusetheGoToPortalRow[Last]scriptstep.
B. AssumingFieldAisinthetaborder,usethearrowkeystoactivatetheportal,thentabtoFieldAinthedesiredrow.
C. Use the Go to Object [Object Name: “portal_1” script step, followed by the script step Go to Portal Row [Select; Last].
D. Use the Go To Portal [Portal 1] script step, followed by the Go To Portal Row [Last] script step and the Go To Field script step targeting FieldA.
Correct Answer: A Section: (none) Explanation
Explanation/Reference: QUESTION 11
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 12
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 13
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 14
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: QUESTION 15
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 16
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 17
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 18
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 19
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 20
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 21
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 22
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 23
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 24
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 25
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 26
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 27
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 28
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 29
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: QUESTION 30
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 31
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 32
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 33
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 34
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 35
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 36
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 37
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 38
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 39
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 40
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 41
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: QUESTION 42
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 43
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 44
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 45
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 46
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 47
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 48
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 49
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 50
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 51
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 52
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 53
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 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
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 57
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 58
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 59
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 60
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. Set a script variable to the UUID of the record, and then use the formula PattetnCount ( 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 61
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.