Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: geek65

FM0-302 FileMaker8 Developer Essentials Exam Questions and Answers

Questions 4

While in a FileMaker Pro 8 database on a layout based on the Customer table occurrence, the following script is run:

Show All Records

Go to Record/Request/Page [First]

Loop

If [Customer::Category <> "A"}

Omit Record

Else

Go to Record/Request/Page [Next; Exit after last]

End If

Exit Loop If [Get ( FoundCount )= 0]]

End Loop

After the script stops running, which two statements are true? (Choose two.)

Options:

A.

All customer records in Category A are omitted.

B.

If there are no Category A records, the found set is 0.

C.

All customer records in Category A are in a found set.

D.

If there are no Category A records, the found set is all records.

Buy Now
Questions 5

Which three techniques can be used to safely back up files hosted on FileMaker Server 8 while clients are accessing data? (Choose three.)

Options:

A.

Copy to a remote hard drive.

B.

Use the Save a Copy As command.

C.

Use an OS script to pause and copy files.

D.

Trigger a "Live" backup from a command line.

E.

Use a "Live" backup scheduled in the FileMaker Server 8 Task Scheduling assistant.

Buy Now
Questions 6

Click the Exhibit button

Consider a FileMaker Pro 8 database with two tables called Salesperson and Order, and a relationship between the two tables based on a SalespersonID field. The relationship is configured as shown in the exhibit. There is a layout called Salesperson Detail, based on the Salesperson table occurrence, with a portal showing Order records via the above relationship.

Which three statements are true? (Choose three.)

Options:

A.

Deleting a Salesperson record also deletes all related Order records.

B.

It is possible to create new Salesperson records by importing data into the Order table.

C.

It is possible to create a new Salesperson record using a Set Field [ ] script step in a script that runs in the context of the Order table occurrence.

D.

Users may create new Order records by entering data into the portal on the Salesperson Detail layout.

E.

It is possible to create a new Salesperson record by typing into a related salesperson field displayed on a layout that is based on the Order table occurrence.

Buy Now
Questions 7

When FileMaker Server 8 is set to Secure connections to FileMaker Server, which two statements are true? (Choose two.)

Options:

A.

Secure connections are typically faster because of data encryption.

B.

Secure Sockets Layer (SSL) is used by FileMaker Pro 8 client connections.

C.

Connections between FileMaker Server 8 and FileMaker Pro 8 are encrypted.

D.

Connections between FileMaker Server 8 Advanced and XML clients are encrypted.

Buy Now
Questions 8

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

Buy Now
Questions 9

In a FileMaker Pro 8 database, which two functions can be used to return error codes for use in your formulas? (Choose two.)

Options:

A.

Get(LastError)

B.

Get(CurrentError)

C.

EvaluationError()

D.

Status(CurrentError)

Buy Now
Questions 10

What is the maximum number of files that can be hosted on FileMaker Server 8?

Options:

A.

125

B.

250

C.

500

D.

The number is limited only by server hardware.

Buy Now
Questions 11

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.

Buy Now
Questions 12

Which two scripts steps in FileMaker Pro 8 lock a record? (Choose two.)

Options:

A.

Set Field [ ]

B.

Select All [ ]

C.

Go to Field [ ]

D.

Open Record/Request [ ]

Buy Now
Questions 13

Which two settings affect an Account that is authenticated via FileMaker but not an Account that is authenticated via an External Server? (Choose two.)

Options:

A.

Manage extended privileges

B.

Allow user to modify their own password

C.

User must change password on next login

D.

Disconnect user from FileMaker Server when Idle

Buy Now
Questions 14

Given the formula:

Choose( Qty / 100; 0; 2; 4; 6; 8 )

If the field Qty contains the value 250, what is the result?

Options:

A.

0

B.

2

C.

4

D.

6

E.

8

Buy Now
Questions 15

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.

Buy Now
Questions 16

Which three text functions are case sensitive? (Choose three.)

Options:

A.

Exact()

B.

Filter()

C.

Replace()

D.

Substitute()

E.

PatternCount()

Buy Now
Questions 17

Click the Exhibit button.

You have a FileMaker Pro 8 layout based on the table occurrence Classes and you have a portal showing records from the table occurrence Students.

If you place the field Teachers::Name into the portal, the result is _____.

Options:

A.

The text is repeated in each row of the portal.

B.

The name of the teacher for the first enrollment record for this table.

C.

The name of the teacher for the class repeated in each row of the portal.

D.

The name of the teacher for the first related teacher value for each student enrolled.

Buy Now
Questions 18

A script containing steps that are not web compatible is triggered by a client using Instant Web Publishing. When the script reaches the first step that is not web compatible, it will _____.

Options:

A.

stop executing only if Allow User Abort [ ] is set to Off

B.

warn the user and prompt whether to Continue or Exit

C.

always skip over the unsupported step and continue executing

D.

skip over the unsupported step and continue executing only if Allow User Abort [ ] is set to Off

Buy Now
Exam Code: FM0-302
Exam Name: FileMaker8 Developer Essentials Exam
Last Update: May 2, 2024
Questions: 120
FM0-302 pdf

FM0-302 PDF

$28  $80
FM0-302 Engine

FM0-302 Testing Engine

$33.25  $95
FM0-302 PDF + Engine

FM0-302 PDF + Testing Engine

$45.5  $130