Ab Initio ETL | Testing | Mock Test

1
__ is a optional part of a transform function that provides storage for temporary values
a. Transform function
b. Business rule
c. Variable
d. Statement
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Variable [/bg_collapse]
2
__ is a part of a transform function that describes how you manipulate one field of your output data
a. Transform function
b. Business rule
c. Variable
d. Rollup Component
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Business rule[/bg_collapse]
3
__ is a set of rules that compute output values from input values
a. Transform function
b. Business rule
c. Variable
d. Database Exec
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Transform function[/bg_collapse]
4
___ is used to support component parallelism
a. Replicate component
b. Sort Component
c. Dedup Component
d. Dynamic Parameter
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Replicate component[/bg_collapse]
5
______ file has the information required for Ab Initio to connect to the database to extract or load tables or views.
a. Database Configuration
b. Database Logon
c. Database Param
d. Partition By Percentage
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Database Configuration[/bg_collapse]
6
______ is a Ab Initio Graph Parameter which need not be initialized with a value at the time of Declaration.
a. Initial Parameter
b. Local Parameter
c. Global Parameter
d. Left Outer Join
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Global Parameter[/bg_collapse]
7
______ component partitions the records in Sequential Way.
a. Partition By Range
b. Partition By Round Robin
c. Partition By Key
d. Interleave
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Partition By Round Robin[/bg_collapse]
8
__allows you to set the record-required parameter for each port individually
a. Inner join
b. Outer join
c. Explicit
d. Interleave
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Explicit [/bg_collapse]
9
__component collects inputs from multiple partitions in an arbitrary manner, and produces a single output flow, does not maintain sort order
a. Concatenate
b. Gather
c. Merge
d. Interleave
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Gather [/bg_collapse]
10
__component collects inputs from multiple sorted partitions and maintains the sort order
a. Concatenate
b. Gather
c. Merge
d. Interleave
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Merge [/bg_collapse]