FileMaker FileMaker Certification FM0-305 Questions & Answers

• Question 31:

  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.

  Correct Answer: AE

• Question 32:

  Which two are required for a user to successfully run a script that uses the Execute SQL script step? (Choose two.)

  A. a compatible ODBC driver on the computer executing the script

  B. an ODBC Data Source (DSN) on the computer executing the script

  C. the [fmxdbc] extended privilege assigned to the user's privilege set

  D. a Data Source in the Edit Data Source dialog for the file executing the script

  Correct Answer: AB

• Question 33:

  According to the FileMaker Server Configuration Guide, which two are considered best practices for backing up databases hosted by FileMaker Server? (Choose two.)

  A. use the Server Admin Console Schedule Assistant or fmsadmin tool to perform backups

  B. include the option toVerify backup integrity in backups performed during offpeak hours

  C. use enterpriseclass backup software to do a full system backup of the FileMaker Server at least once a week

  D. configure backup schedules to direct the backup of hosted databases directly to another computer or storage device

  E. use enterpriseclass backup software to do an incremental system backup of the FileMaker Server at least once a day

  Correct Answer: AB

• Question 34:

  Which two will allow an account to perform a serverside script in FileMaker Server 11? (Choose two.)

  A. The specified script is set to Run with Full Access.

  B. The Extended Privilege Access via Server Scripts [fmsscript] is checked.

  C. The Extended Privilege Access via FileMaker Network [fmapp] is checked.

  D. The Allow Enabled Schedules to Run is checked in the FileMaker Server Admin Console.

  E. The account under which the script is run must have privileges to execute the specified script.

  Correct Answer: DE

• Question 35:

  For serverhosted databases, FileMaker Server 11 Advanced is required for which three operations? (Choose three.)

  A. importing ODBC data

  B. acting as an ODBC data source

  C. sharing via Custom Web Publishing

  D. sharing via Instant Web Publishing

  E. accessing External SQL data sources

  F. sharing to more than 250 simultaneous FileMaker Pro users

  Correct Answer: BDF

• Question 36:

  Which two statements are true about a Daily Backup Schedule that includes the option to keep a maximum of seven backups? (Choose two.)

  A. FileMaker Server creates a subfolder each time the schedule is run and places all backups created at that time in the subfolder.

  B. FileMaker Server creates a subfolder for the schedule and saves all backups to it, appending a timestamp to the name of each backed up file.

  C. On the eighth day of normal functioning, FileMaker Server moves all of the backups created by that schedule to an archive folder and begins creating a new set.

  D. On the eighth day of normal functioning, FileMaker Server deletes the oldest backup, which was done on the first day of the previous week, and replaces it with a new backup on the first day of the current week.

  Correct Answer: AD

• Question 37:

  LAN users of a hosted database are reporting slow performance. A Performance Monitor log file from the FileMaker Server machine reports a consistently high value on the Network Interface/Output Queue Length Performance Object Counter.

  The server has dual processors, 2Gb of RAM and three 7200 RPM hard drives configured using RAID 5. Which two steps would most likely improve performance? (Choose two.)

  A. install 2Gb of additional RAM

  B. replace the machine with one which has four processors

  C. install an additional network card and team it with the existing card

  D. replace the network card with a model which has an onboard processor

  E. install an additional hard drive and configure the drive subsystem using RAID 1+0

  Correct Answer: CD

• Question 38:

  What is the minimal requirement to add an external FileMaker data source table occurrence of Inventory from a file called DEPT to the Relationships Graph of a file called PROD?

  A. an active account associated with the [Full Access] privilege set in both PROD and DEPT

  B. an active account associated with any privilege set for PROD and any privilege set that can view Inventory in DEPT

  C. an active account associated with a privilege set that has the Manage External Data Sources option checked in both PROD and DEPT

  D. an active account associated with the [Full Access] privilege set in PROD and an active account for DEPT associated with any privilege set that can view Inventory

  E. an active account associated with a privilege set that has the Manage External Data Sources option checked in DEPT and a valid account with the [Full Access] privilege set in PROD

  Correct Answer: D

• Question 39:

  Given Table A in File A, which condition allows access to Table A while using another file called File B?

  A. File B must be opened and cascade its account credentials to File A.

  B. File A and File B must have an account with the same name and password.

  C. The privilege set associated with the account that is logged into File A must allow access to the records in Table A.

  D. The privilege set associated with the account that is logged into File B must allow access to the records in Table A.

  Correct Answer: C

• Question 40:

  A FileMaker 11 database is hosted from FileMaker Server 11 running on Windows Server 2008.

  Which two will allow a Macintosh OS X FileMaker Pro 11 client to access an External Data Source through ESS in this hosted database? (Choose two.)

  A. Enable ODBC/JDBC is checked in the ODBC/JDBC configurations tab of the Server Admin Console.

  B. The Windows and Macintosh OS X drivers are installed in the FileMaker Server extensions folder.

  C. Enable FileMaker Server to use plugins is checked in the Server plugins tab of the Server Admin Console.

  D. The Windows ODBC driver is installed with a System DSN to the external data source on the FileMaker Server computer.

  E. Authentication for the data source is set to prompt user for user name and password in the Edit Data Source dialog box for Manage External Data Sources.

  Correct Answer: DE