Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

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. 
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 3

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

Accepted Answer

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

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

Accepted Answer

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. 
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 5

Which statement is true about Roles in Informatica?

Accepted Answer

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. 
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 6

Infasetup is used for which of the following tasks?

Accepted Answer

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. 
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 7

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

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. 
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 8

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

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. 
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 9

Select the correct statement below regarding nodes

Accepted Answer

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. 
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 10

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

Accepted Answer

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. 
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 11

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

Accepted Answer

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. 
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 12

Which connection types are allowed for the Informatica Administrator interface?

Accepted Answer

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

Question 13

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

Accepted Answer

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. 
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 14

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

Accepted Answer

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. 
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 15

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

Accepted Answer

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. 
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 16

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

Accepted Answer

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. 
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 17

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

Accepted Answer

A)  Performance 
B)  Reliability 
C)  Redundancy to facilitate automatic failover 
D)  Ability to partition the sessions, assuming the partition license option has been purchased 
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 18

Infacmd is used to administer which of the following objects?

Accepted Answer

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. 
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 19

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

Accepted Answer

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. 
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 20

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

Accepted Answer

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. 
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.

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

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

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

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

Which statement is true about Roles in Informatica?

Infasetup 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.

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

Select the correct statement below regarding nodes

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

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

Which connection types are allowed for the Informatica Administrator interface?

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

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

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

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

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

Infacmd is used to administer which of the following objects?

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

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

Data Quality 9.x Developer Specialist

PowerCenter Data Integration 9.x:Developer Specialist

Filters

Exam 2: PowerCenter Data Integration 9.x Administrator Specialist

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

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

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

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

Which statement is true about Roles in Informatica?

Infasetup 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.

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

Select the correct statement below regarding nodes

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

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

Which connection types are allowed for the Informatica Administrator interface?

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

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

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

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

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

Infacmd is used to administer which of the following objects?

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

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

Data Quality 9.x Developer Specialist

PowerCenter Data Integration 9.x:Developer Specialist

Filters