IPC Repository Management

Question 1

What is the Informatica PowerCenter Repository?

Accepted Answer

A database that stores all metadata about mapping objects, workflows, and sessions

Answer

A flat file system that stores transformation logic

Answer

An in-memory cache that stores runtime execution data

Answer

A web service that manages user authentication

Question 2

Which PowerCenter service manages the repository and provides access to repository metadata for clients?

Accepted Answer

Repository Service

Answer

Integration Service

Answer

Web Services Hub

Answer

Reporting Service

Question 3

What is the purpose of the Global Repository in a multi-repository PowerCenter environment?

Accepted Answer

To share objects with connected local repositories via shortcuts

Answer

To store audit logs for all PowerCenter operations

Answer

To manage user authentication across all repositories

Answer

To serve as the primary execution engine for all workflows

Question 4

In PowerCenter repository management, what is a 'shortcut'?

Accepted Answer

A reference to a shared object in the Global Repository from a Local Repository

Answer

A keyboard shortcut for accessing repository objects

Answer

A quick-connect alias for database connection strings

Answer

An abbreviated version of a mapping name

Question 5

Which of the following database systems is NOT supported as a PowerCenter Repository database?

Accepted Answer

MongoDB

Answer

Oracle

Answer

Microsoft SQL Server

Answer

IBM DB2

Question 6

What occurs when the Repository Service is placed into exclusive mode?

Accepted Answer

Only administrators can connect, blocking all regular user sessions for maintenance

Answer

Multiple users can access the repository simultaneously with elevated privileges

Answer

The repository replicates data to a standby server in real time

Answer

The repository automatically backs up all objects to the file system

Question 7

Which repository type in a PowerCenter domain acts as the central hub that shares reusable objects with other repositories?

Accepted Answer

Global Repository

Answer

Local Repository

Answer

Standalone Repository

Answer

Development Repository