Abinitio Fundamental Quiz - Part 1
(230).jpg "Abinitio Fundamental Quiz - Part 1")
This quiz (Part1) tests our basic understanding and knowledge in AbInitio. You may take AbInitio Fundamental Quiz - Part 2 also. Good Luck.
- 1.What are the different types of parallelism in AbInitio?
- A.
Process parallelism, Data parallelism, Component parallelism
- B.
Phase parallelism, Component parallelism, Pipeline parallelism
- C.
Component parallelism, Data parallelism, Pipeline parallelism
- D.
None of the above
- 2.Replicate component supports which type of Parallelism?
- A.
Data Parallelism
- B.
Component Parallelism
- C.
Pipeline Parellelism
- D.
All of the above
- 3.What is component parallelism?
- A.
A graph with multiple processes running simultaneously on separate data uses component parallelism.
- B.
A graph that deals with data divided into segments and operates on each segment simultaneously uses component parallelism
- C.
A graph with multiple phases running simultaneously on separate data uses component parallelism.
- D.
A graph with multiple components running simultaneously on the same data
- 4.What is the notation to specify the URL of a layout?
- A.
Hostname/path/
- B.
Protocol://hostname/path
- C.
Path
- D.
None of the above
- 5.A configuration file contains the following information:
- A.
The name and version number of the database to which you want to connect
- B.
The name of the computer on which the database instance or server to which you want to connect runs, or on which the database remote access software is installed
- C.
The name of the database instance, server, or provider to which you want to connect
- D.
You generate a configuration file by using the Properties dialog box for one of the Database components
- E.
All of the above
- 6.For which join type the record-required parameter is used?
- A.
Inner join
- B.
Outer join
- C.
Explicit join
- D.
All of the above
- 7.Which of the following components need a sorted input?
- A.
Merge
- B.
Interleave
- C.
Gather
- D.
All of the above
- 8.How is reject-threshold calculated using limit and ramp?
- A.
Ramp * limit + number of records processed so far
- B.
Ramp + (limit * number of records processed so far)
- C.
Limit + (ramp * number of records processed so far)
- D.
Limit/ramp + number of records processed so far
- 9.What is the maximum number of input ports a join components can have?
- A.
Only one
- B.
2
- C.
4
- D.
20
- 10.What does the max-core parameter refer to?
- A.
The maximum memory the component can use
- B.
The maximum CPU utilization the component can use
- C.
The maximum time limit the component can use
- D.
The maximum number of rejects the component can alllow
- 11.Select the correct/true statement from below:
- A.
The transform() parameter of a component cannot be used to specify the select criteria for the records
- B.
Trash component can be used to capture and view the Log Information
- C.
Start scripts manage tasks such as renaming output files
- D.
Gather component is used to append records from multiple flows arbitrarily
- 12.What does layout of a component mean?
- A.
The place where the component works
- B.
The depth of parallelism
- C.
Number of partitions
- D.
All of the above
- 13.Which component produces intermediate summary records while aggregating?
- A.
Roll up
- B.
Scan
- C.
Aggregate
- D.
All of the above
- 14.Which component saves the status information among the following components?
- A.
Phases
- B.
Check points
- C.
Phase breaks
- D.
Commit
- 15.Which component gives sorted output?
- A.
Merge
- B.
Sort
- C.
Rollup
- D.
All of the above
- 16.Which of the following has got a deselect port?
- A.
Filter
- B.
Join
- C.
Sort
- D.
Reformat
- 17.Which component among the following is the most efficient?
- A.
Concatenate
- B.
Interleave
- C.
Gather
- D.
Merge
- 18.What does a redefine component do?
- A.
It changes the value of the data records according to expression
- B.
It renames the fields in record format and changes its value according to expression
- C.
It renames the fields in the record format without changing its value
- D.
It copies the data records from its input to output record format and changes its values accourding to key expression.
- 19.Why a gather component is used?
- A.
To reduce data parallelism
- B.
To reduce component parallelism
- C.
To reduce both data parallelism and component parallelism
- D.
None of the above
- 20.What is the maximum value allowed for max-core?
- A.
2³¹-1
- B.
2²¹-1
- C.
2¹¹-1
- D.
No limit
- 21.Using which component we can specify the rate of data movement from input to output?
- A.
Throttle
- B.
Fuse
- C.
Scan
- D.
Sample
- 22.Which of the following component will you use to parse programatically?
- A.
Run program
- B.
Readraw
- C.
Reformat
- D.
Run sql
- 23.Which parameter specifies the components tolerence for reject events?
- A.
Reject port
- B.
Reject-threshold parameter
- C.
Max-core parameter
- D.
Log-reject parameter
- 24.How can an explicit join perform inner join?
- A.
Record required parameter for both ports are set to false
- B.
Record required parameter for both ports are set to true
- C.
Record required parameter for port0 is set to true and other port is set to false
- D.
Record required parameter for port0 is set to false and other port is set to true
- 25.Which one of the following is a miscellaneous component?
- A.
Broadcast
- B.
Merge
- C.
Trash
- D.
Denormalize
Questions: 50 | Attempts: 4465 | Last updated: Nov 19, 2020
-
Sample QuestionReplicate supports which parallelism?
Questions: 15 | Attempts: 17119 | Last updated: Jul 20, 2021
-
Sample QuestionI'm loving it.
Questions: 68 | Attempts: 6580 | Last updated: Jun 4, 2021
-
Sample QuestionA national company becomes an MNC when it
Back to top