Deck 2: PowerCenter Data Integration 9.x Administrator Specialist

Question 1

Which of the following services does not require a database connection as part of its configuration?

A) The Powercenter Repository service.
B) The Powercenter Integration Service.
C) The PowerCenter Designer Service.
D) The Reporting Service.

Answer 1

The PowerCenter Designer Service.

Question 2

What needs to be done to inherit domain privileges''

A) Use domain folders.
B) Use domain groups.
C) Set the privileges on a set-vice level.
D) Set the privileges on a service or group level.

Answer 2

Use domain groups.

Question 3

Which application(s) can be used to copy a PowerCenter repository folder?

A) The Repository Manager.
B) The Repository Manager or the Informatica Administrator.
C) The Repository Manager or the Designer.
D) Any application except the Workflow Monitor.

Answer 3

The Repository Manager or the Informatica Administrator.

Question 4

Which object below can be imported into a domain from LDAP?

A) Permissions
B) Privileges
C) Groups
D) Roles

Question 5

Select the correct statement below regarding nodes

A) Each node must have a hostname set as a property of the node.
B) A minimum of two nodes are required for a running domain, one gateway node and one worker node.
C) Each node is running a service manager for each service on the node.
D) When a gateway node fails, the domain will shut down.

Question 6

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

A) Use the Informatica installer to install the Service Manager on the new node. Joining it to the existing domain.
B) Use 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.
C) Use the Informatica Administration create the new node. Then use the Actions menu to start the Service Manager on the new node.
D) You must first shut down the domain and then use the infa setup command to add the node.

Question 7

Which is a type of connection object you can create with PowerCenter?

A) FTP
B) TCP/IP
C) Partitioned
D) Dynamic database

Question 8

Where does Informatica 9.1 store encrypted passwords?

A) Domain Configuration database
B) PowerCenter Repository database
C) Domain Security database
D) Service Manager Repository

Question 9

Which of the following is true about PowerCenter Repositories and Integration Services?

A) An Integration Service may be connected to more than one Repository Service.
B) An Integration Service may be connected to only one Repository Service.
C) Repository Service is a client of an Integration Service.
D) A Repository Service may be connected to more than one Integration Service and an Integration Service may be connected to more than one Repository Service.

Question 10

What may be gained when registering more than one Integration Service to a single Repository Service?

A) Performance
B) Reliability
C) Redundancy to facilitate automatic failover
D) Ability to partition the sessions, assuming the partition license option has been purchased

Question 11

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

A) The 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.
B) The move is performed in one step. This involves copying the source folder contents into the target folder. During this step the repository is locked.
C) The 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.
D) The Source Folder is copied Into the target folder. No locks are placed on the target repository.

Question 12

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

A) This 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.
B) The Domain Administrator becomes the default Administrator. The password you assign to the Domain Administrator is assigned to the default Administrator.
C) The Domain Administrator becomes the default Administrator, but you must supply the current Administrator password or the Installation cannot proceed.
D) Two 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 13

Which of the following can be configured as the security protocol used for Domain Management?

A) SFTP (Secure File Transfer Protocol) or SSL (Secure Sockets Layer)
B) TCP/IP (Internet Protocol Suite) or TLS (Transport Layer Security)
C) SSH (Secure Shell) or SSL (Secure Sockets Layer)
D) SSL (Secure Sockets Layer) or TLS (Transport Layer Security)

Question 14

How many different repository services can be associated with a single integration service?

A) One
B) One or more
C) Zero or more
D) One if the integration service is not part of a grid, more than one if It is part of a grid

Question 15

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

A) The user who created the original object.
B) The privileges and permissions on the original object.
C) The PowerCenter version or dot-version of the original object.
D) The PowerCenter version or dot-version of the original object, and the privileges and permissions on the original object.

Question 16

Which statement below best describes how to change a worker node to a gateway node?

A) By changing a property of the node.
B) By changing a property of the node and the domain.
C) By changing a property of the node and setting each service that runs on that node to Primary node
D) By reinstalling the Service Manager on that node and configuring it to run as a gateway node.

Question 17

If a user is denied read permission on a folder, which of the following is true?

A) The folder is not visible in the Navigator window in any PowerCenter client.
B) The folder becomes a shared folder.
C) The folder has a red "X" over it.
D) The folder is grayed out in the Navigator window for any PowerCenter client.

Question 18

Which connection types are allowed for the Informatica Administrator interface?

A) HTTPS
B) HTTP or HTTPS
C) HTTPS or LDAP
D) Native or LDAP

Question 19

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

A) System roles cannot be edited and custom roles can be edited.
B) A custom role is created by editing a system role.
C) A custom role is created by copying a system role, renaming it and editing at least one of the privileges.
D) Any number of custom roles can be created within each system role.

Question 20

The Service Manager runs which functions on the Master Gateway Node in the domain?

A) Workflows, Configuration, and Alerting.
B) Security, Web Services, and Alerting.
C) Security, Configuration, and Alerting.
D) Web Services, Configuration, and Licensing.

Question 21

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.

Question 22

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.

Question 23

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.

Question 24

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.

Question 25

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.

Question 26

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.

Question 27

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

A) pmcep
B) infacmd
C) infasetup
D) pmcmd

Question 28

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.

Question 29

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.

Question 30

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.

Question 31

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.

Question 32

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.

Question 33

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

Question 34

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.

Question 35

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.

Question 36

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.

Question 37

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.

Question 38

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.

Question 39

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.

Question 40

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.

Question 41

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

A) When the master gateway node on the domains are running on different operating systems.
B) When the domain databases are in different database types (Oracle and Sybase, for example).
C) When the PowerCenter Repository Manager cannot access the repositories in both domains at the same time.
D) When the license key for Team Based Development - Deployment Groups is not available.

Question 42

Which step(s) must be followed to make a copy of the PowerCenter repository metadata? Assume that the source repository is in a separate domain from the new repository.

A) Backup the source repository to a file 2. Create a Repository Service for the new repository that has no tables 3. Restore the backup file to the new repository
B) Backup the source repository to a file 2. Create a Repository Service for the new repository that has tables 3. Restore the backup file to the new repository
C) Use the "Copy Contents" feature in the Administrator Tool
D) Create a Repository Service for the new repository that has no tables 2. In the Repository Manager Tool, click and drag the source repository to the new repository