Skip to main content

FM0-305 Real Exam Questions

Developer Essentials for FileMaker 11

115 questions available · Page 1 of 12

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

A FileMaker Pro 11 file contains the following script:

Set Variable [$counter Value:1]

Go To Record/Request/Page [First]

Loop

Go To Record/Request/Page [Next]

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

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

End Loop
#

Exit Script [Result: $counter] If this script is executed in a context where there is found a set of six records, which value will be returned from the script?

  1. A

    1

  2. B

    6

  3. C

    7

  4. D

    8

  5. E

    No value will be returned.

Show answer and explanation

Correct answer: C

Question 2 Multiple choice

Which two options are available for providing credentials when connecting (via ESS) to a Microsoft SQL Server external ODBC data source in FileMaker Pro 11? (Choose two.)

  1. A

    specify username and password by calculation for each DSN

  2. B

    for the Macintosh client use the Use Open Directory (Single Signon)

  3. C

    for the Windows client use the Use Windows Authentication (Single Signon)

  4. D

    create an extended privilege for each DSN and assign it to each privilege set needing access

  5. E

    specify the username and password in the extended privileges section of the privilege set for the
    DSN being accessed

Show answer and explanation

Correct answers: A, C

Question 3 Multiple choice

Which two types of fields will always be excluded from the search when a user performs a Quick Find? (Select two.)

  1. A

    merge fields

  2. B

    summary fields

  3. C

    unindexed fields

  4. D

    related fields in a portal

  5. E

    fields with global storage

Show answer and explanation

Correct answers: B, E

Question 4 Multiple choice

Which two statements are true about OnTimer triggers? (Choose two.)

  1. A

    They only run when the application is idle.

  2. B

    OnTimer triggers are configured in the File Options dialog.

  3. C

    Different OnTimer scripts can be installed in different windows.

  4. D

    Days and times can be specified when the OnTimer script activates.

Show answer and explanation

Correct answers: A, C

Question 5 Single choice

The components of FileMaker Server 11 or FileMaker Server 11 Advanced may be installed on how many servers?

  1. A

    1 server only

  2. B

    1 or 2 servers only

  3. C

    1, 2, or 3 servers only

  4. D

    1, 2, 3, or 4 servers

Show answer and explanation

Correct answer: C

Question 6 Single choice

Which formula returns the calendar quarter (1, 2, 3, 4) of a date contained in a field called myDate?

  1. A

    Int ( Month ( myDate ) / 3 )

  2. B

    Mod ( Month ( myDate ) 3 ) + 1

  3. C

    Ceiling ( Month ( myDate ) / 3 )

  4. D

    Let ( m = Month ( myDate ) Case ( m > 0 1 m > 3 2 m > 6 3 4) )

  5. E

    Let ( m = Month ( myDate ) Choose ( m 1 1 1 2 2 2 3 3 3 4 4 4 ) )

Show answer and explanation

Correct answer: C

Question 7 Multiple choice

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

  1. A

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

  2. B

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

  3. C

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

  4. D

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

Show answer and explanation

Correct answers: A, D

Question 8 Multiple choice

For which two script triggers can the processing of the triggering event be canceled using Exit Script [False]? (Choose two.)

  1. A

    OnLayoutExit

  2. B

    OnViewChange

  3. C

    OnObjectEnter

  4. D

    OnObjectModify

  5. E

    OnObjectValidate

Show answer and explanation

Correct answers: A, E

Question 9 Multiple choice

Which two are required for a user to successfully run a script that uses the Execute SQL script step? (Choose two.)

  1. A

    a compatible ODBC driver on the computer executing the script

  2. B

    an ODBC Data Source (DSN) on the computer executing the script

  3. C

    the [fmxdbc] extended privilege assigned to the user's privilege set

  4. D

    a Data Source in the Edit Data Source dialog for the file executing the script

Show answer and explanation

Correct answers: A, B

Question 10 Multiple choice

Which two statements are true about the Administrator Groups feature in FileMaker Server 11? (Choose two.)

  1. A

    Administrator Groups provide an additional layer of database security.

  2. B

    A given database file may only be part of one Administrator Group at a time.

  3. C

    A user must have full access privileges in a file before being made a member of that file's Administrator Group.

  4. D

    Administrator Groups may be used to grant additional administrators the ability to open, close and back up specific sets of hosted databases.

Show answer and explanation

Correct answers: B, D