FileMaker FileMaker Certifications FM0-305 Questions & Answers

• Question 71:

  Given a custom function created in FileMaker Pro 11 Advanced called myFunction with a single parameter

  str defined as:

  Case ( Length (str) > 0

  Right ( str 1) and

  myFunction ( Left (str Length (str) 1))

  str

  )

  What is the result of myFunction ( "cat" )?

  A. c

  B. cat

  C. tac

  D. tacc

  E. taccat

  F. catcat

  Correct Answer: C

• Question 72:

  While in a FileMaker Pro 11 database on a layout based on the Invoice table occurrence, the following script is run: Show All Records Go to Record/Request/Page [First] Loop If [Invoice::Status = "Sent"] Omit Record Else Go to Record/Request/Page [Next Exit after last] End If End Loop

  Which two statements are true at the conclusion of the script? (Choose two.)

  A. All "Sent" invoices have been omitted from the found set.

  B. The loop will never end if every invoice has a status of "Sent."

  C. The last record will not be omitted if it has a status of "Sent."

  D. The found set will consist of all records if there are no "Sent" invoices.

  Correct Answer: AD

• Question 73:

  Given a FileMaker Pro 11 database containing the following two scripts:

  Script A:

  Set Variable [ $beeps Value:2 ]

  Beep

  Perform Script [ "Script B" Parameter: $beeps ]

  Beep

  Script B:

  Set Variable [ $counter Value:0 ]

  Loop

  Beep

  Set Variable [ $counter Value:$counter + 1 ]

  Exit Loop If [ $counter > Get( ScriptParameter ) ]

  End Loop

  Exit Script []

  Beep

  When Script A executes, how many beeps will be heard?

  A. 3

  B. 4

  C. 5

  D. 6

  Correct Answer: C

• Question 74:

  Given a FileMaker Pro 11 database with the following script:

  Perform Find [Restore]

  # Find restores criteria: Customer::Name [Smith]

  Refresh Window

  If [Get ( LastError )]

  Show Custom Dialog ["No records found" "No records matched your find criteria."]

  End If

  Which two statements are true if there are no records where the Customer::Name field contains "Smith"? (Choose two.)

  A. Unless a Set Error Capture [On] step is added at the beginning of the script, Get (LastError) will not return an error value.

  B. 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.

  C. Adding a Set Error Capture [On] step to the beginning of the script will cause a default FileMaker error dialog to display, followed by the custom error dialog.

  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: BD

• Question 75:

  Given the following return delimited data in a Team field of a FileMaker Pro 11 database:

  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. GetWords (Team 3 2)

  C. Middle (Team 12 10)

  D. MiddleWords (Team 3 4)

  E. MiddleValues (Team 2 1)

  Correct Answer: C

• Question 76:

  Given the following formula in a calculation field that returns a Text result: Let( tmp = "2 * 5" Evaluate( Quote ( tmp ) ) ) What will be returned?

  A. the value 10

  B. the value "10", quotes included

  C. the value tmp

  D. the value "tmp", quotes included

  E. the value 2 * 5

  F. the value "2 * 5", quotes included

  Correct Answer: E

• Question 77:

  There are two fields, Amount and Attainment. Each field is defined to have three repetitions and contain the following data:

  Given the following formula in a nonrepeating calculation field:

  

  Let( [

  $x[1] = 1

  $x[2] = 2

  $x = Attainment ]

  ($x[2] * Amount) * $x[1]

  )

  What is the result?

  A. 5

  B. 10

  C. 12.5

  D. 20

  E. 25

  F. 50

  Correct Answer: B

• Question 78:

  Which statement is true about the Filter Portal Records feature in FileMaker Pro 11?

  A. It can only be configured using FileMaker Pro Advanced.

  B. It requires that one or more additional relationships be added to the Relationships Graph.

  C. The portal filter calculation must refer to at least one field in the immediately related table.

  D. The portal filter calculation may not refer to any globally stored fields, summary fields, or unstored calculation fields.

  E. Any aggregate calculations (sum, count, etc.) based on the portal's relationship will not be affected by the portal filter calculation.

  Correct Answer: E

• Question 79:

  Which two are true about using Current Found Set as the data source for a bar chart in FileMaker Pro 11? (Choose two.)

  A. A user will generate a stacked bar chart if they specify one or more fields that contains a returndelimited list as the data series.

  B. Unless a user selects the option to Show data points for groups of records when sorted, the chart will maximally include the first 250 records (based on the sort order) of the found set.

  C. If a user selects the option to Show data points for groups of records when sorted, sorts the data, and puts the chart in a Trailing Grand Summary, the chart will display one data point per sort group.

  D. If a user selects the option to Show data points for groups of records when sorted, sorts the data by two criteria, and puts the chart in a Subsummary part based on the first sort criteria, the chart will display one data point per secondary sort group.

  Correct Answer: CD

• Question 80:

  Which two could generate a line chart that contains multiple lines? (Choose two.)

  A. set the chart to Use Data From: Related Records and specify multiple data series, each based on a related number field

  B. set the chart to Use Data From: Current Record (delimited data) and specify multiple data series, each of which references a summary field

  C. set the chart to Use Data From: Current Found Set and specify multiple data series, each referencing a single number field

  D. set the chart to Use Data From: Current Found Set and specify a single data series that contains a return delimited list of values

  Correct Answer: AC