IBM InfoSphere Optim for Distributed Systems

Question - 45 Maximum mark : - 83

Home
All Exams
IBM InfoSphere Optim for Distributed Systems Online Mock Tests
IBM InfoSphere Optim for Distributed Systems

In a Delete Request, Compare Row Contents has been checked on the General tab of the Delete Request Editor. What is the impact of this option?

The Delete Request will connect to all archive files which have been updated since the time of the Archive Process. ✘ Archive will delete rows which have been updated since the time of the Archive Process. ✘ Archive will only delete the rows which have been updated since the time of the Archive Process. ✘ Archive will not delete rows which have been updated since the time of the Archive Process. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

When using Optim to decommission a database, which statement is true?

All database indexes must be added to the Access Definitions used before archives are created. ✘ Column Maps must be created to mask sensitive data. ✘ All previous archives must be restored to the production database and then one archive file is created. ✘ One or more Access Definitions must be created that have every relevant table in the database. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which statement is true about Optim relationships?

Primary keys are required. ✘ Foreign keys are required. ✘ Corresponding columns must be identical and compatible. ✘ At least one side in a relationship must be specified by a column name. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A customer wants to archive all orders from the Order table that are older than 24 months (2 years). The column name used to determine this is called "Created". How can an Optim developer implement this requirement?

Create a storage profile that will automatically delete the archive after two years based upon the system date minus the created column if one record in the start table meets the criteria. ✘ Open the Orders access definition, position the cursor on the Order table and right click and use thearchive actions tab from the "TableSpecification" pop-up menu to enter a SQL statement fragment "Created before(24M)". ✘ Open the Orders access definition, position the cursor on the Order table and right click and use theSelection Criteria tab on the "TableSpecification" pop-up menu and find the "Created" column and enter the "before(24M)" for the selection criteria. ✘ Open the relationship editor for each child table related to orders and add "before(24M)" as anexpression. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following is true about the Archive Directory?

The Archive Directory is specified in the Object Tab. ✘ The Archive Directory is specified in the Access Definition. ✘ If a default Archive Directory is not specified, the default Data Directory specified in Personal Options isused. ✘ If a default Archive Directory is not specified, the default Data Directory specified in System Options isused. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You have extracted some data from production to use for a test. After the insert, you used the Edit function to change some values in specific rows to test certain logic in your program. You will be testing for several weeks and want to keep these special test cases, even though you may be re-loading your test data many times. Is there some way to retain these edited values so that they are not lost when the data is refreshed from the extract file?

There is no way to preserve the edits, you will have to re-edit those special test cases each time the data is refreshed from the extract file. ✘ Use Compare to generate a file of changes that you can use to update the test database after eachrefresh. ✘ Edit the original extract file to permanently change the values in these specific rows. ✘ After the data is edited, make an extract file of your test tables, and use this new extract file to refreshyour data after each test. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

What are functions of the Compare component?

Track database changes, transform test data to protect privacy, and identify differences between databases. ✘ Track database changes, identify differences between databases, and analyze test data before andafter the application is executed. ✘ Transform test data to protect privacy, identify differences between databases, and analyze test databefore and after the application is executed. ✘ Track database changes, compare metadata to protect privacy, and analyze test data before and afterthe application is executed. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

What does the Convert process do?

Works directly against the database to transform data. ✘ Transforms data in an Archive File to a non-comma separated file. ✘ Transforms data in an Extract File to a non-comma separated file. ✘ Works directly with the database to merge data. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

After running a Convert process, how can the data in the converted Extract File be browsed?

with ODM/Optim Connect and an ODBC/JDBC enabled query tool ✘ in a non-relational fashion as the relationships changed as part of the Convert process ✘ with Optim's table Edit or Browse functions since the data is now in a table format ✘ in a relational fashion as the relationships are maintained as part of the Convert process ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

Given the command line syntax shown below: PR0CMND /R JOB=ERSONNEL' OUTPUT=PER.TXT MONITOR+ QUIET+ PR0CMND /R JOB=?ERSONNEL' OUTPUT=PER.TXT MONITOR+ QUIET+ Which task is performed?

Runs the job named PERSONNEL, places the process report output in a file named PER.TXT, and displays prompts and error dialogs during the process. ✘ Schedules a job named PERSONNEL, stores the extracted data in a file named PER.TXT, anddisplays information dialogs during the process. ✘ Runs the job named PERSONNEL, places the process report output in a file named PER.TXT, anddisplays information dialogs during the process. ✘ Schedules the job named PERSONNEL, stores the extracted data in a file named PER.TXT, anddisplays prompts and error dialogs during the process. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

IBM InfoSphere Optim for Distributed Systems

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner