Dovetail
Informatica Dovetail 120 Questions
- 1.
In a short description, the data warehouse is a collection of data that is primarily used for
- A.
Organizational Decision Making
- B.
Transaction Processing
- C.
Temporary Data Storage
- D.
Query Optimization
- E.
Application Testing
Correct Answer
A. Organizational Decision Making -
- 2.
Data Marts have specific business related purposes
- A.
False
- B.
0
- C.
True
- D.
Only at sometimes
- E.
I don't know
Correct Answer
C. True -
- 3.
The database designed for queries on transactional data is known as
- A.
ODS
- B.
OLAP
- C.
OLTP
- D.
OLCP
- E.
DSS
Correct Answer
A. ODS -
- 4.
This is a quantifiable value such amount of sales, budget or revenue
- A.
Dimension
- B.
Database
- C.
Datamart
- D.
Fact
- E.
Data Warehouse
Correct Answer
D. Fact -
- 5.
The center of Star schema consists of one or more
- A.
Fact Tables
- B.
Dimension Tables
- C.
Indexes
- D.
Views
- E.
Synonyms
Correct Answer
A. Fact Tables -
- 6.
The process of pulling data from various hetrogeneous source systems is known as
- A.
Loading
- B.
Transforming
- C.
Cleansing
- D.
Refreshing
- E.
Extraction
Correct Answer
E. Extraction -
- 7.
Change data capture is a part of
- A.
Incremental Extraction
- B.
Full Extraction
- C.
Online Extraction
- D.
Offline Extraction
- E.
None
Correct Answer
A. Incremental Extraction -
- 8.
Which is used to store data and perform data cleansing,merging before loading into Datawarehousing
- A.
ODS
- B.
OLTP
- C.
Staging
- D.
ODS & OLTP
- E.
None
Correct Answer
C. Staging -
- 9.
The two types of loading available in DWH are
- A.
Full Load
- B.
Direct Load
- C.
Incremental Load
- D.
Option 1 & Option 3
- E.
Option 1, Option 2 & Option 3
Correct Answer
D. Option 1 & Option 3 -
- 10.
The process of converting and summarizing operational data into a consistent, business oriented format
- A.
Transformation
- B.
Extraction
- C.
Loading
- D.
None
- E.
Option 1, Option 2 & Option 3
Correct Answer
A. Transformation -
- 11.
The latest Informatica suite is compatible of
- A.
8 Bit
- B.
16 Bit
- C.
32 Bit
- D.
64 Bit
- E.
128 Bit
Correct Answer
D. 64 Bit -
- 12.
Is both Informatica PowerCenter and PowerMart are same
- A.
Depends upon the User
- B.
NO
- C.
YES
- D.
Only at some times
- E.
I don't know
Correct Answer
D. Only at some times -
- 13.
Flat file lookup is one newly added feature in Informatica PowerCenter 7.1 version
- A.
Depends upon the User
- B.
NO
- C.
I don't know
- D.
Only at some times
- E.
YES
Correct Answer
E. YES -
- 14.
How many important client components available in Informatica
- A.
5
- B.
3
- C.
0
- D.
No client tools
- E.
I don't know
Correct Answer
A. 5 -
- 15.
Which component is used for New server registration in informatica
- A.
Designer
- B.
Workflow Manager
- C.
Repository Manager
- D.
Option 2 & 3
- E.
Repository administration console
Correct Answer
E. Repository administration console -
- 16.
Which Component of informatica is used to configure connection details
- A.
Workflow Monitor
- B.
Mapping Designer
- C.
Workflow Manager
- D.
Repository Manager
- E.
Worklet Designer
Correct Answer
C. Workflow Manager -
- 17.
Which tool is used for users,user groups and privileges
- A.
Designer
- B.
Workflow Manager
- C.
Repository Manager
- D.
Option 2&3
- E.
None
Correct Answer
C. Repository Manager -
- 18.
Where is the actual business rules will be implemented
- A.
Source qualifier
- B.
Transformation Developer
- C.
Workflow Designer
- D.
Mapping Designer
- E.
Warehouse Designer
Correct Answer
D. Mapping Designer -
- 19.
Is it possible to generate a table in relational database using Informatica
- A.
Yes
- B.
No
- C.
Sometimes
- D.
May be possible
- E.
None
Correct Answer
A. Yes -
- 20.
Which Component of Informatica is used to see the performance of the workflow while running
- A.
Workflow Monitor
- B.
Mapping Designer
- C.
Workflow Manager
- D.
Repository Manager
- E.
Worklet Designer
Correct Answer
A. Workflow Monitor -
- 21.
The Repository Manager connects to the repository database through the Repository Server.
- A.
Depends upon the User
- B.
FALSE
- C.
TRUE
- D.
Only at some times
- E.
I don't know
Correct Answer
C. TRUE -
- 22.
In the Informatica Repository, where is the meta data getting stored?
- A.
Synonyms
- B.
Dimension tables
- C.
Indexes
- D.
Database tables
Correct Answer
D. Database tables -
- 23.
How the repository server communicates with the repository database
- A.
Through native drivers
- B.
Third party softwares
- C.
LAN Drivers
- D.
Logical Paths
Correct Answer
A. Through native drivers -
- 24.
The Repository Server can manage a repository residing on a database on a different machine on the network
- A.
Depends upon the User
- B.
False
- C.
TRUE
- D.
Only at some times
Correct Answer
C. TRUE -
- 25.
Using the repository manager, the entire repository can be backed up in the format of
- A.
Text file
- B.
Zip File
- C.
XML File
- D.
Binary File
Correct Answer
D. Binary File -
- 26.
How the repository server create and update the repository tables
- A.
Through repository agent process
- B.
Through native drivers
- C.
Through LAN Drivers
- D.
Through PSTN Lines
Correct Answer
A. Through repository agent process -
- 27.
When you connecting to the repository, you need to mention the
- A.
Your local machine's IP
- B.
Your Project Name
- C.
Host name and Port no
- D.
Your Mobile no
Correct Answer
C. Host name and Port no -
- 28.
What is the default repository server connection timeout limit
- A.
60 Secs
- B.
30 Secs
- C.
15 Secs
- D.
120 Secs
Correct Answer
A. 60 Secs -
- 29.
For executing a workflow, the PowerCenter server uses the
- A.
Designer
- B.
DLM Process
- C.
DTM Process
- D.
DLF Process
Correct Answer
C. DTM Process -
- 30.
The primary PowerCenter server process is known as
- A.
Workflow Manager
- B.
Load Manager
- C.
Workflow Monitor
- D.
Designer
Correct Answer
B. Load Manager -
- 31.
What are the servers available in Informatica
- A.
Informatica Server
- B.
Workflow Server
- C.
Informatica repository Server
- D.
Option 1 & Option 3
- E.
Option 1 & Option 2
Correct Answer
D. Option 1 & Option 3 -
- 32.
Is it necessary to run the Informatica server before accessing Repository
- A.
Yes
- B.
No
- C.
May be true
- D.
Sometimes
- E.
None
Correct Answer
B. No -
- 33.
You can create and maintain folders in the
- A.
Repository Manager
- B.
Designer
- C.
Workflow Manager
- D.
Workflow Monitor
- E.
Repository Server
Correct Answer
A. Repository Manager -
- 34.
If you want to use the same object in several projects, you need to put it in a shared folder
- A.
Depends upon the User
- B.
False
- C.
True
- D.
Only at some times
Correct Answer
C. True -
- 35.
How many permission types are available for folders
- A.
1
- B.
3
- C.
5
- D.
7
- E.
9
Correct Answer
B. 3 -
- 36.
Which privilege do you need to execute all tasks across all folders in the repository, and can perform any tasks
- A.
Administrator
- B.
Read
- C.
Write
- D.
Super User
- E.
Execute
Correct Answer
D. Super User -
- 37.
For comparing two folders, what is the mandatory permission a user should have.
- A.
Read
- B.
Write
- C.
Execute
- D.
Super User
- E.
Administrator
Correct Answer
A. Read -
- 38.
Which option is need to be checked for creating shortcuts for folders
- A.
Create Shortcuts
- B.
Allow shortcut
- C.
Shortcuts
- D.
None
- E.
Option 1 & Option 2
Correct Answer
B. Allow shortcut -
- 39.
Pmcmd is a program that you can use to communicate with
- A.
Designer
- B.
PowerCenter Server
- C.
Workflow Manager
- D.
Workflow Monitor
- E.
Repository Manager
Correct Answer
B. PowerCenter Server -
- 40.
How many modes are available for using pmcmd
- A.
5
- B.
4
- C.
3
- D.
2(interactive and commandline)
- E.
0
Correct Answer
D. 2(interactive and commandline) -
- 41.
While using pmcmd in command line mode, each command must include the connection information of the
- A.
PowerCenter Server
- B.
Repository Manager
- C.
Workflow Manager
- D.
Workflow Monitor
- E.
Designer
Correct Answer
A. PowerCenter Server -
- 42.
What is the return code for a successful pmcmd command execution
- A.
1(not available--connection failed)
- B.
0(successful)
- C.
3(error)
- D.
5(internal pmcmd error)
- E.
7(invalid user)
Correct Answer
B. 0(successful) -
- 43.
What is the pmcmd command for instructing the server to execute the subsequent commands in the wait mode.
- A.
Setfolder
- B.
Usefolder
- C.
Setnowait
- D.
Setwait
- E.
Showsettings
Correct Answer
D. Setwait -
- 44.
In which mode of pmcmd, the username, password and server information are required for each command
- A.
Interactive mode
- B.
Commandline mode
- C.
User Mode
- D.
Server mode
- E.
Wait Mode
Correct Answer
B. Commandline mode -
- 45.
Which mode is used for handling the sessions and workflows
- A.
Interactive mode
- B.
Commandline mode
- C.
User Mode
- D.
Server mode
- E.
Wait Mode
Correct Answer
A. Interactive mode -
- 46.
What will be returned if the username and password are incorrect in a command
- A.
0
- B.
Zero Return Codes
- C.
2
- D.
Non Zero return Codes/7
- E.
1
Correct Answer
D. Non Zero return Codes/7 -
- 47.
Which mode allows writing scripts for scheduling the workflows
- A.
Interactive mode
- B.
Commandline mode
- C.
User Mode
- D.
Server mode
- E.
Wait Mode
Correct Answer
B. Commandline mode -
- 48.
Which window in designer is used to access the repositories.
- A.
Output
- B.
Workspace
- C.
Navigation
- D.
Mapping designer
Correct Answer
C. Navigation -
- 49.
How many tools are available in desginer
- A.
4
- B.
3
- C.
2
- D.
6
- E.
5
Correct Answer
E. 5 -
- 50.
Is it possible to create source and target definition manually
- A.
No
- B.
Yes
- C.
Sometimes
- D.
Rarely
Correct Answer
B. Yes -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Sep 22, 2016Quiz Edited by
ProProfs Editorial Team -
Sep 20, 2016Quiz Created by
Niksshukla12
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes
Back to top