FileMaker FileMaker Certifications FM0-305 Questions & Answers

• Question 91:

  Which three statements are true about a Web Viewer object placed on a layout in a FileMaker Pro 11 file? (Choose three.)

  A. It can be defined as a button.

  B. It can support ActiveX controls (on Windows).

  C. It can render valid HTML (including CSS styles) stored in a global variable.

  D. It can be configured to show a Back button in the Web Viewer Setup dialog.

  E. It can be configured to log into a secured web sites by sending the current user's FileMaker Pro account name and password.

  Correct Answer: ABC

• Question 92:

  Given the following Relationships Graph for a FileMaker 11 database, where Employee, Manager, and Trainer are all table occurrences sharing the same source table:

  

  Assuming the relevant fields also exist in these tables, which two sets of data can be shown in portals without modifying the graph? (Choose two.)

  A. a portal of trainers that have taught their own manager

  B. a portal of students that have not enrolled in a class

  C. a portal showing a nonrepeating list of courseware titles taught by a trainer

  D. a portal of the classes that have been attended by a trainer's direct reports

  E. a portal of classes in which a manager enrolled with one or more of the manager's direct reports

  Correct Answer: CD

• Question 93:

  Given the following Relationships Graph for a FileMaker 11 database, where Employee, Manager, and Trainer are all table occurrences sharing the same source table:

  

  The database has the following layout, based on the Trainer table occurrence:

  If a developer adds the following fields to the portal:

  Class::Class Name

  Employee::Name

  Manager::Name

  Which data is shown in the portal?

  A. each of the trainer's classes, the first employee enrolled in each class, and the trainer as manager for that employee

  B. each of the trainer's classes, the first employee enrolled in each class, and the first related manager for each employee

  C. the first class each employee is enrolled in, all employees managed by the trainer, and the trainer as manager for each employee

  D. the first class each employee is enrolled in, all employees enrolled in any of the trainer's classes, and the first related manager for each employee

  E. the first of the trainer's classes in all rows, all employees enrolled in any of the trainer's classes, and the first related manager for each employee

  Correct Answer: E

• Question 94:

  A layout contains a portal, based on a relationship configured to allow creation of related records.

  The portal object has the name Portal_1. Which technique can be used to navigate to a field in the empty row at the end of Portal_1?

  A. use the Set Selection script step targeting a field in Portal_1, followed by the script step Scroll Portal [Last]

  B. use the Go To Field script step targeting a field in the desired portal, then use the Go To Portal Row [Last] script step

  C. assuming a field in the desired portal is in the tab order, use the arrow keys to activate the portal, then tab to the desired row and field

  D. use the Go To Portal[Portal_1] script step, followed by the Go To Portal Row [Last] script step and the Go To Field script step targeting the desired field

  Correct Answer: B

• Question 95:

  Which method can be used to sort related records within a portal in a FileMaker Pro 11 database?

  A. In Layout Mode, rightclick on a field in the portal and choose Sort Portal from the contextual popup menu.

  B. In Layout Mode, select the portal then choose Sort records in the Behavior section of the Data tab of the Inspector.

  C. In the Relationships Graph, change the Sort records setting in the Specify Table dialog for the portal's table occurrence.

  D. Run a script using the Sort Records [ ] script step, choosing the portal's table occurrence from the popup menu of the Sort related records checkbox option.

  E. Change the Sort records setting in the Edit Relationship dialog for the last relationship leading to the portal's table occurrence from the context of the layout's table occurrence on the Relationships Graph.

  Correct Answer: E

• Question 96:

  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.

  Correct Answer: D

• Question 97:

  Given the following relationship graph: Without inspecting the data, what is known about this database?

  

  A. There are no records in the Event table at this time.

  B. The Event table occurrence references a table from an external ODBC data source.

  C. There can be zero or one, but no more than one, Event record related to any Task record.

  D. The corner arrows indicate all three table occurrences reference tables from external data sources.

  E. From a layout based on the Event table occurrence, a portal could be drawn showing both related Task and Volunteer data.

  Correct Answer: E

• Question 98:

  Which statement is true about supplemental fields added to a table occurrence based on an External ODBC Data Source that uses MySQL?

  A. These fields may be indexed.

  B. All nontext data types are converted to text.

  C. These fields may only be of type Summary or Calculation.

  D. These fields will be added to the table definitions within MySQL.

  E. These fields will be lost if the schema of the MySQL table is changed and then the Sync button in the FileMaker Pro Manage Database dialog is used.

  Correct Answer: C

• Question 99:

  Which three FileMaker Pro 11 objects will display data contents even when unrelated to the current layout's table occurrence? (Choose three.)

  A. Merge variable

  B. Indexed Timestamp field

  C. A Text field from a shadow table

  D. Globally stored Calculation field

  E. Globally stored Number field placed in a portal

  F. A Container field defined with the Store as reference only option enabled

  Correct Answer: ADE

• Question 100:

  A new database is created with two tables, Client and Contracts. The only modification made on the Relationships Graph is to establish a relationship between them which is set to delete related records in Contracts when a record in Client is deleted.

  

  What happens when the Client table occurrence is deleted from the Relationships Graph?

  A. Since it is the only occurrence of the Client table on the graph, it can not be deleted.

  B. Any records in the Contracts table that were related to matching Client records are deleted.

  C. The formula in the calculation field Name Full (defined as Name First and " " and Name Last) will be broken.

  D. Any records in the Contracts table that were related to matching Client records will have values in the Client ID field deleted.

  Correct Answer: C