Question 1

Infacmd is used to administer which of the following objects?
A) Domain gateway, log events, workflows, application services.
B) Versioning. log events, grids, application services.
C) Domain gateway, log events, grids, application services.
D) Domain gateway, clients, grids, application services.

Accepted Answer

The answer of Infacmd is used to administer which of...

Question 2

Which of the following statements is true about running a PowerCenter workflow?
A) The Data Transformation Manager (DTM) process starts and locks the workflow and runs the workflow tasks.
B) The PowerCenter Integration Service process starts and locks the workflow and runs the workflow tasks.
C) The Data Transformation Manager (DTM) process starts the PowerCenter Integration Service process to run each Session and Command task within a workflow.
D) PowerCenter Invokes the Data Transformation Manager (DTM) only when the developer saves a mapping.

Accepted Answer

The PowerCenter Integration Service process is responsible for starting, locking, and running the workflow tasks in PowerCenter.

Question 3

Infasetup is used for which of the following tasks?
A) Create domain, restore domain, define repository service.
B) Backup domain, restore domain, update gateway node.
C) Backup domain, copy domain, define integration service.
D) Backup domain, restore domain, define integration service.

Accepted Answer

The answer of Infasetup is used for which of the...

Question 4

You are migrating a domain to a new domain database. What is the correct order of the next actions to complete the migration once the new domain database is successfully restored?
A) Start all nodes, update database configuration on each node, enable application services.
B) Update database configuration on each node, start all nodes, enable application services.
C) Enable application services, start all nodes, update database configuration on each node.
D) Start all nodes, enable application services, update database configuration on each node.

Accepted Answer

The answer of You are migrating a domain to a...

Question 5

Pmcmd is used for which of the following tasks?
A) Delete workflow, schedule workflow, ping service.
B) Start workflow, schedule workflow, ping service.
C) Start workflow, delete task, ping service.
D) Start workflow, schedule workflow, copy workflow.

Accepted Answer

Pmcmd is a command line utility used in Informatica to start workflows, schedule workflows, and ping the Integration Service to check its status.

Question 6

When creating a new repository service, a database username (schema) must be specified to hold the metadata tables Can the new repository service use a database schema that contains existing repository tables and objects? Assume you need to preserve the existing objects.
A) No. For a new repository service, the database schema must be empty.
B) No. When the new service is created, existing tables will be automatically dropped.
C) Yes. The tables and objects will be preserved by default.
D) Yes. The user must select the creation option, "Do not create new content.

Accepted Answer

The tables and objects will be preserved by default.

Question 7

Which command line tool is used to create Informatica user accounts?
A) pmcep
B) infacmd
C) infasetup
D) pmcmd

Accepted Answer

infacmd is the command line tool used to create Informatica user accounts.

Question 8

When creating a repository folder what does the Allow Shortcut option provide?
A) Objects in the folder can be created more quickly.
B) Metadata shortcuts will be allowed within this folder.
C) Metadata shortcuts will be allowed across repositories even if they are not in the same repository domain.
D) Shortcuts created in other folders may reference metadata from this folder.

Accepted Answer

The answer of When creating a repository folder what does...

Question 9

A node has been selected in the Informatica Administrator Domain Navigator window. The Processes tab for this node contains which of the following items?
A) All of the service processes and their statuses.
B) All of the workflows running on the node.
C) All of the service processes running on the node that are disabled.
D) All of the service processes running on the node that are enabled.

Accepted Answer

The answer of A node has been selected in the...

Question 10

PowerCenter Web Service Hubs use which one of the following?
A) The SOAP standard and a fixed XML data structure to receive requests and send responses to web service clients.
B) The RPC (Remote Procedure Call) standard to receive requests and send responses to web service clients.
C) The soap standard to receive requests and send responses to web service clients.
D) The rpc (Remote Procedure call) standard and a fixed XML data structure to receive requests and send ' ^responses to web service clients.

Accepted Answer

The answer of PowerCenter Web Service Hubs use which one...

Question 11

With respect to license keys used in the Informatica domain, choose the response below that is correct
A) Each license key object can have only one license key.
B) Each license key object can have multiple license keys.
C) Each service can be associated with multiple license keys.
D) One license key object is used for the domain, and it can have multiple keys associated with it.

Accepted Answer

The answer of With respect to license keys used in...

Question 12

If a domain contains only two nodes, which configuration below is not allowed?
A) Both nodes are gateway nodes at the same time, with Informatica automatically deciding which is the master gateway when the domain is started.
B) Both nodes are worker nodes at the same time.
C) One node or a master gateway, the other is a worker.
D) Only one node is active and it is the master gateway node.

Accepted Answer

Both nodes cannot be gateway nodes at the same time.

Question 13

You can create PowerCenter connection objects within which client tool(s)?
A) Workflow Manager
B) Workflow Manager or Workflow Monitor
C) Workflow Manager or Repository Manager
D) Repository Manager or Informatica Administrator

Accepted Answer

The answer of You can create PowerCenter connection objects within...

Question 14

You need to create 60 Informatica Domain users. You wish to assign them the same privileges without having to specify the privileges for each individual user. What is your recommended approach?
A) Place all the users in the same domain folder and set privileges on the folder.
B) Place all the users in the same group and set privileges on the group.
C) Create a role with the desired privileges and grant each user that role.
D) Use LDAP In conjunction with a domain folder organized with the desired privileges.

Accepted Answer

The answer of You need to create 60 Informatica Domain...

Question 15

What is the purpose of a Repository Service?
A) To run PowerCenter Workflows.
B) To run and schedule PowerCenter workflows, validate mappings.
C) To manage PowerCenter, Data Quality and Web Services metadata objects.
D) To manage PowerCenter metadata objects.

Accepted Answer

A Repository Service is used to run and schedule PowerCenter workflows, validate mappings, and manage PowerCenter, Data Quality and Web Services metadata objects.

Question 16

What is the purpose of operating system profiles?
A) To allow two or more workflows to run on the same node under different operating system users.
B) To allow two or more Integration Services to run on the same node under differed operating system users.
C) To allow two or more workflows to run on the same node while accessing different database connection users.
D) To allow two or more Integration Services to run a single workflow on two or more different nodes with different operating systems.

Accepted Answer

The answer of What is the purpose of operating system...

Question 17

Which statement is true about Roles in Informatica?
A) Roles may not contain any Privileges.
B) Roles may only be assigned to Users.
C) Roles are a collection of one or more privileges.
D) Roles may only be assigned to users in a native domain.

Accepted Answer

Roles in Informatica are a collection of one or more privileges that can be assigned to users or groups to control access to various functionalities.

Question 18

In Informatics 9.x, which is true about domain configuration backup using the infasetup command line program'?
A) It Backs up the domain database and all service databases that are part of that domain.
B) It backs up domain metadata to another domain database.
C) It backs up the domain configuration to a binary file.
D) It backs up the domain to two binary files, one of which holds an index and the other the data.

Accepted Answer

The infasetup command line program in Informatica 9.x is used to back up the domain configuration to a binary file.

Question 19

A customer has purchased license keys for nodes running both the Windows and UNIX operating systems Can they run one Windows node and one UNIX node?
A) Yes provided the nodes are in different domains.
B) Yes, if both nodes are within the same domain.
C) Yes, but this arrangement requires a PowerCenter Grid license to be activated.
D) Yes, but a primary service on one of the nodes cannot be configured to run as a backup service on the other node.

Accepted Answer

The answer of A customer has purchased license keys for...

Question 20

In reference to relational connections created in the PowerCenter Workflow Manager, which one of the following statements is true?
A) The connection environment SQL executes when a session connects to the database.
B) The transaction environment SQL executes Just before a COMMIT against the target.
C) The transaction environment SQL causes PowerCenter to ignore the Transaction Control Transformation.
D) You can use the connection environment SQL to set folder permissions in the PowerCenter repository database.

Accepted Answer

The connection environment SQL executes when a session connects to the database, allowing for initial setup or configuration needed for the session's database operations.

Exam 2: PowerCenter Data Integration 9.x Administrator Specialist

Infacmd is used to administer which of the following objects?

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

Infasetup is used for which of the following tasks?

You are migrating a domain to a new domain database. What is the correct order of the next actions to complete the migration once the new domain database is successfully restored?

Pmcmd is used for which of the following tasks?

When creating a new repository service, a database username (schema) must be specified to hold the metadata tables Can the new repository service use a database schema that contains existing repository tables and objects? Assume you need to preserve the existing objects.

Which command line tool is used to create Informatica user accounts?

When creating a repository folder what does the Allow Shortcut option provide?

A node has been selected in the Informatica Administrator Domain Navigator window. The Processes tab for this node contains which of the following items?

PowerCenter Web Service Hubs use which one of the following?

With respect to license keys used in the Informatica domain, choose the response below that is correct

If a domain contains only two nodes, which configuration below is not allowed?

You can create PowerCenter connection objects within which client tool(s) ?

You need to create 60 Informatica Domain users. You wish to assign them the same privileges without having to specify the privileges for each individual user. What is your recommended approach?

What is the purpose of a Repository Service?

What is the purpose of operating system profiles?

Which statement is true about Roles in Informatica?

In Informatics 9.x, which is true about domain configuration backup using the infasetup command line program'?

A customer has purchased license keys for nodes running both the Windows and UNIX operating systems Can they run one Windows node and one UNIX node?

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