Pass the FileMaker Filemaker Certification FM0-302 Questions and answers with CertsForce

Viewing page 3 out of 4 pages
Viewing questions 21-30 out of questions
Questions # 21:

A user attempts to log in to a database hosted on FileMaker Server 8. It is set up to allow authentication via FileMaker and External Server accounts. The user is a member of two external groups that have been set up in the Edit Account dialog to be authenticated using an external server. Assuming a valid username and password, with which matching account will the user authenticate?

Options:

A.

the account with the least restrictive access permissions


B.

the account with the most restrictive access permissions


C.

the first account created in the Accounts tab of the Define Accounts & Privileges dialog


D.

the first account listed in the Accounts tab of the Define Accounts & Privileges dialog when viewed by authentication order


Expert Solution
Questions # 22:

A layout showing records from a People table has the Save record changes automatically checkbox disabled in the Layout Setup dialog. Which two actions cause FileMaker Pro 8 to display a dialog asking whether or not you want to save changes to the current record? (Choose two.)

Options:

A.

importing records into the People table


B.

editing a field value on the layout and attempting to commit the record


C.

running a script that navigates to that layout, changes a field value, and performs a Commit Records/Requests[No Dialog] script step


D.

running a script that navigates to that layout, changes a field value, and performs a Commit Records/Requests[Skip data entry validation] script step


Expert Solution
Questions # 23:

The last script step in Script A in File A calls Script B in File B. Which three script steps can be used in Script B to make File B's front most window active without the need to use the Select Window [ ] script step? (Choose three.)

Options:

A.

Adjust Window [ ]


B.

Enter Browse Mode [ ]


C.

Enter Preview Mode [ ]


D.

Enter Find Mode [Pause]


E.

Move / Resize Window [ ]


Expert Solution
Questions # 24:

You are using FileMaker Pro 8 Advanced and planning a Contacts database. Others will be able to modify field definitions after you finish the creation of the database. You are considering using a custom function available on a public website to help in formatting phone numbers. What are three reasons to use custom functions in this situation? (Choose three.)

Options:

A.

to hide a proprietary formula


B.

to ease multiple file development


C.

to simplify use of the formula by any user


D.

to improve formatting consistency throughout the file


E.

to ease modification of formatting for all phone numbers


Expert Solution
Questions # 25:

For accounts that are authenticated via FileMaker, which two are controlled by privilege sets in FileMaker Pro 8? (Choose two.)

Options:

A.

which accounts are authenticated


B.

minimum password length for associated accounts


C.

whether or not the passwords of associated accounts expire


D.

how many failed login attempts are allowed before associated accounts are disabled


Expert Solution
Questions # 26:

What are three valid sources for directly importing records into FileMaker Pro 8 file? (Choose three.)

Options:

A.

JDBC


B.

ODBC


C.

Excel files


D.

XML format


E.

HTML table format


Expert Solution
Questions # 27:

Given a FileMaker Pro 8 database containing these two scripts::

Script A:

Perform Script ["Script B" ; Parameter: 3]

Show Custom Dialog [Get (ScriptResult)]

Script B:

Set Variable [$x; Value:Get (ScriptParameter)]

Loop

Set Variable [$result ; Value: $result + $x]

Set Variable [$x ; Value: $x - 1]

Exit Loop If [$x = 0]

End Loop

Exit Script [Result: $result]

If a user runs Script A, what value will be displayed in the custom dialog?

Options:

A.

0


B.

1


C.

6


D.

9


Expert Solution
Questions # 28:

A database has two tables, Planet and Moon. Moons are related to a single planet and their relationship is set to delete related records in the Moon table when a Planet record is deleted.

Which two things happen when the Planet table is deleted from the Tables tab of the Define Database dialog? (Choose two.)

Options:

A.

All data in the Planet table are deleted.


B.

All records in the Moon table are deleted.


C.

All records in the Moon table remain unaffected.


D.

All records in the Moon table are deleted if the option to "Also remove occurrences of these tables in the graph" was selected when deleting the Planet table.


Expert Solution
Questions # 29:

A file has two layouts, Form and List. Form uses the [File Default] Menu Set. List uses a Custom Menu Set called List Menu.

The file default is set to [Standard FileMaker Menus]. The file has two scripts. Script A installs the Custom Menu Set List Menu. Script B installs the same Menu Set, but also includes the Use As File Default option.

If you are on the List layout, which statement is true?

Options:

A.

You run Script A, then switch to the Form layout and the List Menu Menu Set is active.


B.

You run Script B, then switch to the Form layout and the List Menu Menu Set is active.


C.

You run Script B, then switch to the Form layout and the [Standard FileMaker Menus]Menu Set is active.


D.

You switch to the Form layout, run Script A, then choose New Window and [Standard FileMaker Menus] is active.


Expert Solution
Questions # 30:

When manually importing data into a field that has a validation rule in FileMaker Pro 8, which statement is true?

Options:

A.

The validation cannot be triggered during the import.


B.

Unless the validation has been set to apply Always, data cannot be imported into the field.


C.

Assuming the validation has been set to apply Always, if one or more records fail the validation test, the import will abort at the first validation failure.


D.

Assuming the validation has been set to apply Always, if one or more records fail the validation test, a summary containing the number of validation failures will be presented at the end of the import.


Expert Solution
Viewing page 3 out of 4 pages
Viewing questions 21-30 out of questions