PR000041- Informatica PC Data Integration9.xDeveloper Set 6

Pmcmd is used for which of the following tasks?


Options are :

  • Delete workflow, schedule workflow, ping service
  • Start workflow, delete task, ping service.
  • Start workflow, schedule workflow, copy workflow.
  • Start workflow, schedule workflow, ping service.

Answer : Start workflow, schedule workflow, ping service.

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?


Options are :

  • Yes, if both nodes are within the same domain.
  • Yes provided the nodes are in different domains.
  • Yes, but this arrangement requires a PowerCenter Grid license to be activated.
  • Yes, but a primary service on one of the nodes cannot be configured to run as a backup service on the other node.

Answer : Yes, if both nodes are within the same domain.

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


Options are :

  • Any application except the Workflow Monitor.
  • The Repository Manager or the Designer
  • The Repository Manager
  • The Repository Manager or the Informatica Administrator

Answer : The Repository Manager or the Informatica Administrator

Which statement best describes the characteristics of system-defined roles?


Options are :

  • Created by informatica, cannot be edited or deleted by Administrator
  • Created by Informatica, may be edited or deleted by Administrator.
  • Created by Administrator, cannot be edited or deleted.
  • Created by Administrator, may be edited or deleted by Administrator

Answer : Created by informatica, cannot be edited or deleted by Administrator

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


Options are :

  • The connection environment SQL executes when a session connects to the database.
  • You can use the connection environment SQL to set folder permissions in the PowerCenter repository database.
  • The transaction environment SQL executes Just before a COMMIT against the target
  • The transaction environment SQL causes PowerCenter to ignore the Transaction Control Transformation

Answer : The connection environment SQL executes when a session connects to the database.

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


Options are :

  • One license key object is used for the domain, and it can have multiple keys associated with it.
  • Each service can be associated with multiple license keys
  • Each license key object can have only one license key.
  • Each license key object can have multiple license keys.

Answer : Each service can be associated with multiple license keys

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?


Options are :

  • Place all the users in the same domain folder and set privileges on the folder.
  • Create a role with the desired privileges and grant each user that role.
  • Place all the users in the same group and set privileges on the group.
  • Use LDAP In conjunction with a domain folder organized with the desired privileges

Answer : Use LDAP In conjunction with a domain folder organized with the desired privileges

Informatica Data Quality 10 Developer Specialist Set 1

Infacmd is used to administer which of the following objects?


Options are :

  • Versioning. log events, grids, application services.
  • Domain gateway, clients, grids, application services.
  • Domain gateway, log events, workflows, application services
  • Domain gateway, log events, grids, application services

Answer : Domain gateway, clients, grids, application services.

What is the purpose of operating system profiles?


Options are :

  • To allow two or more workflows to run on the same node under different operating system users
  • To allow two or more Integration Services to run a single workflow on two or more different nodes with different operating systems.
  • To allow two or more workflows to run on the same node while accessing different database connection users.
  • To allow two or more Integration Services to run on the same node under differed operating system users.

Answer : To allow two or more Integration Services to run a single workflow on two or more different nodes with different operating systems.

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


Options are :

  • Metadata shortcuts will be allowed within this folder.
  • Objects in the folder can be created more quickly
  • Shortcuts created in other folders may reference metadata from this folder.
  • Metadata shortcuts will be allowed across repositories even if they are not in the same repository domain

Answer : Metadata shortcuts will be allowed across repositories even if they are not in the same repository domain

Informatica Data Quality 10 Developer Specialist Set 2

How much data can DQA handle?


Options are :

  • .Million rows and 100 columns
  • There are no built-in restrictions. Large deployments will require more hardware and database tuning
  • Maximum 1 million rows and up to 10,000 columns
  • .2000 rows and 20 columns

Answer : .Million rows and 100 columns

Why should you use PowerCenter Metadata Exchange (MX) views rather than querying the PowerCenter repository tables directly- i.e. the ones that begin with OPB_?


Options are :

  • Querying the PowerCenter repository tables directly is a violation of the PowerCenter license and terms of use.
  • Stored (hard-coded) queries against the repository tables may become invalid upon a repository version upgrade due to the fact that the repository table structures may change.
  • PowerConter repository tables store most data in proprietary binary format and hence are not directly readable. This binary format improves performance.
  • It is not possible to query the repository tables directly.

Answer : PowerConter repository tables store most data in proprietary binary format and hence are not directly readable. This binary format improves performance.

Why would a repository service be placed in Exclusive mode?


Options are :

  • In order to change a property of the repository service.
  • If it is desired to prevent the repository service from running as part of a grid.
  • . If the repository service will be the only service running on a node.
  • If the repository service is not to be configured to run in backup mode.

Answer : In order to change a property of the repository service.

PR000041- Informatica PC Data Integration9.xDeveloper Set 1

Complete this sentence Each operating system profile can have a different _?


Options are :

  • Process variable root directory
  • Node
  • Integration Service
  • Log agent

Answer : Process variable root directory

What statement best describes IDQ's Web service capabilities?


Options are :

  • DQ has both native web service functionality and allows integration through PC
  • DQ mappings can only be made accessible through native means
  • .DQ has not web service support
  • .Mappings can only be created as a web service through PC integration

Answer : DQ mappings can only be made accessible through native means

Which connection types are allowed for the Informatica Administrator interface?


Options are :

  • HTTP or HTTPS
  • HTTPS
  • Native or LDAP
  • HTTPS or LDAP

Answer : HTTP or HTTPS

PR000041- Informatica PC Data Integration9.xDeveloper Set 2

How are license keys obtained for Informatica products?


Options are :

  • As a separate download
  • License keys can be generated on-site using your product code and the informatica Administrator
  • License keys can be generated on-site using the mfasetup.sh script.
  • Encoded on the install CD.

Answer : As a separate download

Which of the following permissions can be associated with a PowerCenter repository folder?


Options are :

  • Execute
  • Create runtime objects
  • Grant
  • Create global objects

Answer : Execute

The Informatica Administrator can be used to do all of these actions except for which one?


Options are :

  • To apply a different license key to a service
  • To shut down a domain.
  • To create a domain
  • To create a service.

Answer : To apply a different license key to a service

PR000041- Informatica PC Data Integration9.xDeveloper Set 3

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?


Options are :

  • Update database configuration on each node, start all nodes, enable application services.
  • Start all nodes, enable application services, update database configuration on each node
  • Start all nodes, update database configuration on each node, enable application services
  • Enable application services, start all nodes, update database configuration on each node.

Answer : Start all nodes, enable application services, update database configuration on each node

The Informatica Administrator can configure an automatic email alert to notify failure of which types of objects? Assume that service process failover is in effect.


Options are :

  • Nodes and any domain service.
  • Nodes, any domain service, workflows
  • Nodes, integration services, repository services.
  • Nodes, integration services, repository services, workflows

Answer : Nodes, integration services, repository services.

To run a pmcmd command line command and then confirm the command has run successfully, which method would be used?


Options are :

  • Read the return code visually or in a shell script or batch file
  • Run the command from the informatica Administrator and check the status after the command has completed.
  • Create and configure an Email alert within the workflow Monitor.
  • Check the status of the command in the Workflow Monitor.

Answer : Check the status of the command in the Workflow Monitor.

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


Options are :

  • You must have write permissions in both the origin folder and the destination folder.
  • The Repository service will lock the repository database until the objects have been copied.
  • It is best practice to export the objects as XML prior to performing the copy operation
  • . You can copy an object even though it has been checked out or has a write-intent lock.

Answer : The Repository service will lock the repository database until the objects have been copied.

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


Options are :

  • Only one node is active and it is the master gateway node
  • . Both nodes are worker nodes at the same time.
  • Both nodes are gateway nodes at the same time, with Informatica automatically deciding which is the master gateway when the domain is started
  • One node or a master gateway, the other is a worker

Answer : Both nodes are gateway nodes at the same time, with Informatica automatically deciding which is the master gateway when the domain is started

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


Options are :

  • All of the service processes and their statuses
  • All of the service processes running on the node that are disabled.
  • All of the workflows running on the node.
  • All of the service processes running on the node that are enabled

Answer : All of the service processes running on the node that are enabled

What is required for customers to access and use IDQ Accelerator content?


Options are :

  • .IDQ customers simply need to request an IPS resource to download and install the content
  • .No additional steps are required. All Accelerator content is provided with the basic IDQ license
  • .Accelerator content is available only with a PowerCenter license
  • .Customers must license each Accelerator pack individually to download and use the content

Answer : .No additional steps are required. All Accelerator content is provided with the basic IDQ license

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


Options are :

  • One
  • One or more
  • Zero or more
  • One if the integration service is not part of a grid, more than one if It is part of a grid

Answer : One

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


Options are :

  • Users, Groups, Roles
  • Users, Groups, Privileges
  • Users, Groups, Folders
  • Users, Groups. Permissions

Answer : Users, Groups, Roles

What is the difference between the Default Administrator and the Domain Administrator users'?


Options are :

  • The Default Administrator is automatically created during installation. Domain Administrators must be created manually
  • The Domain Administrator is automatically created for all domains, and the Default Administrator must be created during the domain installation process.
  • Both users are automatically created in all domains, but the Domain Administrator is used to maintain only domain objects, while the Default Administrator can be used to manage any Informatica object including clients
  • The Default Administrator is user supplied during the installation process, and the Domain Administrator Is the built-in super user for everyday domain administration

Answer : The Default Administrator is automatically created during installation. Domain Administrators must be created manually

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.


Options are :

  • No. For a new repository service, the database schema must be empty.
  • Yes. The user must select the creation option, "Do not create new content.
  • No. When the new service is created, existing tables will be automatically dropped.
  • Yes. The tables and objects will be preserved by default.

Answer : Yes. The tables and objects will be preserved by default.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions