Prep and try our FM0-306 valid and latest training questions & answers

Which two statements are true about the Administrator Groups feature in FileMaker Server 12 Advanced? (Choose two.)

• A. A user must have full access privileges in a file before being made a member of that file's Administrator Group
• B. A given database file may only be part of one Administrator Group at a time.
• C. Administrator Groups may be used to grant additional administrators the ability to open, close and back up specific sets of hosted databases
• D. Administrator Groups provide an additional layer of data security

Which statement is true about the ExecuteSOL calculation function in FileMaker Pro 12?

• A. An ExecuteSOL function can only modify the database schema if the user has [Full Access] privilege set or if it is executed from a script running with full access privileges.
• B. The only query that can be performed by the ExecuteSOL function is a Select.
• C. The ExecuteSOL function requires that a valid Data Source Name (DSN) has been configured either on the FileMaker Server 12 or for each FileMaker Pro 12 client that will
  access the function.
• D. The ExecuteSOL function can fetch a maximum of 32,767 rows per query.

What is needed to a use the Send Mail script step to send an email from a FileMaker Server 12 hosted database, using a server-side script?

• A. The script is set to Run script with full access privileges
• B. SMTP Options are properly configured in the Send Mail Options dialog for the script being executed.
• C. The SMTP gateway relay must be properly configured on the FileMaker Server 12.
• D. SMTP Information is properly configured in the General Settings tab of the FileMaker Server Admin Console.

Given a FileMaker Pro 12 database with the following script:

Show Custom Dialog ["No records found"; "No records matched your find criteria."] End If
Which two statements are true if there are no records where the Customer::Name field contains "Smith"? (Choose two.)

• A. Adding a Set Error Capture [On] step to the beginning of the script will cause the script to exit after the custom dialog displays its error message.
• B. Unless a Set Error Capture [On] step is added at the beginning of the script. Get (LastError) will not return an error value.
• C. Adding a Set Error Capture [On] step to the beginning of the script will suppress the default FileMaker error stating that no records match this set of find requests.
• D. Adding a Set Error Capture [On] step to the beginning of the script has no effect on whether or not the custom dialog displays its error message.

Which two options are available for providing credentials when connecting, via ESS, to a Microsoft SQL Server external ODBC data source in FileMaker Pro 12? (Choose two.)

• A. For the Macintosh client use the Use Open Directory (Single Sign-on)
• B. Create an extended privilege for each DSN and assign it to each privilege set needing access
• C. For the Windows client use the Use Windows Authentication (Single Sign-on)
• D. Specify the username and password in the extended privileges section of the privilege set for the DSN being accessed
• E. Specify username and password by calculation for each DSN