Question 1

Infacmd is used to administer which of the following objects?

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?

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?

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?

Accepted Answer

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

Question 5

Pmcmd is used for which of the following tasks?

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.

Accepted Answer

The tables and objects will be preserved by default.

Question 7

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

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?

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?

Accepted Answer

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

Question 10

PowerCenter Web Service Hubs use which one of the following?

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

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?

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)?

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?

Accepted Answer

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

Question 15

What is the purpose of a Repository Service?

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?

Accepted Answer

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

Question 17

Which statement is true about Roles in Informatica?

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'?

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?

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?

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