Informatica Admin Quiz

1
____________ in Informatica is logical representation of a machine

1. Node
2. Domain
3. service
4. service process

Show Answer

 
2
DTM stands for

1. Data transport manager
2. Data Transformation manager
3. Data Manager
4. Data Translation manager

Show Answer

 
3
Resilience time in mentioned in

1. Hours
2. Minutes
3. Seconds
4. Milliseconds

Show Answer

 
4
A service which is responsible for executing the workflows?

1. Repository service
2. Integration service
3. DTM process
4. none of the Above

Show Answer

 
5
A service which is responsible for managing the Metadata?

1. Repository service
2. Integration service
3. DTM process
4. none of the Above

Show Answer

 
6
An integration service can be created without the repository service?

1. TRUE
2. False

Show Answer

 
7
_____________is a repository whose objects are accessible within that repository only.

1. Local Repository
2. Global repository
3. Both of the above
4. none of the Above

Show Answer

 
8
A Local repository cannot be converted to Global after the creation

1. False
2. True

Show Answer

 
9
which command is used to start the workflow from a command line?

1. pmrep
2. pmwork
3. pmcmd
4. none of the Above

Show Answer

10
which command is used to connect to the repository from a command line?

1. pmrep
2. pmwork
3. pmcmd
4. none of the Above

Show Answer

 
11
To make any changes to the repository service, it must be running in

1. Normal
2. Exclusive
3. can run in any mode
4. no changes can be made to repository after it is created

Show Answer

 
12
A mapping created in __________ repository can be accessed to all repositories in the domain.

1. Local Repository
2. Global repository
3. Both of the above
4. none of the Above

Show Answer

 
13
What are the ways to assign permission on the Administration Console?

1. Assign permission on a selected object to multiple users
2. Assign multiple objects permissions to one user
3. Both (a) and (b)
4. None of the above

Show Answer

 
14
On which operating systems  Informatica can be Installed ?

1. AIX
2. Solaris
3. HP Unix
4. All of the above

Show Answer

 
15
If a user needs to copy objects to and from a folder, what minimum permissions the user must have on the folder

1. READ
2. WRITE
3. READ, WRITE
4. Folder owner or in the owner’s group

Show Answer

 
16
The kinds of information that are stored in the repository are

1. Repository configuration details
2. Mappings
3. Workflows
4. All of the above

Show Answer

 
17
Administration Console is used for

1. administering the PowerCenter domain and PowerCenter security
2. administering the PowerCenter, source and target databases
3. administering the source and target databases
4. None of the above

Show Answer

 
18
Which of the PowerCenter applications is browser-based?

1. Repository Manager
2. Workflow Monitor
3. Administration Console
4. Workflow Manager.

Show Answer

 
19
What information does a powerCenter Client application need in order to connect to a repository?

1. Repository name , valid user name ,password, and domain name.
2. Repository name , valid user name ,password, and repository service name.
3. Repository name , repository service name.
4. Repository name, database user name , and password..

Show Answer

20
Which PowerCenter applications are used for creating and administrating folders?

1. Administration Console and Workflow manager
2. Repository Manager and Administration Console
3. Workflow Manager and Workflow Monitor
4. Designer and Workflow Manager.

Show Answer

 
21
What does a PowerCenter domain require, at a minimum?

1. Repository Service and Repository Database.
2. Repository Service and Administration Console.
3. Repository Service and Client application.
4. Repository Service and Integration Service

Show Answer

 
22
The Integration Service creates the cache files by default in the

1. $PMCacheFileDir
2. $PMCacheDir
3. $CacheFileDir
4. $CacheDir

Show Answer

 
23
Folder object need to be created in

1. Repository Manager
2. Designer
3. Workflow Manager
4. workflow Monitor

Show Answer

 
24
Resiliency means

1. Fail Over
2. Primary
3. Backup
4. Keep the connection till specified time active

Show Answer

 
25
_____________ services are created and configured by Administrator in Admin console

1. Core services
2. Application services
3. Both of the above
4. none of the Above

Show Answer

 
26
integration service is an example of ________________

1. Core services
2. Application services
3. Log Service
4. none of the Above

Show Answer

 
27
After the license key is added, the integration and repository services need to be created again?

1. TRUE
2. False

Show Answer

 
28
which among the following is a mandatory service in informatica?

1. Web service hub
2. SAP BW service
3. Repository Service
4. Reporting Service

Show Answer

 
29
Exporting an object in the Repository manager , creates _____ file by default

1. .BAK
2. .XML
3. .REP
4. .BAT

Show Answer

 
30
Native user is a user created in _____________________

1. Admin console
2. operating system
3. LDAP server
4. none of the Above

Show Answer