Welcome to CertificationDumps.com !

Are u looking to Pass your Certification Exam? Then you have came to the right place here you will find real exam questions of any exam taken from the testing center and aslo links to sites that sell them. So now passing your certification exam has become much easier than before all you have to do is memorize the questions you will see exactly the same questions in the real exam. In today world time is money so by this not only you save time plus you aslo save yourself the hassale of failing

November 23 2009

FileMaker FM0-304 Dumps

Developer Essentials for FileMaker 10

  • Exam Number/Code : FM0-304
  • Exam Name : Developer Essentials for FileMaker 10
  • Questions and Answers : 191 Q&As

Download Pass4sure FM0-304 Dumps from the link below
Download CertifyMe FM0-304 Dumps from the link below
Download Testking FM0-304 Dumps from the link below


Download FileMaker FM0-304 Dumps



PrepKing.com FileMaker FM0-304 Sample Questions
1. A script saves a group of records as a PDF. The resulting file needs to be saved on a user’s desktop and
the filename must contain that person’s name along with the current date (without additional user input).
How should the output file be specified in the script step?
A. Use a file path that references a variable containing the desired filename and path.
B. Use a file path that references a globally stored field containing the desired filename and path.
C. Use a file path defined by a calculation formula that uses both Get (DesktopPath) and the Get
(UserName) functions.
D. Use a file path that references a calculation field that uses both Get (DesktopPath) and the Get
(UserName) functions.
Answer: A
2. A table in a FileMaker Pro 10 database has a field CompanyName of type Text. 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?
A. All of the records will be imported. No error message will be displayed.
B. All of the records will be imported. The user will also see the custom error message.
C. None of the records will be imported. The user will also see the specified custom error message.
D. All records with a value for CompanyName will be imported. The user will also see the specified custom
error message.
E. 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 could not be imported due to errors, along with a count
of those records.
Answer: A
3. Given the following Relationships Graph:
PrepKing.com
The users want to view a list of unique product records purchased by a found set of customers from the
state of NY.
If the data in the system supports this request and there are no changes to the Relationships Graph, which
two techniques successfully accomplish this? (Choose two.)
A. On a layout based on Customer, include a portal based on the Product table occurrence. Find where
State = “NY”.
B. On a layout based on Customer, Find where State = “NY”. Navigate to a layout based on the Products
table. Select the menu Records > Saved Finds and choose “NY” under Recent Finds.
C. On a layout based on Customer, Find where State = “NY”. Then run a script with the step Go To
Related Records[ ], using Match all records in current found set to navigate to the desired set of Product
records.
D. Run a script from a special Customer layout that performs a Copy All Records/Requests[ ] script step,
then navigates to a Product layout including a Customer portal, uses Paste[ ] into a Find request, and finally
Perform Find[ ] to result in the desired found set.
E. Use a script to loop through the found set of Customer records, assembling a set of ID values into a
global variable $$customers. Navigate to a layout based on Products and in Find Mode enter the
Customer::State field. Choose the menu Requests > Paste Requests and specify State = $$customers.
Click OK to perform the Find.
Answer: BC
4. Which two events can activate an OnObjectModify script trigger? (Choose two.)
A. selecting a checkbox
B. scrolling in a portal
C. scrolling in a text field
D. switching tabs in a tab control
E. clicking a link displayed in a Web Viewer
PrepKing.com
Answer: AD
5. What is a reason to use the Let() function in a formula for a FileMaker Pro 10 calculation field?
A. to limit the iterations of a Loop() function used in the formula
B. to modify data in a text field referenced elsewhere in the formula
C. to define a custom function that can be used in other calculation formulas
D. to set a global variable $$var that can be used elsewhere (e.g. within a script)
Answer: D
6. Given the following formula:
Case (
PatternCount (Name ; ” ” ) > 2 ; RightWords (Name ; 2) ;
Position (Name ; ” ” ; 1 ; 1 ) > 0 ; LeftWords (Name ; 2) ;
MiddleWords (Name ; 2 ; 2)
)
If the field Name contains “John Q. Adams”, what will the formula return?
A. John Q
B. John Q.
C. Q Adams
D. Q. Adams
Answer: A
7. A FileMaker Pro 10 database contains the following two scripts:
Script A:
Set Variable [$$varFoo; Value:Get ( ScriptParameter)]
Perform Script ["Script B"; Parameter: $$varFoo / 2]
Show Custom Dialog [$$varFoo]
Script B:
Set Variable [$counterStart; Value:Get ( ScriptParameter)]
Set Variable [$counter; Value:$counterStart]
PrepKing.com
Set Variable [$x; Value:1]
Loop
Set Variable [$$varFoo, Value:$$varFoo + $x]
Set Variable [$x; Value:$x + 1]
Set Variable [$counter; Value:$counter-1]
Exit Loop If [$counter < .5 * $counterStart]
End Loop
Exit Script [Result:$$varFoo]
With a Script Parameter of 11 passed into Script A, what result is shown in the custom dialog when Script A
completes?
A. 11
B. 12
C. 14
D. 17
E. 34
Answer: D
8. Which two statements are true about the [Full Access] privilege set in a FileMaker Pro 10 database?
(Choose two.)
A. It must be assigned to at least one account.
B. It is the only privilege set that can use Custom Functions.
C. It is the only privilege set that can view the Relationships Graph.
D. It can be deleted only if another full access privilege set has been created.
Answer: AC
9. According to the FileMaker Server Configuration Guide, which two hard drive configurations are
considered acceptable best practices for storage of hosted databases? (Choose two.)
A. RAID 1
B. RAID 0
C. RAID 1+0
PrepKing.com
D. RAID 5
Answer: CD
10. Which three are capabilities of the Save Records as PDF script step? (Choose three.)
A. append to existing PDF
B. specify email recipients
C. create a “PDF Form” document
D. create a directory to export a PDF document into
E. create a PDF based on a layout with a blank record
F. specify a PDF name by referencing a variable ($variable)
Answer: AEF
11. What is the maximum theoretical file size for a FileMaker Pro 10 file?
A. 2 Gigabytes
B. 4 Gigabytes
C. 8 Gigabytes
D. 2 Terabytes
E. 8 Terabytes
Answer: E
12. What is the theoretical maximum record count in FileMaker Pro 10 file?
A. 100 million records
B. 4 billion records
C. 8 trillion records
D. 64 quadrillion records
E. 128 quadrillion records
Answer: D
13. What is the maximum number of recursive calls that can be made utilizing a custom function in
FileMaker Pro 10 Advanced?
PrepKing.com
A. 10,000
B. 32,000
C. 50,000
D. 64,000
Answer: C
14. What is the maximum allowable depth of the call stack at any point in a FileMaker Pro 10 Advanced
custom function?
A. 8,000 calls
B. 10,000 calls
C. 16,000 calls
D. 50,000 calls
Answer: B
15. What is the maximum size of binary data that can be stored in a container field?
A. 1 gigabytes
B. 2 gigabytes
C. 4 gigabytes
D. 8 gigabytes
Answer: C
16. What is the maximum size of a calculation formula, including text and numbers, any referenced fields,
operators, functions, and parentheses?
A. 1,024 characters
B. 8,000 characters
C. 16,000 characters
D. 30,000 characters
E. 32,000 characters
Answer: D
PrepKing.com
17. What is the maximum number of files that can be hosted on FileMaker Server 10 Advanced?
A. 50
B. 100
C. 125
D. 250
E. 999
Answer: C
18. Using FileMaker Server 10, which two groups of ports must be open to provide database services, web
services, and administrative services via the Admin Console? (Choose two.)
A. 80, 5003, 16004
B. 80, 5003, 16000
C. 5003, 5006, 16014
D. 16001,16016, 16018
E. 16001, 16004, 16007
Answer: BD
19. Which five operating systems are supported for FileMaker Server 10 and FileMaker Server 10
Advanced? (Choose five.)
A. Mac OS X 10.5.4
B. Mac OS X Server 10.4.9
C. Mac OS X Server 10.4.11
D. Windows XP Professional SP2
E. Windows Vista Business SP1
F. Windows NT Server SP4
G. Windows Server 2003 Standard Edition SP2
H. Windows Server 2008 Standard Edition SP1
Answer: ACEGH
20. Which ports must be open when FileMaker Server 10 is on one machine to provide just database
PrepKing.com
services and full administration console functionality?
A. 5003,16000,16001
B. 5006, 16000,16001
C. 80, 5003,16000,16001
D. 80, 5006,16001,16004
E. 591, 5006,16001,16004
Answer: A
21. Which three must be enabled when using FileMaker Server 10 and Web publishing on 64-bit editions of
the Windows operating system? (Choose three.)
A. ISAPI filters
B. ISAPI extensions
C. Deployment Assistant
D. Windows Addressing Mode to 32-bit only
E. Enable 32-bit mode in FileMaker Server Admin Console
F. Application pooling compatibility with 32-bit applications
Answer: ABF
22. Which three does the HTML Database Design Report in FileMaker Pro 10 Advanced include? (Choose
three.)
A. a script triggers section
B. conditional formatting settings
C. object line, fill and effect settings
D. resizable layout object anchoring settings
E. the visibility status of fields in Table View
F. Text, Number, Date, and Time field formatting settings
Answer: BDE
23. Which two does the HTML Database Design Report in FileMaker Pro 10 Advanced include? (Choose
two.)

Download FileMaker FM0-304 Dumps


Filed Under (FileMaker) by admin
No Comments Read more

November 23 2009

FileMaker FM0-303 Dumps

FileMaker 9 Developer Essentials Exam

  • Exam Number/Code : FM0-303
  • Exam Name : FileMaker 9 Developer Essentials Exam
  • Questions and Answers : 215 Q&As

Download Pass4sure FM0-303 Dumps from the link below
Download CertifyMe FM0-303 Dumps from the link below
Download Testking FM0-303 Dumps from the link below


Download FileMaker FM0-303 Dumps



PrepKing.com FileMaker FM0-303 Sample Questions
1. In order to retain FileMaker Pro 6 database behavior, FileMaker Pro 9 may insert a Select Window script
step after which two of the following script steps as the file is converted? (Choose two.)
A. Open File
B. Go To Layout
C. Perform Script
D. Refresh Window
E. Go to Related Record
Answer: CE
2. Which two of the following are true about the Data Viewer in FileMaker Pro 9 Advanced? (Choose two.)
A. It always displays the values of all global variables defined in a file.
B. It can only be accessed by users with the [Full Access] privilege set.
C. It can be used to manually change the value of a variable during debugging of a script.
D. It automatically displays the values of fields referenced by calculations used in the currently running
script.
Answer: CD
3. Which three statements are true about field indexing in FileMaker Pro 9? (Choose three.)
A. Indexing improves the speed at which finds are performed.
B. Value lists require at least one referenced field to be indexed.
C. To establish a relationship between two fields, both fields are required to be indexed.
D. Using Unicode as the default language by which a field is indexed causes sorts on that field to be case
sensitive.
E. A value index, used in establishing relationships, stores up to 60 primary characters or digits per
return-delimited line.
Answer: ABD
4. In FileMaker Pro 9, which two statements about portals are true? (Choose two.)
A. Container fields can be placed in portals.
B. The initial row setting of a portal can be set by a script.
PrepKing.com
C. A sort order applied to a portal overrides any sort order set up for the relationship.
D. If there are multiple portals on a layout, the Go to Portal Row [First] script step will activate the portal
closest to the top, left corner of the layout.
Answer: AC
5. Click the Exhibit button.
A user wants to build a FileMaker Pro 9 database that models a business organizational chart. One person
may manage zero or more people. One person may be managed by, at most, one other person.
The user wants to build the system in such a way that a single layout about a person can display the name
of the current person’s manager as well as a portal of the people managed by the current person (as shown
in the Exhibit).
Assume that there are no lookup fields, calculation fields, or fields with auto-entered calculations defined in
any table, and there are no scripts in the file.
What is the minimum number of table occurrences that must be used to construct the layout?
A. 1
B. 2
C. 3
D. 4
Answer: C
6. A layout showing records from a People table has the Save record changes automatically check box
disabled in the Layout Setup dialog.
PrepKing.com
Which two actions cause FileMaker Pro 9 to display a dialog asking whether or not you want to save
changes to the current record? (Choose two.)
A. Importing records into the People table
B. Editing a field value on the layout and attempting to commit the record
C. Running a script that navigates to that layout, changes a field value, and performs a Commit
Records/Requests[No Dialog] script step
D. Running a script that navigates to that layout, changes a field value, and performs a Commit
Records/Requests[Skip data entry validation] script step
Answer: BD
7. Given: A one-to-many relationship from Planet to Moon. Which two formulas could be used as a
calculation field in the Planet table to return the name of the last related Moon record? (Choose two.)
A. Max (Planet::Name)
B. GetNthRecord (Planet::Name ; Count (Planet::Name))
C. GetNthRecord (Planet::Name ; Max (Planet::Name))
D. Let ( planetList = List (Planet::Name) ;
GetValue (planetList ; ValueCount (planetList)))
Answer: BD
8. Script A:
Allow User Abort [Off]
Go To Layout ["Layout1"]
Pause/Resume Script [Indefinitely]
Perform Script ["Script B"]
Go To Layout ["Layout2"]
Pause/Resume Script [Indefinitely]
Script B:
Go To Layout ["Layout3"]
Pause/Resume Script [Indefinitely]
Allow User Abort [On]
PrepKing.com
Go to Layout “Layout4″]
Pause/Resume Script [Indefinitely]
When Script A is run, on which layout(s) will both the “Continue” and “Cancel” buttons be displayed during
the Pause/Resume script steps? (Assume the Status Area is visible.)
A. Layout4
B. Layout1 and Layout3
C. Layout1 and Layout2
D. Layout2 and Layout4
E. Layout1, Layout2, and Layout3
Answer: D
9. Which three functions can be performed using the Save Records As PDF script step? (Choose three.)
A. Append to an existing PDF file
B. Add a password to an existing PDF file
C. Specify the magnification for the initial view
D. Enable the copying of text, images, and other content
E. Set the color scale of the document to Black & White
Answer: ACD
10. Which two statements are true about the [Guest] account that is included by default when creating a
new FileMaker Pro 9 database? (Choose two.)
A. It is not enabled.
B. It cannot be deleted.
C. It can log in without entering a password.
D. It can log in using Instant Web Publishing without entering either a username or password.
Answer: AB
11. Which software is required to share FileMaker data via ODBC to remote clients?
A. FileMaker Server 9
B. FileMaker Pro 9 Advanced
PrepKing.com
C. FileMaker Server 9 Advanced
D. Internet Information Server (IIS)
Answer: C
12. What is the maximum number of bytes available in a FileMaker Pro 9 text field?
A. 64 megabytes
B. 1 gigabyte
C. 2 gigabytes
D. 4 gigabytes
E. Limited only by disk space
Answer: C
13. What are the theoretical maximum limits of file size and record count in FileMaker Pro 9?
A. 8 gigabytes file size and 64 billion records
B. 64 gigabytes file size and 64 billion records
C. 2 gigabytes file size and 100 million records
D. 8 terabytes file size and 64 quadrillion records
Answer: D
14. What is the maximum number of characters that can be entered or imported into a single record’s text
field in FileMaker Pro 9?
A. 64 thousand
B. 1 million
C. 1 billion
D. 2 billion
E. Limited only by disk space
Answer: C
15. When publishing FileMaker 9 files for web access, which two statements are true? (Choose two.)
A. In order to work with a FileMaker Pro database via Instant Web Publishing, a user’s web browser must
PrepKing.com
have JavaScript enabled.
B. In order to access a FileMaker Pro database using Instant Web Publishing, a user account must have
the [fmiwp] extended privilege enabled.
C. A FileMaker Pro database may be configured for access via either Custom Web Publishing with XML OR
Custom Web Publishing with PHP, but not both.
D. A FileMaker Pro database hosted via Instant Web Publishing using the FileMaker Pro or FileMaker Pro
Advanced client can only be accessed by programs and users on the same computer.
Answer: AB
16. How many simultaneous Instant Web Publishing sessions can FileMaker Server 9 Advanced host?
A. 50
B. 100
C. 125
D. 250
Answer: B
17. When running FileMaker Server 9 Advanced in an environment that uses a firewall, which ports, at a
minimum, need to be open for FileMaker Pro 9 and FileMaker Server Admin Console to communicate with
FileMaker Server Advanced across the firewall from an end user machine?
A. Ports 5003, 5006, 50003
B. Ports 2399, 5003, 16000
C. Ports 5003, 16000, 16001
D. Ports 16000, 16001,16004
Answer: C
18. Click the Exhibit button.
PrepKing.com
A user can install FileMaker Server, the Web Publishing Engine, and all of the associated software
components on the same machine as the web server. Which two of the following groups of ports must be
open to provide database services, web services, and administrative services via the Admin Console?
(Choose two.)
A. 80, 5003, 16004
B. 80, 5003, 16000
C. 5003, 5006, 16014
D. 16001,16016, 16018
E. 16001, 16004, 16007
Answer: BD
19. Which of the following are supported in FileMaker 9 as External ODBC Data Sources?
A. Oracle 10g, Oracle 11g, SQL Server Express, SQL Server 2005, MySQL 5.0 Community Edition
B. Oracle 9g, Oracle 10g, SQL Server 2000, SQL Server 2005, MySQL 5.0 Community Edition
C. Oracle 10g, Oracle 11g, SQL Server 2000, SQL Server 2005, MySQL 5.0 Community Edition
D. Oracle 9g, Oracle 10g, SQL Server 2000, SQL Server 2005, MySQL 5.0 Enterprise Server
Answer: B
20. Which three of the following are supported operating systems for FileMaker Pro 9 and FileMaker Pro 9
Advanced? (Choose three.)
A. Mac OS X 10.4.8
B. Mac OS X 10.3.9
C. Windows Vista Ultimate
D. Windows XP Professional (Service Pack 1)
E. Windows XP Professional (Service Pack 2)
Answer: ACE
21. Which three of the following are supported operating systems for FileMaker Server 9 and Filemaker
Server 9 Advanced? (Choose three.)
A. Mac OS X Server 10.4.9
PrepKing.com
B. Mac OS X Server 10.3.9
C. Windows NT Server SP4
D. Windows XP Professional SP2
E. Windows 2003 Server Standard Edition SP2
Answer: ADE
22. On conversion to FileMaker Pro 9, what does the old password from a FileMaker Pro 6 file become?
A. A privilege set
B. Only the account name
C. Only the account password
D. Both an account name and account password
Answer: D
23. Which two statements are correct regarding the FileMaker Pro 9 batch conversion process when
converting files from FileMaker Pro 6? (Choose two.)
A. A .fp7 extension is added to filenames that do not have file extensions.
B. Existing files are automatically suffixed with ‘Old’ (i.e., Customer Old.fp5).
C. A prompt is displayed asking where the converted files should be created.
D. Multiple files converted at the same time will be copied into one file with multiple tables.
E. A solution organized with files in nested folders should be converted one level at a time starting with the
files in the highest level / folder.
Answer: AC
24. When importing table schema and data using FileMaker Pro 9 Advanced, which statement is true?
A. Privileges from the source file are retained
B. Relationships between tables are imported
C. Tables can be imported directly from FileMaker Pro 6 files
D. The user must have [Full Access] privileges to both the source and destination files
Answer: D

Download FileMaker FM0-303 Dumps


Filed Under (FileMaker) by admin
No Comments Read more

November 23 2009

FileMaker FM0-302 Dumps

FileMaker8 Developer Essentials Exam

  • Exam Number/Code : FM0-302
  • Exam Name : FileMaker8 Developer Essentials Exam
  • Questions and Answers : 120 Q&As

Download Pass4sure FM0-302 Dumps from the link below
Download CertifyMe FM0-302 Dumps from the link below
Download Testking FM0-302 Dumps from the link below


Download FileMaker FM0-302 Dumps



PrepKing.com FileMaker FM0-302 Sample Questions
1. Which type of file results from converting a CDML format file using the FileMaker CDML Converter?
A. XSL style sheet
B. CSS style sheet
C. HTML document
D. XHTML document
Answer: A
2. On conversion to FileMaker Pro 8, what does the old password from FileMaker Pro 6 become?
A. a privilege set
B. only the account name
C. only the account password
D. both an account name and account password
Answer: D
3. Which two can be used to import data into a FileMaker Pro 8 file directly from FileMaker Pro 6, without
first having to export the data from FileMaker Pro 6? (Choose two.)
A. XML
B. SYLK
C. HTML
D. ODBC
Answer: AD
4. Which two are required for a plug-in to be used with Web Published databases? (Choose two.)
A. It must be installed on the Web browser.
B. It must not attempt to display information to the user’s screen.
C. It must be enabled for Web Publishing on FileMaker Server 8 Advanced.
D. It must be installed in the Plugins directory of the Web Publishing Engine.
Answer: BD
5. Which three Web Publishing options are available in FileMaker 8? (Choose three.)
A. Instant Web Publishing using FileMaker Pro 8
B. Instant Web Publishing using FileMaker Server 8
C. Custom Web Publishing using FileMaker Pro 8 Advanced
D. Instant Web Publishing using FileMaker Server 8 Advanced
E. Custom Web Publishing using FileMaker Server 8 Advanced
Answer: ADE
6. Which three technologies/products may be used in conjunction with FileMaker Server 8 Advanced to
produce custom Web pages? (Choose three.)
A. JSP
PrepKing.com
B. UML
C. PHP
D. CDML
E. XSLT
Answer: ACE
7. Which two statements are true for an account in a FileMaker Pro 8 database that is authenticated
externally? (Choose two.)
A. The database may be hosted on FileMaker Server 8.
B. The account is authenticated via : External Server.
C. The database may be hosted on FileMaker Pro 8 Advanced.
D. The account must be a member of a privilege set with the External Account extended privilege enabled.
Answer: AB
8. FileMaker Pro 8 allows five (5) failed login attempts before halting the re-login process. What are two
ways this behavior can be altered? (Choose two.)
A. set the Allow User Abort [ ] script step to [on]
B. set the Set Error Capture [ ] script step to [on]
C. put the Re-Login [ ] script step in a loop that exits when Get(LastError) equals 0
D. define the maximum number of attempts in the Edit Privilege Set dialog
Answer: BC
9. Which two statements are true about the [Full Access] privilege set? (Choose two.)
A. It can be deleted and/or renamed.
B. It must have at least one account associated with it.
C. Another privilege set with the same functionality can be created.
D. Associated accounts cannot log in over a network unless the [fmapp] extended privilege is enabled.
Answer: BD
10. Given a table, Table A in File A; which permissions allow access to data in Table A from another file, File
B?
A. File B must be opened by an account with [Full Access].
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.
Answer: C
11. When FileMaker Server 8 is set to Secure connections to FileMaker Server, which two statements are
PrepKing.com
true? (Choose two.)
A. Secure connections are typically faster because of data encryption.
B. Secure Sockets Layer (SSL) is used by FileMaker Pro 8 client connections.
C. Connections between FileMaker Server 8 and FileMaker Pro 8 are encrypted.
D. Connections between FileMaker Server 8 Advanced and XML clients are encrypted.
Answer: BC
12. Which two privileges are needed for a non [Full Access] privilege set to allow the creation and
modification of new layouts in a FileMaker Pro 8 database? (Choose two.)
A. Design layouts is checked in the Edit Account dialog.
B. [Any New Layout] layout privileges are set to modifiable.
C. Allow creation of new layouts is checked in the Edit Account dialog.
D. Allow creation of new layouts is checked in the Custom Layout Privileges dialog.
Answer: BD
13. Which three statements are true about field indexing in FileMaker Pro 8? (Choose three.)
A. Indexing improves the speed at which finds are performed.
B. Value lists require at least one referenced field to be indexed.
C. To establish a relationship between two fields, both fields are required to be indexed.
D. Using Unicode as the default language by which a field is indexed causes sorts on that field to be case
sensitive.
E. A value index, used in establishing relationships, stores up to 60 primary characters or digits per
return-delimited line.
Answer: ABD
14. A number field in FileMaker Pro 8 called AmountPaid is set to auto-enter the following formula:
Case (
AmountPaid > AmountDue;
TextColor (AmountPaid ; RGB (0; 255 ; 0));
AmountPaid > 0 ;
TextColor (AmountPaid ; RGB (255 ; 0 ; 0));
AmountPaid
)
The Do not replace existing value of field (if any) option is unchecked.
Which statement is true?
A. The calculation will only be evaluated the first time a value is entered into AmountPaid.
B. A user will not be able to manually edit the field once the calculation has been evaluated.
C. If the value in the AmountDue field is changed, the AmountPaid field will be re-evaluated.
PrepKing.com
D. The calculation will prevent a user from entering an incorrect value into the AmountPaid field.
Answer: C
15. Consider two files, Alpha and Beta, where tables from Beta are included in the Relationships Graph of
Alpha as external table occurrences. What are two ways to rename Beta while preserving all functionality in
Alpha? (Choose two.)
A. change the file path of the Beta File Reference in Alpha
B. rename Beta using the File > Save a Copy As… option
C. rename any table occurrences that are based on Beta to match the new file name
D. use Tools > Developer Utilities… in FileMaker Pro 8 Advanced to rename Beta
Answer: AD
16. Click the Exhibit button
Consider a FileMaker Pro 8 database with two tables called Salesperson and Order, and a relationship
between the two tables based on a SalespersonID field. The relationship is configured as shown in the
exhibit. There is a layout called Salesperson Detail, based on the Salesperson table occurrence, with a
portal showing Order records via the above relationship.
Which three statements are true? (Choose three.)
PrepKing.com
A. Deleting a Salesperson record also deletes all related Order records.
B. It is possible to create new Salesperson records by importing data into the Order table.
C. It is possible to create a new Salesperson record using a Set Field [ ] script step in a script that runs in
the context of the Order table occurrence.
D. Users may create new Order records by entering data into the portal on the Salesperson Detail layout.
E. It is possible to create a new Salesperson record by typing into a related salesperson field displayed on a
layout that is based on the Order table occurrence.
Answer: CDE
17. Which three statements about field validation are true in FileMaker Pro 8? (Choose three.)
A. Fields can only be validated by a single criterion.
B. Field validation warnings may be triggered by scripts.
C. Users can be prevented from overriding the validation warning.
PrepKing.com
D. A script can be specified to run when manually entered field data fail validation.
E. Users can be presented with a specific message that they will see when a field fails validation.
Answer: BCE
18. Click the Exhibit button.
You want to build a FileMaker Pro 8 database that models a business organizational chart. One person may
manage zero or more people. One person may be managed by at most one other person.
You want to build the system in such a way that a single layout about a person can display the name of the
current person’s manager as well as a portal of the people managed by the current person (as shown in the
exhibit).
Assume that there are no lookup fields or calculation fields defined in any table, and there are no scripts in
the file.
What is the minimum number of table occurrences you must use to construct the layout?
A. one
B. two
C. three
D. four
Answer: C
19. A field in FileMaker Pro 8 has been set to validate Always. Which two actions will trigger validation on
that field? (Choose two.)
A. importing data into that field
B. making a change to the field’s data type
C. editing data in the field using Instant Web Publishing
D. clicking into the field, then immediately exiting the field
Answer: AC
20. Consider two FileMaker Pro 8 files, Alpha and Beta, where a table from Beta appears as an externally
referenced table occurrence on Alpha’s Relationships Graph. Which three statements are true? (Choose
PrepKing.com
three.)
A. Layouts in Alpha can display data from Beta.
B. Alpha can contain multiple valid file references to Beta.
C. It is impossible to lock records in both Alpha and Beta simultaneously.
D. Layouts from Beta cannot be displayed in the same window as layouts from Alpha.
E. A table occurrence from Beta is required on Alpha’s Relationships Graph in order to call a script in Beta
from Alpha.
Answer: ABD
21. Click the Exhibit button.
What changes need to be made to the database to create a portal on a layout tied to the Customer table
occurrence that displays all products (without duplication) that a customer has ever ordered?
A. No changes need to be made.
B. Create a calculation field in the OrderLineItem table that references the related product name.
C. Create a new relationship between the Customer table occurrence and the Product table occurrence.
D. Create a relationship between the Customer table occurrence and a second table occurrence of the
Product table.
Answer: A
22. Consider a FileMaker Pro 8 database with the following tables and fields:
Customer: customer_id, first_name, last_name
Order: order_id, customer_id, order_date
Product_Orders: order_id, product_id, quantity_ordered
Product: product_id, product_name, unit_price
PrepKing.com
Using only Cartesian cross-product (“x”) relationships between table occurrences, sorting if necessary,
which two actions can be performed? (Choose two.)
A. determine the date of the most recent order
B. display all records from the Customer table in a portal
C. create a value list that shows all orders for a chosen customer
D. create a portal to show one record for each product that has ever been ordered
Answer: AB
23. What is the maximum number of bytes that can be stored in a FileMaker Pro 8 text field?
A. 64 kilobytes
B. 2 gigabytes
C. 8 terabytes
D. The number is limited only by disk space.
Answer: B
24. A script saves a group of records as a PDF. The resulting file needs to be saved on a user’s desktop and
the filename must contain that person’s name along with the current date (without additional user input).
Which technique accomplishes this?
A. This can only be done using a plug-in.
B. When specifying the output file, you use a filepath that references a variable containing the desired
filename and path.
C. When specifying the output file, you use a filepath that references a globally stored field containing the
desired filename and path.
D. When specifying the output file, use a filepath that references a calculation field that uses both Get
(DesktopPath) and the Get (UserName) functions.
Answer: B
25. What two statements are true for FileMaker Pro 8 Advanced? (Choose two.)
A. The Data Viewer can only be used while debugging scripts.
B. The Script Debugger allows you to view any currently running script.
C. Using the Active Scripts pane in the Script Debugger, you can temporarily disable sub-scripts.
D. Using the Set Next Script Step function in the Script Debugger, you can alter the order in which
sub-scripts execute.
E. Using the Halt Script function in the Script Debugger, you can stop the execution of a sub-script and
return to the script that called it.
Answer: BD
26. Which two statements are true regarding the behavior of windows in FileMaker Pro 8 when using
Custom Menus? (Choose two.)

Download FileMaker FM0-302 Dumps


Filed Under (FileMaker) by admin
No Comments Read more

November 23 2009

FileMaker FM0-301 Dumps

Filemaker7 Developer Essentials Exam

  • Exam Number/Code : FM0-301
  • Exam Name : Filemaker7 Developer Essentials Exam
  • Questions and Answers : 120 Q&As

Download Pass4sure FM0-301 Dumps from the link below
Download CertifyMe FM0-301 Dumps from the link below
Download Testking FM0-301 Dumps from the link below


Download FileMaker FM0-301 Dumps



PrepKing.com FileMaker FM0-301 Sample Questions
1. What is the maximum number of files that can be hosted on FileMaker Server 7?
A. 125
B. 250
C. 350
D. 500
E. The number is limited only by server hardware.
Answer: A
2. What is the maximum number of characters that can be entered or imported into a text field in FileMaker
Pro 7?
A. 64 thousand
B. 1 million
C. 1 billion
D. 1 trillion
E. Number of characters is limited only by disk space.
Answer: C
3. If a field in FileMaker Pro 7 has been set to validate Always, which three actions will trigger validation
on that field? (Choose three.)
A. importing data into that field
B. exporting data from that field
C. editing data in the field using Instant Web Publishing
D. clicking into the field, then immediately exiting the field
E. attempting to change the value of the field using a Set Field[ ] script step
Answer: ACE
4. A number field in FileMaker Pro 7 called AmountPaid is set to auto-enter the following formula:.
PrepKing.com
The Do not replace existing value of field (if any) option is unchecked.
Which statement is true?
A. The calculation will only be evaluated the first time a value is entered into AmountPaid .
B. A user will not be able to manually edit the field once the calculation has been evaluated.
C. If the value in the AmountDue field is changed, the AmountPaid field will be re-evaluated.
D. The calculation will prevent a user from entering an incorrect value into the AmoundPaid field.
Answer: C
5. A database has two tables, Planet and Moon. Moons are related to a single planet and their
relationship is set to delete related records in the Moon table when a Planet record is deleted. Which
two things happen when the Planet table is deleted from the Tables tab of the Define Database dialog?
(Choose two.)
A. All data in the Planet table are deleted.
B. All records in the Moon table are deleted.
C. All records in the Moon table remain unaffected.
D. All records in the Moon table are deleted if the option to “Also remove occurrences of these tables in the
graph” was selected when deleting the Planet table.
E. All table occurrences of both Planet and Moon tables are removed if the option to “Also remove
occurrences of these tables in the graph” was selected when deleting the Planet table.
Answer: AC
6. Which two statements about relationships are true in FileMaker Pro 7? (Choose two.)
A. The > operator only works using numeric match fields.
B. You can build a relationship using multiple match fields.
C. It is possible to create a valid relationship where one match field is unindexed.
D. A table occurrence must be connected to at least one other table occurrence.
PrepKing.com
E. When enabling the option, “Allow creation of records in this table via this relationship”, only =, >=, <=
will properly populate match keys.
Answer: BC
7. Consider a FileMaker Pro 7 database with the following tables and fields:
Using only Cartesian (cross or x ) relationships between occurrences of these tables, sorting if necessary,
which two actions can be performed? (Choose two.)
A. determine the mode of the order amount
B. determine the date of the most recent order
C. display all records from the Customer table in a portal
D. create a value list that shows all orders for a chosen customer
E. create a portal to show one record for each product that has ever been ordered
Answer: BC
8. Which three statements are true about field indexing in FileMaker Pro 7? (Choose three.)
A. Indexing improves the speed at which finds are performed.
B. Value lists require at least one of any field they reference to be indexed.
C. To establish a relationship between two fields, both fields are required to be indexed.
D. A value index, used in establishing relationships, stores up to 60 primary characters or digits per
return-delimited line.
E. Using Unicode or ASCII as the default language by which a field is indexed causes sorts on that field to
be case sensitive.
Answer: ABE
9. Click the Exhibit button.
You want to build a FileMaker Pro 7 database that models a business organizational chart. One person may
manage no one or many people. One person may be managed by at most one other person.
You want to build the system in such a way that a single layout showing information about a person can
PrepKing.com
display both the name of the current person’s manager (if any) and the names of all people managed by the
current person.
What is the minimum number of tables you must define in the Tables tab of the Define Database dialog to
construct the layout?
A. one
B. two
C. three
D. four
Answer: A
10. Click the Exhibit button
Consider a FileMaker Pro 7 database with two tables called Salesperson and Order, and a relationship
between the two tables based on a SalespersonID field. The relationship is configured as shown in the
exhibit. There is a layout called Salesperson Detail, based on the Salesperson table occurrence, with a
portal showing Order records via the above relationship.
Which three statements are true? (Choose three.)
PrepKing.com
A. Deleting a Salesperson record also deletes all related Order records.
B. It is possible to create new Order records by importing data into the Salesperson table.
C. It is possible to create new Salesperson records by importing data into the Order table.
D. Users may create new Order records by entering data into the portal on the Salesperson Detail layout
E. It is possible to create a new Salesperson record using a Set Field [ ] script step in a script that runs in
the context of the Order table.
F. It is possible to create a new Salesperson record by typing into a related salesperson field displayed on a
layout that is based on the Order table.
Answer: DEF
PrepKing.com
11. Which three statements about field validation are true in FileMaker Pro 7? (Choose three.)
A. Fields can only be validated by a single criterion.
B. Field validation warnings may be triggered by scripts.
C. Users can be prevented from overriding the validation warning.
D. Users can be presented with a specific message that will see when a field fails validation.
E. A script can be specified to run when manually entered field data fails validation.
Answer: BCD
12. Consider two FileMaker Pro 7 files, Alpha and Beta, where a table from Beta appears as an externally
referenced table occurrence on Alpha’s Relationships Graph. Which three statements are true? (Choose
three.)
A. Layouts in Alpha can display data from Beta.
B. Alpha can contain multiple valid file references to Beta.
C. It is impossible to lock records in both Alpha and Beta simultaneously.
D. Layouts from Beta cannot be displayed in the same window as layouts from Alpha.
E. A table occurrence from Beta is required on Alpha’s Relationships Graph in order to call a script in Beta
from Alpha.
Answer: ABD
13. Click the Exhibit button.
You have a FileMaker Pro 7 layout based on the table occurrence of Classes. You have a portal showing
records from the table occurrence Students.
What happens if you place the field Students::Name into the portal?
A. The field displays <Field Missing> .
B. The field displays an enrolled student’s name in each row of the portal.
PrepKing.com
C. The field displays the first matching student’s name in every portal row.
D. The field displays an enrolled student’s name in each row of the portal only if the student name is
calculated in the Enrollment table.
Answer: B
14. Which statement is true in FileMaker Pro 7?
A. The Save record changes automatically layout option does not apply to users with [Full Access]
privileges.
B. On a layout by layout basis, you can specify whether record changes made in Browse mode will be
saved automatically.
C. On a layout by layout basis, you can specify whether changes made to the layout when exiting Layout
mode will be saved automatically.
D. If the Save record changes automatically option has been turned off for a layout, then users will be
prompted to save their changes only when exiting the layout.
Answer: B
15. Click the Exhibit button.
Given the FileMaker Pro 7 Relationships Graph shown in the exhibit, which table occurrence should be
assigned to a layout that contains a portal that shows all students for all of a teacher’s classes?
A. Classes
B. Advisors
C. Teachers
D. Enrollment
Answer: C
PrepKing.com
16. Which three are affected by changing the behavior of a field to navigate to the next field using Tab,
Enter and Return in FileMaker Pro 7? (Choose three.)
A. exiting a record
B. executing a find
C. scripted navigation
D. navigating tab order
E. continuing a paused script
Answer: ABE
17. You want to sort related records within a portal in a FileMaker Pro 7 database. What two methods allow
you to do this? (Choose two.)
A. select Sort by in the Edit Value List dialog
B. select Sort records in the Edit Relationship dialog
C. select Sort portal records in the Portal Setup dialog
D. select Sort records for the portal’s table occurrence in the Specify Table dialog
E. select the Records>Sort Records… menu item, then select the portal’s table occurrence in the Sort
Records dialog
Answer: BC
18. Click the Exhibit button.
On a FileMaker Pro 7 layout based on the table occurrence Teachers, a portal is designed to show all the
students based on the table occurrence Students. Which two statements are true about adding a new
student in the portal? (Choose two.)
A. The table occurrence Students must be directly connected to Teachers.
B. All the relationships from Teachers to Students must be set to be able to create records.

Download FileMaker FM0-301 Dumps

Filed Under (FileMaker) by admin
No Comments Read more
prepking

Tag Cloud

Adobe