New Year Sale - Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

FM0-302 Questions and Answers

Question # 6

Which three practices allow editing field contents in Find mode but disallow data entry in Browse mode in FileMaker Pro 8? (Choose three.)

A.

using a Privilege Set

B.

using a Calculation field

C.

changing the settings in the Field Format dialog

D.

changing the settings in the Field Behavior dialog

E.

disabling the Allow entry into field format option

Full Access
Question # 7

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

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

Full Access
Question # 8

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

A.

Exact()

B.

Filter()

C.

Replace()

D.

Substitute()

E.

PatternCount()

Full Access
Question # 9

Given a stored calculation field modifiedBy that contains the following formula:

Evaluate ( Quote ("Modifiedby: " & Get (AccountName)) ; myField)

Which two statements are true? (Choose two.)

A.

The modifiedBy field will only be updated when the value of myField changes.

B.

The value of myField will be set to the results returned by the modifiedBy field.

C.

The modifiedBy field will be updated whenever a field other than myField is changed.

D.

The modifiedBy field will contain a complete history of everyone who has modified the current record.

E.

The Quote function is used so that the quotation marks around "Modifiedby: " will be escaped properly.

Full Access
Question # 10

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

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.

Full Access
Question # 11

Consider a FileMaker Pro 8 database with the following tables and fields:

Customer: customer_id, first_name, last_name

Order: order_id, customer_id, order_date

Product_Orders: order_id, product_id, quantity_ordered

Product: product_id, product_name, unit_price

Using only Cartesian cross-product ("x") relationships between table occurrences, sorting if necessary, which two actions can be performed? (Choose two.)

A.

determine the date of the most recent order

B.

display all records from the Customer table in a portal

C.

create a value list that shows all orders for a chosen customer

D.

create a portal to show one record for each product that has ever been ordered

Full Access
Question # 12

Consider two FileMaker Pro 8 files, Alpha and Beta, where a table from Beta appears as an externally referenced table occurrence on Alpha's Relationships Graph. Which three statements are true? (Choose three.)

A.

Layouts in Alpha can display data from Beta.

B.

Alpha can contain multiple valid file references to Beta.

C.

It is impossible to lock records in both Alpha and Beta simultaneously.

D.

Layouts from Beta cannot be displayed in the same window as layouts from Alpha.

E.

A table occurrence from Beta is required on Alpha's Relationships Graph in order to call a script in Beta from Alpha.

Full Access
Question # 13

Which two statements are true about sorted portals in FileMaker Pro 8? (Choose two.)

A.

If the portal contains fields from multiple tables, the relationship Sort records settings will not be inherited by the portal.

B.

If the relationship that defines the portal's record set includes a Sort records setting, the portal might inherit that sort order.

C.

If there are multiple sorted relationships defined between the layout's table occurrence and the portal's table occurrence, the portal records will combine the Sort records settings of all of those relationships.

D.

If there are multiple sorted relationships defined between the layout's table occurrence and the portal's table occurrence, the portal records will be based upon the relationship closest to the portal's table occurrence.

Full Access
Question # 14

What must be done to use the Allow FileMaker Pro clients to download updates automatically feature of FileMaker Server 8? (Choose three.)

A.

The desired plug-in must be enabled on FileMaker Pro 8.

B.

The desired plug-in must be available from FileMaker Server 8.

C.

The Auto Update plug-in must be enabled in FileMaker Pro 8.

D.

The Auto Update feature must be enabled on FileMaker Server 8.

E.

The prior version of the desired plug-in must already be installed on FileMaker Pro 8.

Full Access
Question # 15

Consider two files, Alpha and Beta, where tables from Beta are included in the Relationships Graph of Alpha as external table occurrences. What are two ways to rename Beta while preserving all functionality in Alpha? (Choose two.)

A.

change the file path of the Beta File Reference in Alpha

B.

rename Beta using the File > Save a Copy As... option

C.

rename any table occurrences that are based on Beta to match the new file name

D.

use Tools > Developer Utilities... in FileMaker Pro 8 Advanced to rename Beta

Full Access
Question # 16

What is a valid way of adding comments inside a calculation formula in FileMaker Pro 8 database?

A.

# Comment Here

B.

/* Comment Here */

C.

<* Comment Here *>

D.

<!-- Comment Here -->

Full Access
Question # 17

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

A.

Set Field [ ]

B.

Select All [ ]

C.

Go to Field [ ]

D.

Open Record/Request [ ]

Full Access
Question # 18

Click the Exhibit button.

You want to build a FileMaker Pro 8 database that models family relationships. One person may have many children. One person may also have many "parents" (including biological parents, guardians, step-parents, etc.).

You want to build the system in such a way that a single layout showing information about a person can also display two portals, one showing the names of all of the current person's children (if any) and the other showing the names of all of the current person's parents (if known).

Assume that personal names exist in only one table. There are no lookup fields or calculation fields in any tables, and there are no scripts in the file.

What is the minimum number of tables you must define in the Tables tab of the Define Database dialog to construct the layout?

A.

one

B.

two

C.

three

D.

five

Full Access