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

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!

IBM InfoSphere Optim for Distributed Systems – V7.3.1

Question No: 51 – (Topic 1)

Which Optim process(es) produce output which can be selectively restored to a database?

  1. Archive

  2. Archive, Compare, and Restore

  3. Extract and Archive

  4. Archive, Edit, Extract, Compare, and Restore

Answer: A

Question No: 52 – (Topic 1)

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

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

  2. Open the Orders access definition, position the cursor on the Order table and right click and use the archive actions tab from the quot;Table

    Specificationquot; pop-up menuto enter a SQL statement fragment quot;Created before(24M)quot;.

  3. Open the Orders access definition, position the cursor on the Order table and right click and use the Selection Criteria tab on the quot;Table

    Specificationquot;pop-up menu and find the quot;Createdquot; column and enter the quot;before(24M)quot; for the selection criteria.

  4. Open the relationship editor for each child table related to orders and add quot;before(24M)quot; as an expression.

Answer: C

Question No: 53 – (Topic 1)

Which of the following are included in an Access Definition?

  1. SelectionCriteria, Grouping Specifications

  2. Table Maps, Column Maps

  3. Column Lists, Report Specifications

  4. Privacy Functions, Sort Criteria

Answer: A

Question No: 54 – (Topic 1)

What identifies the tables, relationship traversals, and selection criteria for the data to be archived?

  1. Access Definition

  2. Archive File

  3. Browse Utility

  4. Storage Profile

Answer: A

Question No: 55 – (Topic 1)

You can specify the default minimum retention period for protecting Archive Files onCentera from deletion. How is the minimum retention period calculated?


  1. from the time the Archive Process copies the file to Centera

  2. from the time that the Archive Process copies the file to the local file system

  3. from the time Centera copies the file from the local file system

Answer: B

Question No: 56 – (Topic 1)

When performing an archive process that uses a Storage Profile, which action could be performed as a result of using the storage profile?

  1. Creates a connection to the database for use by the storage management device.

  2. Creates a connection to the storage management device and copies an Archive File to a backup device.

  3. Creates a storage allocation parameter for the storage or file management system.

  4. Creates a duplicate of the existing information from the Archive Repository on the storage management device.

Answer: B

Question No: 57 – (Topic 1)

When using Optim to decommissiona database, which statement is true?

  1. All database indexes must be added to the Access Definitions used before archives are created.

  2. Column Maps must be created to mask sensitive data.

  3. All previous archives must be restored to the production database and then one archive file is created.

  4. One or more Access Definitions must be created that have every relevant table in the database.

Answer: D

Question No: 58 – (Topic 1)

Which statement is correct with respect to setting expectations around archiveaccess and reporting?

  1. Access to archive data performs just like a database.

  2. ODM/Optim Connect must be used to access the archives.

  3. Access using ODM/Optim Connect provides nearline access to archived data.

  4. Archive data access should rarely berequired.

Answer: C

Question No: 59 – (Topic 1)

When you create a new Column Map, which of the following is NOT a valid source?

  1. A table in an Extract File

  2. A constant value

  3. A tablein an Archive File

  4. A table in a database

Answer: B

Question No: 60 – (Topic 1)

You have created an Access Definition containing multiple tables. The tables each have primary keys and additional non-unique indexes that have been added over the years. While defining this archive request you have the choice of defining archive indexes. Which statement is true?

  1. Archive indexes do not need to be defined since Optim has already detected and included the indexes in the archive request.

  2. Archive indexes will automatically be created to mirror the indexes that exist on the tables in the archive request.

  3. Archive indexes should be specified in the Access Definition to matchall of the indexes on the tables.

  4. Archive indexes should be specified in the Access Definition that will support the query workload planned for the archived data.

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