Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home FileMaker FM0-308

FileMaker FM0-308 Exam Practice Questions (P. 2)

  • Full Access (112 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #6
Consider a FileMaker 13 solution with the following tables and fields:

Assuming only the above relationships between table occurrences, using sorting if necessary, which two actions can be performed? (Choose two.)
  1. A
    Create a value list that shows all Invoices for a chosen Customer
  2. B
    Create a value list on a Product layout which displays all Customers
  3. C
    Find all of the Customers who have ever ordered a specific Product
  4. D
    Create a portal to display each Product that has been ordered by a Customer
  5. E
    Display all records from the Customer table in a portal on a layout for an Invoice Item record

Correct Answer:
BE

Question #7
A table in a FileMaker 13 solution has a text field CompanyName. The following field validation options are set for this field:
Validate data in this field only during data entry

✑ Allow user to override during data entry
✑ Require not empty
✑ Display custom message if validation fails
A user imports a set of records into this table. Some records have no value in the CompanyName field. What will occur?
  1. A
    All of the records will be imported, No error message will be displayed.
  2. B
    The user will see the custom error message, but the import will continue if the user overrides the error.
  3. C
    All records with a value for CompanyName will be imported. The user will see the specified custom message.
  4. D
    All records with a value for CompanyName will be imported. The user will see an error dialog from the FileMaker Pro application stating that some records

Correct Answer:
A

Question #8
A new solution is created with Iwo 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?
  1. A
    Since it is the only occurrence of the Client table on the graph, it cannot be deleted.
  2. B
    Any records in the Contracts table that were related to matching Client records are deleted.
  3. C
    The formula in the calculation field Name Full (defined as Name First & " & Name Last) will be broken.
  4. 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

Question #9
Which two FileMaker Pro 13 objects will display data contents even if unrelated to the current layout’s table occurrence? (Choose two.)
  1. A
    Merge variable
  2. B
    Indexed timestamp field
  3. C
    A text field from a shadow table
  4. D
    Globally stored number field placed in a portal
  5. E
    A container field defined with the Store as reference only option enabled

Correct Answer:
AD

Question #10
Which two statements are true about field indexing in FileMaker Pro 13? (Choose two.)
  1. A
    Calculation fields cannot be indexed.
  2. B
    Indexing improves the speed at which sorts are performed.
  3. C
    To establish a relationship between two fields, both fields are required to be indexed.
  4. D
    A field must be indexed in order for Auto-complete using previously entered values to function.
  5. E
    Minimal indexing indicates that either the value index or the word index has been created, but not both.

Correct Answer:
DE

Previous Questions Next Questions

All Pages