Free FM0-305 Exam Dumps PDF Preview

Question 1

Single choice

Which statement is true about script parameters in FileMaker Pro 11?

A
Script parameters can include any number of repetitions.
B
A subscript inherits the script parameter of the script that called it.
C
Scripts set to run OnFirstWindowOpen cannot include script parameters.
D
When choosing scripts from the Scripts menu, script parameters can be added by holding down the Option (Mac OS X) or Alt (Windows) key.
E
Get( ScriptParameter ) results in a returndelimited list of script parameters for all currently running scripts in a window's script stack.

Reveal answer details Close answer details

Correct answerC

Question 2

Single choice

Given a text field myText that contains "<color>blue</color>", which formula extracts the word "blue" from the field?

A
Filter (myText "color")
B
MiddleWords (myText 2)
C
PatternMatch (myText "blue")
D
Middle ( myText Position ( myText "blue" 1 1 ) 4)

Reveal answer details Close answer details

Correct answerD

Question 3

Multiple choice

Which three are necessary to create and publish a PHPbased Web site using the PHP Site Assistant? (Choose three.)

A
a copy of FileMaker Pro 11 Advanced
B
a working installation of FileMaker Server
C
a development computer with Java installed
D
a development computer with the PHP runtime engine installed
E
one or more hosted database files with the [fmphp] extended privilege enabled for at least one active user account

Reveal answer details Close answer details

Correct answersB, C, E

Question 4

Multiple choice

Which three are valid types listed in the FileMaker Pro 11 Export Records to File dialog? (Choose three.)

A
PDF
B
XML
C
XSL
D
DBF
E
HTML Table
F
Access (.mdb)

Reveal answer details Close answer details

Correct answersB, D, E

Question 5

Multiple choice

A Text field called FirstLast in FileMaker Pro 11 is set to autoenterb the following formula:

FirstName & LastName.

FirstName and LastName are Text fields in the same table. The option Do not evaluate if all referenced fields are empty is unchecked. The option Do not replace existing value of field (if any) is checked.
Under which two circumstances will the value of the calculation be inserted into the FirstLast field?
(Chooseb two.)

A
a record is first created
B
a user selects the menu item Records > Relookup Field Contents
C
each time the value of the FirstName or LastName field is modified
D
any field value on the record is modified and the FirstLast field is empty
E
the FirstName or LastName field is modified and the FirstLast field is empty

Reveal answer details Close answer details

Correct answersA, E

Question 6

Single choice

What is a reason to use the Let() function in a formula for a FileMaker Pro 11 calculation field?

A
to set a variable $$status that can be displayed on a layout
B
to limit the iterations of a Loop() function used in the formula
C
to modify data in a text field referenced elsewhere in the formula
D
to define a custom function that can be used in other calculation formulas

Reveal answer details Close answer details

Correct answerA

Question 7

Multiple choice

Which three are required to use all of the features of FileMaker Server 11 Advanced for Macintosh? (Choose three.)

A
SSH
B
PHP Engine
C
Apache web server
D
the Console application
E
QuickTime Plugin for Macintosh
F
Java Runtime Environment (JRE)

Reveal answer details Close answer details

Correct answersB, C, F

Question 8

Multiple choice

Which two are required for a FileMaker Pro 11 user to access a supported external SQL Source (ESS) from a file being hosted by FileMaker Server 11? (Choose two.)

A
the [fmxdbc] extended privilege assigned to the user's privilege set
B
the ODBC/JDBC setting enabled in the FileMaker Server 11 Admin Console
C
a compatible ODBC driver installed on the FileMaker Server computer or the user's local computer
D
a validated path to the Data Source listed under the File Path List in the Edit Data Source dialog
E
an External ODBC Data Source in the Manage External Data Sources dialog for the hosted FileMaker database

Reveal answer details Close answer details

Correct answersC, E

Question 9

Multiple choice

Which two statements are true about the [Full Access] privilege set in a FileMaker Pro 11 database? (Choose two.)

A
It is the only privilege set that can use Custom Functions.
B
It is the only privilege set that can view the Relationships Graph.
C
It is the only privilege set that can modify field options in Table View.
D
It can be deleted only if another full access privilege set has been created.

Reveal answer details Close answer details

Correct answersB, C

Question 10

Single choice

Which statement is true about the Filter Portal Records feature in FileMaker Pro 11?

A
It can only be configured using FileMaker Pro Advanced.
B
It requires that one or more additional relationships be added to the Relationships Graph.
C
The portal filter calculation must refer to at least one field in the immediately related table.
D
The portal filter calculation may not refer to any globally stored fields, summary fields, or unstored calculation fields.
E
Any aggregate calculations (sum, count, etc.) based on the portal's relationship will not be affected by the portal filter calculation.

Reveal answer details Close answer details

Correct answerE

Question 11

Multiple choice

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

A
OnLayoutExit
B
OnViewChange
C
OnObjectEnter
D
OnObjectModify
E
OnObjectValidate

Reveal answer details Close answer details

Correct answersA, E

Question 12

Multiple choice

A script executed by a FileMaker Server schedule running on a Windows server exports a group of records to a tabdelimited file. The resulting file needs to be saved to the FileMaker Server Documents folder and the filename must contain a current timestamp appended to the word "orders_" (e.g.
"orders__01252010065656.tab").

Which two statements are true? (Choose two.)

A
Assuming a default installation of FileMaker Server, the resulting file will be located at:
B
\Users\Administrator\Documents.
C
Assuming a default installation of FileMaker Server, the resulting file will be located at:
D
\Program Files\FileMaker\FileMaker Server\Data\Documents.
E
When specifying the output file, use a file path that references a variable with the following value:
"filewin:" & Get ( DocumentsPath ) & "orders_" & Filter ( Get ( CurrentTimeStamp ) "0123456789") &
".tab".
F
When specifying the output file, use a file path that references a calculation field with the following value:
"filewin:" & Get ( DocumentsPath ) & "orders_" & Filter ( Get ( CurrentTimeStamp ) "0123456789") &
".tab".
G
When specifying the output file, use a file path that references a variable with the following value:
"filewin:" & Get ( ServerDocumentsPath ) & "orders_" & Filter ( Get ( CurrentServerTimeStamp )
"0123456789") & ".tab".

Reveal answer details Close answer details

Correct answersB, C

Question 13

Single choice

The following script is run from a record on a layout based on a table occurrence that is not related to the Product table occurrence: Go to Related Record [Show only related records Match found set From table: "Product" Using layout:

"Product" (Product)]

Delete All Records [No dialog]

What happens after the script is run?

A
All records in the current table are deleted.
B
All records in the Product table are deleted.
C
All records in the current found set are deleted.
D
All records in the current found set for the Product table are deleted.

Reveal answer details Close answer details

Correct answerC

Question 14

Single choice

A database has an Order table and a Customer table. There is a relationship between Customer and Order. On a layout based on the Customer table there is a portal showing all of that customer's orders for the current calendar year. The portal has no filter criteria applied. There is a calculation field in the Customer table, zSumOrders, that adds up the total amount of all the customer's orders for the year. This field is displayed below the portal.

Which one may cause the displayed value of zSumOrders on a customer record to change?

A
adding one or more sort criteria to the Orders portal
B
adding one or more sort criteria to the relationship on which the Orders portal is based
C
using Filter Portal Records to further limit the set of records displayed in the Orders portal
D
changing the criteria of the portal's relationship to further limit the set of records displayed in the Orders portal
E
selecting the Save record changes automatically setting in the Layout Setup dialog for the layout in question

Reveal answer details Close answer details

Correct answerD

Question 15

Single choice

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.

Reveal answer details Close answer details

Correct answerB

Question 16

Single choice

Given the following function:

Let ( [

name = "Rufus, Wainright, Smithers, Ltd., Inc."

x = MiddleWords ( name 2 3 )

y = WordCount ( name )

]

Right ( x y )

)

What is returned?

A
, Ltd
B
Ltd.,
C
hers,
D
thers
E
Wainr

Reveal answer details Close answer details

Correct answerA

Question 17

Multiple choice

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

A
Administrator Groups may be nested.
B
The Administrator Groups feature is only available in FileMaker Server 11 Advanced.
C
A group administrator can disconnect clients from databases in their Administrator Group.
D
A group administrator can limit the numbers of clients that can access hosted files within their Administrator Group.
E
A group administrator can change the FileMaker security settings for all databases in their Administrator Group.

Reveal answer details Close answer details

Correct answersB, C

Question 18

Multiple choice

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 <field name> in Table View

Reveal answer details Close answer details

Correct answersC, D

Free FM0-305 Exam Dumps Preview

Developer Essentials for FileMaker 11

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13

QUESTION 14

QUESTION 15

QUESTION 16

QUESTION 17

QUESTION 18

VOL	TYPE	QUESTIONS
1	Single choice	8
2	Multiple choice	10