Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-552
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-552.html

IBM InfoSphere Optim for Distributed Systems – V7.3.1

Question No: 41 – (Topic 1)

When performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ey Lookup?in the AccessWhen performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ?ey Lookup?in the Access Method of the Table Access Strategy panel for the Delete Request. Why might Optim be doing a scan even though you have specified to us e a key to access the table?

  1. The wrong index was chosen for the Optim Primary Key for the table.

  2. The table has a very large amount of data and the database engine has chosen a different access strategy than what you have specified.

  3. You do not have authority in the database to specify a key to use.

  4. Compare Row Contents option was not selectedprior to running the Delete Request.

Answer: A

Question No: 42 – (Topic 1)

Which two actions ensure the development of a quality, repeatable Test Data Management (TDM) process? (Choose two.)

  1. building andrunning Optim extract and convert requests

  2. comparing the output of convert requests with the output of archive requests

  3. setting up indices to ensure that restore functions perform adequately

  4. running load/insert requests to populate target test databases

  5. building test DBMS environments and subsystems

Answer: A,D

Question No: 43 – (Topic 1)

Click the Exhibit button.

Ensurepass 2018 PDF and VCE

Using the Optim Editor as shown in the exhibit, you have made multiple changes on each of the updated rows in the SALES and CUSTOMERS tables. You now decide that you want to undo the last change to row 1 in SALES. What should you do?

  1. Right-click on the row and choose quot;Undo Rowquot;.

  2. Right-click on the row and choose quot;Undo Changequot;.

  3. Right-click on the row and choose quot;Undo?.

  4. Right-click on the row and choose quot;Undo Allquot;.

Answer: C

Question No: 44 – (Topic 1)

Which two statements are true about Optim security roles? (Choose two.)

  1. Functional Privilege classes such as Create New Actions and Create New Definitions can be controlled using Roles.

  2. Privileges such asArchive Request and Compare Request can be controlled using Roles

  3. By default, the Access Control Domain allows access to all Optim Actions and

    privileges. Only denial of privileges can be assigned using roles.

  4. Default Roles may not be modified to allow or deny Functional Privilege Classes and New Action Privileges.

  5. Edit the FAD (File Access Definition) to control which roles has access to all of the files.

Answer: A,B

Question No: 45 – (Topic 1)

When setting up Optim Connect Studio, which of the following is true?

  1. Only one binding can be defined for each machine.

  2. Optim Connect Studio does not support renaming a binding.

  3. Parallel processing and Query Processor parameters are defined on the Server tab.

  4. Registration of the product is done using Optim Configuration.

Answer: B

Question No: 46 – (Topic 1)

What are functions of the Compare component?

  1. Track database changes, transform test data to protect privacy, and identify differences between databases.

  2. Track database changes, identify differences between databases, and analyze test data before and after the application is executed.

  3. Transform test data to protect privacy, identify differences between databases, and analyze test data before and after the application isexecuted.

  4. Track database changes, compare metadata to protect privacy, and analyze test data before and after the application is executed.

Answer: B

Question No: 47 – (Topic 1)

A tablecontains two columns, CUSTNAME and STATE. You have created the following character expression to mask CUSTNAME: SUBSTR(CUSTNAME,1,3) CONCAT #39;EE#39; SUBSTR(STATE,1) || SUBSTR(CUSTNAME,5,2) Given the values shown below for

CUSTNAME and STATE: CUSTNAME=SANDERSSTATE=GA What reflects the value of CUSTNAME after the character expression has been applied?

  1. ANDEEARS

  2. SANEEGER

  3. ANDEEGER

  4. SANEEAER

Answer: B

Question No: 48 – (Topic 1)

Which two of the following are true about a Restore Request? (Choose two.)

  1. You can Create, Modify, or Delete a Restore Request

  2. You cannot Modify a RestoreRequest

  3. Restore Request cannot be saved

  4. A Restore Request can be saved

  5. A Restore Request is required to put data back to the database

Answer: A,D

Question No: 49 – (Topic 1)

Consider the following Archive file name that is defined using macros:

/home/lt;$USERgt;/archives/lt;MON $SEQ6gt;.AF Which filenames would be generated from this macro? (Note: Assume that the file was created on Monday, February 2, 2009, by the person with the user ID of dev3x and the last sequential number assignedwas 263.)

  1. /dev3x/Feb000263.AF

  2. /home/dev3x/archives/MON 264.af

  3. /home/dev3x/archives/Feb264.af

  4. /home/dev3x/archives/MON000264.AF

Answer: D

Question No: 50 – (Topic 1)

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

  1. with ODM/Optim Connect and an ODBC/JDBC enabled query tool

  2. in a non-relational fashion as the relationships changed as part of the Convert process

  3. with Optim#39;s table Edit or Browse functions since the data is now in a table format

  4. in a relational fashion as the relationships are maintained as part of the Convert process

Answer: D

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

EnsurePass 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

Your email address will not be published. Required fields are marked *

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