Ab Initio Quiz

Ab Initio Intermediate  Quiz




1) Which other component can be used to find the First/Last record from a record group other than Dedup Sorted?

  1. Denormalize_sorted
  2. Rollup
  3. Read Multiple Files
  4. Fuse

Answer : B

 
 
2) Read Multiple files Randomly reads from a list of input files

  1. True
  2. FALSE

Answer : B

 
 
3) Self sized vectors can be initialized only using loop expression

  1. True
  2. FALSE

Answer : A

 
 
4) Round robin partition is a partitioning technique to Non -uniformly distribute the data to each of the destination data partitions.

  1. True
  2. FALSE

Answer : B

 
 
5) m_db_test is used to test a dbc file from the command prompt

  1. True
  2. FALSE

Answer : A

 
 
6) How many types of parallelism exist in Ab initio

  1. 3
  2. 2
  3. 1
  4. None of the above

Answer : A

 
 
7) Which component is used to join two files with different Layout

  1. Join
  2. join with DB
  3. Fuse
  4. None of the above

Answer : C

 
 
8) How can one reference a value in one component that was created in a different component

  1. Pass the value in the data stream
  2. Write the value to a lookup file and look up the value in the downstream component.
  3. Access the needed value using a script that is the value of a graph parameter you create
  4. All of the above

Answer : D

 
 
9) Which component does not work in pipeline parallelism

  1. Reformat
  2. Rollup
  3. Sort
  4. Both b & c

Answer : D

 
 
10) Defining of phases in AB initio mean

  1. To provide the means to restart a failed graph from some intermediate state
  2. To limit the number of simultaneous processes by breaking up the graph
  3. Performance tuning by managing resources
  4. Both b & c

Answer : D




 
11) Which of the following typecast converts x to a type double and divides by 100

  1. Double(x/100)
  2. x/100 (double)
  3. ((double) x) / 100
  4. Both b and c

Answer : C

 
 
12) From an input dataset of say 200 record what component to use to get records between say 80-125

  1. scan and filter by component
  2. m_dump
  3. next_in_sequence() function and filter by
  4. All of the above

Answer : D

 
 
13) Dividing a single flow of records(data) into multiple flows is known as

  1. partitioning
  2. re-partitioning
  3. departitioning
  4. None of the above

Answer : A

 
 
14) Dividing a x-way flows of records(data) into y-way flows is known as

  1. departitioning
  2. partitioning
  3. re-partitioning
  4. None of the above

Answer : C

 
 
15) Which of the following is true

  1. Replicate is for non-partition
  2. broadcast – partition
  3. both make copy of records
  4. All of the above

Answer : D

 
 
16) ab_report is used to

  1. get statistics
  2. get report format
  3. All of the above
  4. None of the above

Answer : A

 
 
17) Can resource in internet can be given as a layout

  1. no
  2. yes
  3. resource must be local
  4. None of the above

Answer : B

 
 
18) What are the different connection methods

  1. ssh
  2. telnet
  3. rexec
  4. All of the above

Answer : D

 
 
19) Which is true about lookup files

  1. increases I/O calls
  2. lookup is faster only if file is small enough to store in memory
  3. join component is better
  4. than large lookup files
  5. None of the above

Answer : B

 
 
20) Which of the following is true with regards to access privileges of dataset components

  1. access privileges cannot be set to dataset components
  2. access privileges can be set to dataset components
  3. there is no access privilege for dataset components

Answer : B




 
21) how do you set implicitly phases

  1. check the phase checkbox
  2. uncheck the phase checkbox
  3. use intermediate files
  4. All of the above

Answer : C

 
 
22) Which command is used to test dml expressions

  1. m_dump
  2. m_eval
  3. All of the above
  4. None of the above

Answer : B

 
 
23) How to generate table dml from command line

  1. m_eval
  2. m_db gendml
  3. gendml
  4. None of the above

Answer : B

 
 
24) Which command is used to cleans up files left over from unsuccessfully executed graphs and manually recovered graphs.

  1. m_rollback
  2. m_cleanup
  3. None of the above
  4. All of the above

Answer : A

 
 
25) Which command is used to remove watcher files

  1. rm
  2. m_rm
  3. m_cleanup
  4. None of the above

Answer : B

 
 
26) What are the Dedup criteria?

  1. Unique only
  2. First
  3. Last
  4. All of the above

Answer : D

 
 
27) A configuration file contains the following information:
 

  1. The name and version number of the database to which you want to connect.
  2. 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.
  3. The name of the database instance, server, or provider to which you want to connect.
  4. All of the above

Answer : D

 
 
28) For which join type the record-required parameter is used

  1. inner join
  2. outer join
  3. explicit join
  4. All of the above

Answer : C

 
 
29) How is reject-threshold calculated using limit and ramp

  1. ramp * limit + number of records processed so far
  2. ramp + (limit * number of records processed so far)
  3. limit + (ramp * number of records processed so far)
  4. limit/ramp + number of records processed so far

Answer : C

 
 
30) Which component produces intermediate summary records while aggregating

  1. Roll up
  2. Scan
  3. Aggregate
  4. All of the above

Answer : B




 
31) Using which component can we specify the rate of data movement from input to output

  1. Throttle
  2. Fuse
  3. Scan
  4. Sample

Answer : A

 
 
32) Which of the following component will you use to parse programmatically

  1. run program
  2. read raw
  3. reformat
  4. run sql

Answer : B

 
 
33) Which of the following has got a deselect port

  1. Filter by expression
  2. Join
  3. sort
  4. reformat

Answer : A

 
 
34) What does a redefine component do?

  1. It changes the value of the data records according to expression
  2. It renames the fields in record format and changes its value according to expression
  3. It renames the fields in the record format without changing its value
  4. It copies the data records from its input to output record format and changes its values according to key expression.

Answer : C

 
 
35) which one of the following is a miscellaneous component

  1. broadcast
  2. merge
  3. trash
  4. denormalize

Answer : C

 
 
36) What is the maximum value allowed for max-core

  1. ans)231-1
  2. 221-1
  3. 211-1
  4. no limit

Answer : A

 
 
37) In which way conflicts arise during check in?

  1. The Graph In Sandbox Not Latest
  2. The Graph Check In Happens In Different Project
  3. Both The Above
  4. Conflicts Doesn’t Arise

Answer : C

 
 
38) How can an explicit join perform inner join?

  1. Record Required Parameter For Both Ports Are Set To False
  2. Record Required Parameter For Both Ports Are Set To True
  3. Record Required Parameter For Port 0 Is True And For Port 1 Is False
  4. Record Required Parameter For Port 0 Is False And For Port 1 Is True

Answer : B

 
 
39) Which of the following is incorrect

  1. Gzip reduces the volume of data in flow
  2. Compress reduces the volume of data in flow in UNIX platform
  3. Gunzip reduces the volume of data in flow
  4. Gunzip reveses the effect of compress.

Answer : C

 
 
40) Which component is more powerful and easier to use than the aggregate component

  1. Rollup
  2. Join
  3. Sort within groups
  4. None of the above

Answer : A




 
41) What all components require sorted input?

  1. Rollup
  2. Join
  3. Dedup Sorted
  4. All of the above

Answer : D

 
 
42) The component stops the execution of the graph if the number of reject events exceeds the result of the formula:

  1. limit + (ramp * number_of_records_processed_so_far)
  2. limit * (ramp +number_of_records_processed_so_far)
  3. limit+ramp
  4. limit*ramp

Answer : A

 
 
43) What does a watcher do?

  1. Eliminating To Do Cues
  2. Turn on the debugging mode
  3. Displays flow patterns
  4. Edit Key specifiers

Answer : B

 
 
44) Denormalize sorted

  1. requires grouped input
  2. consolidates groups of related data records into a single output record
  3. generates a vector field for each group and optionally computes the summary field in the output record
  4. All of the above

Answer : D

 
 
45) What is a summary file?

  1. A file containing information about flows,components ,phases during the most recent run.
  2. A file containing the summary of the graph run
  3. All of these
  4. none of these

Answer : A

 
 
46) What is true about a multifile?

  1. it’s a file which is divided into so many partitions and stored in the same disk
  2. a multifile contains one multifile and 2 data partitions
  3. a multifile contains one control file and one or many data partitions
  4. roundrobin partitioning is not used to partition data in multifle

Answer : C

 
 
47) What does a Broadcast component do?

  1. It arbitrarily combines all the data records it receives into a single flow and writes a copy of that flow to each of its output flow partitions.
  2. It appends multiple flow partitions of data records one after the other.
  3. It echoes the final status of the graph run
  4. none of these

Answer : A

 
 
48) Component used to create surrogate keys?

  1. Assign Key Component
  2. Fuse
  3. Run Program
  4. Sample

Answer : A

 
 
49) The parameter used to specify the path containing sas esecutables

  1. AB_SASHOME
  2. AB_SAS_CONTROL_FILE
  3. AB_SAS_AUTOEXEC
  4. None of the above

Answer : A

 
 
50) All packages has the extension

  1. .xfr
  2. .pkg
  3. .mpc
  4. .mdc

Answer : A




 
51) What is false about api mode??

  1. ablocal_expr parameter is available only when dbms_interface is set to api.
  2. The expression is evaluated once per partition
  3. cannot be used for fanout specific components
  4. first and third

Answer : C

 
 
52) How to change a Graph so that CPU consumption is less

  1. Use partitions
  2. If transformation has many local variables make it global
  3. Reduce the Degree of parallelism
  4. 3rd and 4rth

Answer : C

 
 
53) If Ab-initio is installed in aunix environment, then the .mp files is converted internally to

  1. .ksh file
  2. .xfr file
  3. .dml file
  4. .sh

Answer : A

 
 
54) which is the default name of a component parameter when it is exported

  1. parameter name.component name
  2. component name_parameter name
  3. parameter name_component name
  4. component name.parameter name

Answer : B

 
 
55) which type of sql statement activity should be most avoided when parallel unload from table is performed

  1. group by
  2. joins
  3. both A and B
  4. none

Answer : A

 
 
56) when using a macro which of the following relating to that macro become runtime parameters

  1. components
  2. flows
  3. parameters
  4. all the above

Answer : D

 
 
57) The value of the AB_MAX_CORE parameter should be set based on

  1. memory usage per partition
  2. memory usage over all partitions
  3. disk space usage for each partition
  4. disk space usage over all partitions

Answer : B

 
 
58) deadlocks occur because of

  1. no automatic flow buffering
  2. partitioning and departioning occur in the same phase
  3. both A and B
  4. none

Answer : C

 
 
59) string_concat(‘string’,NULL) in the expression editor will result in

  1. string
  2. NULL
  3. compile time error
  4. run time error

Answer : C

 
 
60) which of these components has the number of partition as a required parameter

  1. partition by range
  2. recirculate
  3. assign keys
  4. normalize

Answer : C




 
61) which of the following can be a state of a file in the sandbox in relation to its datastore

  1. unresolved
  2. stale
  3. current
  4. all the above

Answer : D

 
 
62) A file in your sandbox is in the conflict state and the conflict has been deferred(state-unresolved modified) .Now the file version in the data store has changed again because someone else has checked in.The state of your file is unresolved (conflict).No

  1. conflict
  2. unresolved
  3. stale
  4. current

Answer : C

 
 
63) In which type of predefined sequence specifier are punctuation characters ignored

  1. index
  2. phonebook
  3. machine
  4. none

Answer : B

 
 
64) for which of the following does dml allow four bytes for storage

  1. packed decimal(8,3,unsigned)
  2. packed decimal(5)
  3. packed decimal(4,stripped)
  4. packed decimal(6,unsigned)

Answer : A

 
 
65) which keyword should be used in order to make a custom type sequence specifier treat a group of characters as equivalent to each other

  1. foldcase
  2. ignore
  3. fold
  4. ignorecase

Answer : C

 
 
66) Subgraph is used when

  1. a single executable has to be created
  2. number of components and their arrangement are constant from one run of the graph to other
  3. components,number of components and their arrangement differ from one run of the graph to other
  4. none

Answer : B

 
 
67) Checkpoint

  1. is a saving point so job can be restarted from that point in case of crash
  2. is a saving point so job can be restarted from last processed record in case of crash
  3. is a saving point so job can be restarted from beginning in case of crash
  4. None of the above

Answer : A

 
 
68) An xfr file contains

  1. user written functions for reusability
  2. user written procedures for reusability
  3. user written database calls for reusability
  4. None of the above

Answer : A

 
 
69) Skew is caused by

  1. Phases
  2. checkpoints
  3. load imbalance
  4. None of the above

Answer : C

 
 
70) The following are m_ commands

  1. m_mkdir
  2. m_rollback
  3. m_cleanup
  4. All of the Above

Answer : D




 
71) What happens to main graph when subgraph is updated?

  1. it will not be updated
  2. it will be updated
  3. It will be recompiled
  4. None of the above

Answer : A

 
 
72) Can access previlege be set to dataset components?

  1. Yes
  2. No
  3. depends on the layout
  4. None of the above

Answer : A

 
 
73) Broadcast

  1. for partition
  2. makes a copy of records
  3. Both
  4. None of the above

Answer : C

 
 
74) Checkpointed sort

  1. creates small files and then finally sorts
  2. sorts partitioned datasets
  3. both
  4. None of the above

Answer : A

 
 
75) Update SQL component can have “delete” SQL statements

  1. Yes
  2. No
  3. if there are no updates
  4. None of the above

Answer : A

 
 
76) Repartition is

  1. partition
  2. departition
  3. partition and departition
  4. None of the above

Answer : C

 
 
77) What is force_error used for?

  1. to artificially crash the graph for testing or specific alarm raising
  2. to catch exceptions for unhandled condition
  3. to capture error records in error port
  4. All of the Above

Answer : A

 
 
78) get_flow_state is used for

  1. getting error code
  2. status updates
  3. Gets the position of a record in a flow
  4. All of the Above

Answer : C

 
 
79) key specfier is

  1. primary key parameter to fetch the required columns
  2. give the dataset key
  3. give the Db key for connection
  4. None of the above

Answer : A

 
 
80) ordered attribute

  1. is sorting records
  2. maintains the sequence of joining multiple flows
  3. is used for partitioning
  4. None of the above

Answer : B




 
81) Fan has the following attributes

  1. more than one flow can connect
  2. 2 flows can connect
  3. single flow can join
  4. None of the above

Answer : A

 
 
82) split string is used

  1. to feed into sort component
  2. to feed into ‘parition by range’ component
  3. both A & B
  4. None of the above

Answer : B

 
 
83) std project env contains

  1. private project
  2. public project
  3. environemnt project
  4. All of the Above

Answer : D

 
 
84) Dead lock

  1. When two or more processes request same resource
  2. can be avoided by using phasing
  3. can be avoided using resource pool
  4. All of the Above

Answer : D

 
 
85) which are multistage components

  1. scan
  2. normalize
  3. denormalize
  4. All of the Above

Answer : D

 
 
86) Multistage components

  1. are transform components
  2. records are transformed in stages
  3. both A & B
  4. None of the above

Answer : C

 
 
87) different partitioners are

  1. ROUND ROBIN
  2. KEY
  3. Both
  4. None of the above

Answer : C

 
 
88) Flow buffers

  1. are automatically added by GDE
  2. prevent deadlocking
  3. can block on read and write
  4. All of the Above

Answer : D

 
 
89) Repartition when

  1. Key changes
  2. you want to group records within the partitions of partitioned data
  3. you want to redistribute to fewer / more number of partitions
  4. All of the Above

Answer : D

 
 
90) Dynamic DML is used when

  1. different input files are received for processing which have different dml
  2. flag in the dml and the flag is first read in the input file received and according to the flag its corresponding dml is used
  3. Both A & B
  4. Dynamic DML is not possible in ab initio

Answer : C




 
91) Local Parameter

  1. needs to be initialized on declaration
  2. is passed at run time
  3. is same as formal parameter
  4. None of the above

Answer : A

 
 
92) One of the below, can not be a layout option

  1. Component
  2. URL
  3. Hosts
  4. DML

Answer : D

 
 
93) Load Imbalance in ab initio is represented as a measure of

  1. Checkpoint
  2. Vector
  3. Skew
  4. MFS

Answer : C

 
 
94) If a main graph uses many pre developed graphs as sub graphs, and updating the sub graphs

  1. Will automatically update main graph
  2. Needs Manual Updating Of Sub Graphs In Main Graph
  3. Sub Graphs Can Not Be Edited Individually
  4. None Of The Above

Answer : B

 
 
95) Find the odd one out

  1. Vector
  2. Union
  3. Record
  4. Integer

Answer : D

 
 
96) If an input file contains, CustomerId, DateOfPurchase,AmtOfPurchase, then, AmoutSpentTilldate can be calculated for each customer using

  1. Rollup
  2. Aggregate
  3. Scan
  4. Sum

Answer : C

 
 
97) If a dataflow from 4 CPU needs to be connected to a 16 CPU flow,

  1. Repartition components should be used
  2. Aggregate component should be used
  3. FTP components should be used
  4. None Of The Above

Answer : A

 
 
98) Comparing with Oracle, Input table component of a DB2 table contains

  1. No Error port
  2. All the ports like oracle table
  3. No log port
  4. No output port

Answer : A

 
 
99) Depth error is thrown out when

  1. Different layouts are connected
  2. Syntax Errors
  3. Error port contains no messages
  4. Log port contains no messages

Answer : A

 
 
100) To artificially crash a graph on some condition ________ is used

  1. force_error
  2. get_flow_state
  3. ab_report
  4. Split String

Answer : A




 
101) Intermediate files w.r.t phase

  1. Does not change phase
  2. Implicitly Changes The Phase
  3. Needs The Phase To Be Manually Set
  4. None Of The Above

Answer : B

 
 
102) You can truncate a table using a Access Tab of a Table component

  1. Not possible
  2. Possible
  3. Need to write SQLs
  4. Need to write Unix scripts

Answer : B

 
 
103) summary.dml is used

  1. For reading the raw contents of summary file
  2. As Dmls In Aggregation Components
  3. Execution Of A Jobs
  4. For Building Automatic Dmls

Answer : A

 
 
104) ABLOCAL construct is used in

  1. SQL statements
  2. XFR functions
  3. FTP commands
  4. Host settings

Answer : A

 
 
105) Which is False here about max core

  1. It has no single, optimal value
  2. Found in Sort, Join and Rollup
  3. Found in Input, Output and Intermediate Datasets
  4. Depends upon graphs and environment

Answer : C

 
 
106) Find the odd one out in the below components

  1. Load Annotation
  2. Remove objects and annotation
  3. Load MIMEobj
  4. FUSE

Answer : D

 
 
107) Which is False about Conditional component

  1. Korn Shell only can be used
  2. C Shell can only be used
  3. String evaluation should return True for a component to be enabled
  4. Can be edited in
  5. File->Preferences or settings->Preferences

Answer : B

 
 
108) db_nodes in .dbc file means

  1. Database name
  2. Machine In Which Oracle Client Runs
  3. Oracle Home
  4. Oracle Instance

Answer : B

 
 
109) Identify the right syntax for referencing an environmental variable in a dbc file

  1. db_version: $MY_DB_VERSION
  2. db_version: ${MY_DB_VERSION}
  3. db_version: MY_DB_VERSION
  4. db_version: {MY_DB_VERSION}

Answer : B

 
 
110) m_db create myconfig.dbc -dml_file my.dml -table mytable is used for

  1. Creates dbc file
  2. Creates DML
  3. Creates Table
  4. Creates Oracle Instance

Answer : C




 
111) Which is false regarding flow-state variable

  1. Facilitates Detection Of Position Of Record In A Flow
  2. Each Partition Of Flow Has Flow-State
  3. Flow State Has Initial Value Of 0
  4. it Can Not Be Used To Define conditional Record Formats

Answer : D

 
 
112) Dependency analysis are not carried out on these files

  1. Directly specified files
  2. Required files
  3. Dependent files
  4. Files yet to be checked in

Answer : D

 
 
113) ___ substitution for parameters is used for values that contain $ as a character, such as names in database tables

  1. $ Substitution
  2. ${} substitution
  3. Constant
  4. Shell

Answer : B

 
 
114) Which is false about m_env

  1. This command does not exist
  2. Is Used For Querying Environment Variable
  3. Can Debug Configuration Variable
  4. Can Give Ab Initio’s Version

Answer : A

 
 
115) When join type is set as inner and when one of the dedup is set to not to deduplicate, ____ is achieved

  1. Semi Join
  2. Compilation Error
  3. Outer Join
  4. Soft Join

Answer : A

 
 
116) execute_on_miss is used when

  1. All Rows Are Selected
  2. SQL compilation error
  3. SQL returns no rows
  4. SQL connection fails

Answer : C

 
 
117) Find the odd one out in SFTP_TO component parameters

  1. extra-args
  2. SFTP-Script
  3. output-tolerated
  4. Transfer-Encryption

Answer : D

 
 
118) lookup functions when given null arguments to use a key

  1. Will Attempt To Match Null Values To Corresponding Key
  2. Never Return Null
  3. Will Error Out
  4. Help Will Be Provided

Answer : A

 
 
119) Which is false about Compiled transforms

  1. Does Not Exist
  2. Improves Performance
  3. set in Run>Settings
  4. Does Compilation When Running Or Deploying Graphs

Answer : A

 
 
120) which is not a reserved phrase here

  1. Little
  2. Bit
  3. ieee
  4. Let

Answer : B

 
 
121) Which is not true about global variable

  1. Persists For Life Of Components That Includes The Package Where The Global Variable Is Declared
  2. Each Component Partition Has Its Own Private Copy Of Each Global Variable Declared For That Component
  3. Accesses All Transform Functions In A Package
  4. Rules, Expressions And Statements For A Package Transform Function Can Not Read And Can Not Set Value Of Global Variables

Answer : D

 
 
122) m_db gendml mydb.dbc -table ‘a.mytable’ > mytable.dml

  1. Creates Dbc File
  2. CREATES DML
  3. Creates Table
  4. Creates Oracle Instance

Answer : B

 
 
123) Which is False about Macros

  1. It contains an .mpc and .ksh
  2. Uses mp commands to build Ksh
  3. Is Same As Custom Component
  4. Layout And Metatadata Are Special Parameters In A Macro

Answer : C

 
 
124) Round Robin Partitioning

  1. Leads to even distributions of records across all partitions
  2. cannot be used where there is group based partitioning
  3. Both
  4. None of the above

Answer : C