Free Informatica PR000007 Exam Dumps and PR000007 Exam Questions

Question No: 1

MultipleChoice

Complete the following sentence A process variable root directory is associated with a _?

Options

ANode

BIntegration service

CRepository service

DDomain

Question No: 2

MultipleChoice

When is it advisable to migrate PowerCenter repository objects between domains using the XML export-import method?

Options

AWhen the master gateway node on the domains are running on different operating systems.

BWhen the domain databases are in different database types (Oracle and Sybase, for example).

CWhen the PowerCenter Repository Manager cannot access the repositories in both domains at the same time.

DWhen the license key for Team Based Development - Deployment Groups is not available.

Question No: 3

MultipleChoice

What are the three basic security objects that are created and maintained in the Security tab of the Informatica Administrator?

Options

AUsers, Groups. Permissions

BUsers, Groups, Privileges

CUsers, Groups, Roles

DUsers, Groups, Folders

Question No: 4

MultipleChoice

Which statement best describes the relationship between system roles and custom roles?

Options

ASystem roles cannot be edited and custom roles can be edited.

BA custom role is created by editing a system role.

CA custom role is created by copying a system role, renaming it and editing at least one of the privileges.

DAny number of custom roles can be created within each system role.

Question No: 5

MultipleChoice

Which answer below correctly describes the process to add a new node to an existing domain?

Options

AUse the Informatica installer to install the Service Manager on the new node. Joining it to the existing domain.

BUse the Informatica installer to create a new domain with the new node. Then use the Informatica Administrator to join the new domain with the existing domain.

CUse the Informatica Administration create the new node. Then use the Actions menu to start the Service Manager on the new node.

DYou must first shut down the domain and then use the infa setup command to add the node.

Question No: 6

MultipleChoice

You enter the user name Administrator as the required Domain Administrator user during the installation of a new Informatica domain.

What is the result?

Options

AThis action is not permitted because the user Administrator is already built into the domain. You must supply another user name to be the Domain Administrator.

BThe Domain Administrator becomes the default Administrator. The password you assign to the Domain Administrator is assigned to the default Administrator.

CThe Domain Administrator becomes the default Administrator, but you must supply the current Administrator password or the Installation cannot proceed.

DTwo users named Administrator now exist, one of which is a Domain Administrator (with the password you supply) and the other is the default Administrator super user with the default password.

Question No: 7

MultipleChoice

What is best practice when using the folder copy method to deploy metadata?

Assume for this

Question:

Objects in the shortcut folder and the folder that is to be copied have both been modified

Objects in the shortcut folder are referenced by objects in the folder you wish to deploy

Options

ACopy the shortcut folder first, then the folder that you wish to deploy.

BCopy the folder you wish to deploy first, then the shortcut folder.

CYou may safely ignore the shortcut folder and only copy the folder you wish to deploy.

DCopy the shortcut folder with Repository Manager and the other folders with Workflow Manager.

Question No: 8

MultipleChoice

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

Options

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.

Question No: 9

MultipleChoice

In reference to relational connections created in the PowerCenter Workflow Manager, which one of the following statements is true?

Options

AThe connection environment SQL executes when a session connects to the database.

BThe transaction environment SQL executes Just before a COMMIT against the target.

CThe transaction environment SQL causes PowerCenter to ignore the Transaction Control Transformation.

DYou can use the connection environment SQL to set folder permissions in the PowerCenter repository database.

Question No: 10

MultipleChoice

Pmcmd is used for which of the following tasks?

Options

ADelete workflow, schedule workflow, ping service.

BStart workflow, schedule workflow, ping service.

CStart workflow, delete task, ping service.

DStart workflow, schedule workflow, copy workflow.