[Free] 2018(Jan) Dumps4cert Examcollection IBM C2090-552 Dumps with VCE and PDF 81-90

By | February 1, 2018

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan IBM Official New Released C2090-552
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/C2090-552.html

IBM InfoSphere Optim for Distributed Systems – V7.3.1

Question No: 81 – (Topic 2)

The Optim Directory is built as part of the installation on the first workstation. Which two statements are correct about the Optim Directory? (Choose two.)

  1. The Optim Directory can reside on DB2 LUW, Oracle orMicrosoft Access.

  2. There may be more than one Optim Directory and they may reside on both Windows and UNIX.

  3. The Optim Directory can reside on DB2 z/OS, Teradata or Microsoft SQL Server.

  4. The definitions can be migrated from one Optim Directory to another with an Export and Import process.

  5. The Optim Directory is always stored on a Windows workstation.

Answer: B,D

Question No: 82 – (Topic 2)

During a proof of concept, you successfully install and configure Optim to archive data from a DB2 LUWtest application database running on an AIX server.

  • A test archive (without deleting data) is initiated from the Optim Server running on a Windows 2003 server and runs successfully the first day.

  • The Optim directory is on a non-application databaseon the Windows 2003 server.

  • During the evening, the client site runs a security routine that automatically deletes any unknown or foreign objects (e.g., packages, plans, procedures) from the application databases running on the AIX server.

  • The next day, the same test archive will no longer run from the Optim Server. Which step must you perform to enable the archive to run?

  1. Drop and rebuild the Optim Directory using the Optim Directory wizard.

  2. Re-install the Optim Client andServer on the database AIX server.

  3. Update the DB Alias to the DB2 LUWtest application database.

  4. Configure security for the Optim Directory using the Optim Configuration wizard.

Answer: C

Question No: 83 – (Topic 2)

What are two benefits of using Optim archiving for application decommissioning? (Choose two.)

  1. Reduced maintenance costs because application and database maintenance and license fees are no longer paid for the old application and its database, but data remains accessible to the user community.

  2. Decommissioned data is needed every day by end-users and Optim caches it in memory so access is faster then the production database.

  3. Reporting from the application against thearchived data can be cheaper using tiered storage.

  4. Optim can store decommissioned data in a compressed format so it will take less storage then it did in production.

  5. Applications must continue to use data in a seamless manner.

Answer: A,D

Question No: 84 – (Topic 2)

Given the command line syntax shown below: PR0CMND /RJOB=ERSONNEL#39; OUTPUT=PER.TXT MONITOR QUIET PR0CMND /R JOB=?ERSONNEL#39;

OUTPUT=PER.TXT MONITOR QUIET Which task is performed?

  1. 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.

  2. Schedules a job named PERSONNEL, stores the extracted data in a file named PER.TXT, and displays information dialogs during the process.

  3. Runs the job named PERSONNEL, places the process report output in a file named PER.TXT, anddisplays information dialogs during the process.

  4. Schedules the job named PERSONNEL, stores the extracted data in a file named PER.TXT, and displays prompts and error dialogs during the process.

Answer: C

Question No: 85 – (Topic 2)

Which performance enhancement do multiple database connections providewhen used during an extract or archive?

  1. Multiple database connections allow you to extract/archive rows from multiple tables simultaneously including the Start table.

  2. Multiple database connections allow you to extract/archive rows from a single table concurrently.

  3. Multiple database connections allow you to extract/archive rows only from Reference Tables simultaneously.

  4. Multiple database connections cannot be used during extract or archive, only during delete.

Answer: B

Question No: 86 – (Topic 2)

Click the Exhibit button.

Dumps4Cert 2018 PDF and VCE

Given this information from the Relationships tab of an Access Definition, and the information from this ShowSteps report in the exhibit, why is the STATE_LOOKUP table listed as UNTRAVERSED?

  1. There is no active relationship for the STATE_LOOKUP table.

  2. Options (2) needs to be activated between SALES and STATE_LOOKUP.

  3. Options (1) needs to be de-activated between SALES and STATE_LOOKUP.

  4. The relationship between SALES and STATE_LOOKUP is unselected.

Answer: B

Question No: 87 – (Topic 2)

What is the function of the REMOVEROWS keyword on the Command Line Utility?

  1. Removes rows specified in the Point and Shoot List

  2. Removes rows specified in the Delete Request

  3. Removes the specified rows in the ROWBEGIN and ROWEND keywords

  4. Removes rows specified in selection criteria

Answer: D

Question No: 88 – (Topic 2)

Which of the following could be used as part of an Archive Request?

  1. Retrieval Definition

  2. Collection Name

  3. Extract File

  4. Restore Index

Answer: B

Question No: 89 – (Topic 2)

What does an Access Control List protect?

  1. the Optim program

  2. nav_util

  3. Optim Configuration tasks

  4. any Optim object

Answer: D

Question No: 90 – (Topic 2)

You have exported an Archive Request and checked the #39;export subordinate definitions#39;box. Which types of objects might you expect to find in the export file?

  1. Archive Request, Access Definition, Optim Relationships, Column Maps

  2. Archive Request and Access Definition only

  3. Archive Request, Access Definition, and Table Map

  4. ArchiveRequest, Access Definition, Storage Profile, Report Request

Answer: D

100% Dumps4cert Free Download!
Download Free Demo:C2090-552 Demo PDF
100% Dumps4cert Free Guaranteed!
C2090-552 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.