Informatica PR000007 ICP Exam Questions Instant Access

Question 1

Why should you use PowerCenter Metadata Exchange (MX) views rather than querying the PowerCenter repository tables directly- i.e. the ones that begin with OPB_?

AQuerying the PowerCenter repository tables directly is a violation of the PowerCenter license and terms of use.

BPowerConter repository tables store most data in proprietary binary format and hence are not directly readable. This binary format improves performance.

CStored (hard-coded) queries against the repository tables may become invalid upon a repository version upgrade due to the fact that the repository table structures may change.

DIt is not possible to query the repository tables directly.

Answer : B

Question 2

The Informatica Administrator can be used to do all of these actions except for which one?

ATo create a domain.

BTo shut down a domain.

CTo create a service.

DTo apply a different license key to a service.

Answer : D

Question 3

When copying and replacing folders in PowerCenter version 9.10 , which of the following statements is true?

AThe move is performed in two steps. The first step involves copying the source folder contents Into temp tables. At this point the target repository is in a read-only mode. The second step involves moving the information from the temp tables into the target folder. During this step the repository is locked.

BThe move is performed in one step. This involves copying the source folder contents into the target folder. During this step the repository is locked.

CThe move is performed in two steps. The first step involves copying the source folder contents into XML files. The second step involves importing the XML files into the target folder. During this
step the repository is locked.

DThe Source Folder is copied Into the target folder. No locks are placed on the target repository.

Answer : D

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact= 8&ved=0CB8QFjAA&url=https%3A%2F%2Fcommunity.informatica.com%2Fservlet%2FJiveServle t%2Fdownload%2F9921934376%2FPC_910_RepositoryGuide_en.pdf&ei=jba7VIm6N8Tcat_pgfAE&usg=AFQjCNHOHv_uh qVy3dWwG4F7yu5AFf8TWQ&sig2=pmyPBr4C5WCuBicOeVbEOA&bvm=bv.83829542,d.d2s(pag e 104, 105)

Question 4

Which of the following statements is true about running a PowerCenter workflow?

AThe Data Transformation Manager (DTM) process starts and locks the workflow and runs the workflow tasks.

BThe PowerCenter Integration Service process starts and locks the workflow and runs the workflow tasks.

CThe Data Transformation Manager (DTM) process starts the PowerCenter Integration Service process to run each Session and Command task within a workflow.

DPowerCenter Invokes the Data Transformation Manager (DTM) only when the developer saves a mapping.

Answer : B

http://addarr.me/2013/01/02/integration-service-architecture-informatica/

Question 5

Why would a repository service be placed in Exclusive mode?

AIf the repository service will be the only service running on a node.

BIf the repository service is not to be configured to run in backup mode.

CIn order to change a property of the repository service.

DIf it is desired to prevent the repository service from running as part of a grid.

Answer : C

Question 6

What factors must be considered to import an object stored as XML into a repository?

AThe user who created the original object.

BThe privileges and permissions on the original object.

CThe PowerCenter version or dot-version of the original object.

DThe PowerCenter version or dot-version of the original object, and the privileges and permissions on the original object.

Answer : B

Question 7

Which statement is true regarding object copy across folders in the Repository Manager?

AYou can copy an object even though it has been checked out or has a write-intent lock.

BThe Repository service will lock the repository database until the objects have been copied.

CIt is best practice to export the objects as XML prior to performing the copy operation.

DYou must have write permissions in both the origin folder and the destination folder.

Answer : B

Informatica PowerCenter Data Integration 9.x Administrator Specialist PR000007 ICP Exam Questions