Which two features require indexing in order to work? (Choose two.)

A. List function

B. Dynamic subsummary reports

C. Autocomplete using existing values

D. Dynamic value lists based on FileMaker tables

E. Add Leading Group by in Table View

Which statement is true about the sort order of data in portals in FileMaker Pro 11?

A. If the relationship that defines the portal's record set includes a Sort records setting, unindexed fields in the sort setting will be ignored.

B. If the relationship that defines the portal's record set includes a Sort records setting, any sort setting applied to the portal in Layout mode will be ignored.

C. If the relationship that defines the portal's record set includes a Sort records setting, the sort setting will be restricted to field data from the portal's table.

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 sorted based upon the relationship closest to the portal's table occurrence.

E. 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, subsorting by the relationships closest to the portal's table occurrence.

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

Given the following two calculation fields, Time1 and Time2:

Time1 (Calculation, Time result) = Time ( 5 10 15 )

Time2 (Calculation, Time result) = Time1 + 60

What is the value of Time2?

A. 5:10:75

B. 18675

C. 5:11:15

D. 6:10:15

E. 65:10:15

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

defined as:

Case ( Length ( str ) > 1

Explode ( Left ( str Length ( str ) 1

) )

and "?" and

Left ( str Length ( str ) 1

)

str )

What is the result of Explode ( "Bob" )?

A. Bo B

B. B Bo

B

C. B B Bo

D. Bob B Bo

E. B Bo Bob

F. Bob Bo B

Which two statements regarding the Go to Related Records script step are true? (Choose two.)

A. The script step can specify a layout in another FileMaker Pro file as the destination layout.

B. If there are no related records, the destination layout will have 0 records in the found set.

C. The script step has the option to display the related records in any of the file's existing windows.

D. The script step has the option to show records related to the current record only or to all the records in the found set.

E. The Go to Related Records script step will not work if the destination table is based on an External Data Source of type ODBC.

Which statement is true about the use of encryption in FileMaker 11?

A. Network traffic between FileMaker Pro 11 and an ODBC client can be encrypted.

B. Network traffic between FileMaker Server 11 and the Web Publishing Engine can be encrypted.

C. When FileMaker Pro 11 is a client of another copy of FileMaker Pro 11, the network traffic between the two can be encrypted.

D. When FileMaker Pro 11 is a client of FileMaker Server 11, the network traffic between the two can be encrypted and the data stored on FileMaker Server 11 is encrypted on disk.

Which two are required to make a FileMaker Pro database accessible to remote applications using JDBC? (Choose two.)

A. The database is hosted using FileMaker Server 11 Advanced.

B. A properly configured DSN is installed on the computer hosting the database.

C. The ISAPI Filters must be enabled on Windows IIS (Internet Information Server).

D. A Java Virtual Machine (JVM) must be installed on the computer hosting the database.

E. The database has the [fmxdbc] extended privilege enabled in at least one privilege set associated with an active account.

Which two statements are true if two windows in a FileMaker Pro 11 database display records based on the same layout? (Choose two.)

A. If a record is being edited in one window, it cannot be edited in the other window.

B. A find performed in one window will be available as a Recent Find in the other window.

C. If a custom menu set is installed in one window, it will become the active menu set in the other window as well.

D. If a new record is created in one window, it will become the active record in both windows after it has been committed in the original window.

E. If a record is being edited in one window, the user will be prompted to save or revert the record when they attempt to switch to the same record in the second window.

Which two statements are true about the Status Toolbar? (Choose two.)

A. Record navigation via the Status Toolbar can be prevented by installing a Custom Menu.

B. The name and/or function of a status toolbar button can be changed by installing a Custom Menu.

C. The ability to add or remove buttons on the Status Toolbar can be prevented by installing a Custom Menu.

D. Users whose privilege set has Available menu commands set to Minimum cannot customize the Status Toolbar.

E. The initial settings of the Status Toolbar are stored with the database file and shared with all users of the hosted file.

F. Customization of the Status Toolbar can be prevented by running a script which contains the Show/ Hide Status Area [Lock Show] script step.