Ab Initio Quiz

Ab Initio Expert Quiz

1) We have two file A & B. A has data volume of 20 GB and B has only 10 MB and data is not sorted.  If these two files to be joined, what you will recommend from below options :

1. Select the Parameter sorted input to “input must be sorted” and make the File A as Deriving Port
2. Select the Parameter sorted input to “input need not be sorted” and make the File A as Deriving Port.
3. Select the Parameter sorted input to “input need not be sorted” and make the File B as Deriving Port.
4. Select the Parameter sorted input to “input must be sorted” and make the File B as Deriving Port.

Show Answer

 
 
2) If you want to view the data in M-dump format through Abinitio component select

1. view data formatted
2. view data
3. view data unformatted
4. view data dump

Show Answer

 
 
3) To delete all watcher datasets in the default directory (for all graphs), In the GDE choose

1. Debug > Delete Watcher Datasets
2. Settings > Delete Watcher Datasets
3. Debug > Remove All Watcher
4. Settings > Delete All Watcher

Show Answer

 
 
4) You can verify the status of the graph in the end script using the variable

1. $mpresult
2. $mpjret
3. $mpcheck
4. $mpsuccess

Show Answer

 
 
5) Abinitio function cobol-to-dml converts REDIFINE of copybook into

1. ReOrganize
2. Organize
3. Union
4. Change

Show Answer

 
 
6) Which of the below functions is used for partitioned lookup files

1. lookup_match
2. lookup_partition
3. lookup_local
4. partition_lookup

Show Answer

 
 
7) m_eval ‘(decimal(6,2)) 1234’ gives

1234. 00
1235. 123400
1236. 00
1237. 1234

Show Answer

 
 
8) To read in a set of files based on a pattern in the filenames use below component?

1. READ MULTIPLE INPUT
2. READ MULTIPLE FILES
3. READ MULTIPLE INPUT FILES
4. MULTIPLE INPUT FILES

Show Answer

 
 
9) What does the error message “broken pipe” mean?

1. data got corrupted
2. pipe is present in the data
3. downstream component has gone away unexpectedly
4. Graph has aborted unexpectedly

Show Answer

 
 
10) Can I reverse-engineer a graph (that is, create an .mp file from a deployed .ksh script)?

1. Yes
2. No
3. Maybe
4. None of the above

Show Answer

 
11) Which function do we use to terminate a graph based on a condition?

1. force_abort
2. force_error
3. force_terminate
4. force_stop

Show Answer

 
 
12) What is the syntax used to locate files with URLs

2. [ file | mfile ] :/directory1/directory2…/filename
3. [ file | mfile ] ://hostname/directory1/directory2…/filename
4. [ file | mfile ] ://servername/hostname/directory1/directory2…/filename
5. [ file | mfile ] ://servername/directory1/directory2…/filename

Show Answer

 
 
13) The Graphs start script which performs setup actions is saved as

1. .project-start.ksh
2. .start-setup.ksh
3. .start-graph.ksh
4. .temp-start.ksh

Show Answer

 
 
14) When to opt for SED TYPE2?

1. No history is required.
2. History is required
3. Only last modified information is required
4. None of the above

Show Answer

 
 
15) If I am working in Abinitio and Teradata and I have a 1 TB Data that need to joined with existing data (4 TB) to get Delta records. What will you recommend :

1. Get the data into one Temporary Table and do a join with existing data.
2. Unload the existing data to Abinitio environment and use the Join component to get the delta.
3. Create one Master File for existing data and do the Join with existing data.
4. None of the above.

Show Answer

 
 
16) When to use Phase Break in Graph ?

1. Before every Join component.
2. After the input file is read.
3. After every 15-20 Component (or) MAX_CORE Parameter  is greater  than 100%
4. None of the above.

Show Answer

 
 
17) If I have 10 Psets that can run parallel. What method would you recommend to load the data parallel mode with cost effectiveness :

1. Use the Abinitio Plan and schedule the Psets Parallel.
2. Run the Psets in serial Mode.
3. Run the psets in Background and check the Status with PID value.
4. None of the above.

Show Answer

 
 
18) What level of skewedness  the data should have in a graph

1. 0
2. 5
3. 1
4. 99

Show Answer

 
 
19) If there is lot of skewness in graph, To reduce the skewedness what is the possible solution that we can have :

1. Use Round Robin Component to equally partition the data.
2. Use Partition by Key to partition the data.
3. Use filter by Expression.
4. Use more key value to reduce the skewness in partition by key component.

Show Answer

 
 
20) If I have 1 TB of data which mode should I use to insert the data into DATABASE :

1. API Mode
2. TPT Mode
3. MLOAD
4. None of the above.

Show Answer

 
21) If I have a sorted file and there is a requirement to  de-partition the data which component should I use for faster performance :

1. Gather
2. Merge
3. Replicate
4. None of the above.

Show Answer

 
 
22) If I have four Files lets say A, B, C, and D with data volume 50 GB, 40 MB, 10 MB, 2 KB. Which File should I choose as deriving port while doing a Join :

1. File A
2. File B
3. File C
4. File D

Show Answer

 
 
23) How can I use the 1 TB of Block compressed lookup File for best results and performance :

1. Decompress the file and use it as a normal lookup file.
2. Use Dynamic lookup Concept.
3. Use Join component.
4. Can’t say

Show Answer

 
 
24) While sending a file to other server securely which method should I use :

1. FTP
2. SCP
3. SFTP
4. B and C Both can be used

Show Answer

 
 
25) Which of the below operation cannot be possible using REFORMAT and lookup ?

1. Inner Join
2. Explicit Join
3. Full Outer Join
4. None of the above.

Show Answer

 
 
26) How to run a script ($AI_BIN/send_email_to_support.ksh) after the successful completion of the graph in the end script?

1. if [ $? -eq 0 ]; then
2. $AI_BIN/send_email_to_support.ksh
3. fi
5. if [ $mpjret -eq 0 ]; then
6. $AI_BIN/send_email_to_support.ksh
7. fi
8. if [ $$ -eq 0 ]; then
9. $AI_BIN/send_email_to_support.ksh
10. fi
11. Not Possible

Show Answer

 
 
27) When using ABLOCAL for unloading in parallel in the complex SQL statements containing grammer, which among the below statements are correct.

1. ABLOCAL prevents the INPUT TABLE component from parsing the SQL
2. SQL statements will get passed through to the database
4. Both A & B
5. None of these

Show Answer

 
 
28) How to increase the performace of sort

1. Convert data from length-prefixed or delimited to fixed-length
2. Use multiple sort in sequence.
3. Convert data from fixed length to delimited.
5. Use complex dml type for key fields.

Show Answer

 
 
29) If the flow after the Replicate component needs to be in a different phase, then where to place the checkpoint/phase break.

1. Place the checkpoint or phase break after Replicate
2. Checkpoint or phase break should not be placed before/after replicate.
3. Place the checkpoint or phase break before Replicate
4. Placing checkpoint or phase break it has no impact on the performance of graph.

Show Answer

 
 
30) Preferable record type for better maintainability ??

1. delimited
2. fixed-length
3. length-prefixed
4. Any type

Show Answer

 
31) Preferable record type for better performance ??

1. delimited
2. fixed-length
3. length-prefixed
4. Any type

Show Answer

 
 
32) Preferable record type for better flexibility ??

1. delimited
2. fixed-length
3. length-prefixed
4. Any type

Show Answer

 
 
33) Conditional record formats are extremely useful for parsing heterogeneous data structures, keeping performance in view when should it be used.

1. To parse data but not to process it
2. Only while process data
3. To parse dat and to process the data
4. Conditional record formats should not be used

Show Answer

 
 
34) For optimal performace while reading, writing, and manipulating which DML types should be used

1. delimited
2. fixed-length
3. length-prefixed
4. Any type

Show Answer

 
 
35) How to control the amount of memory consumption in a graph

1. Breaking the data up into smaller separate datasets
3. Reducing the level of data parallelism
5. Using THROTTLE component in graph
6. Use the AB_NICE configuration variable

Show Answer

 
 
36) What is two-stage routing.

1. Running the graph in component folding mode implies running it using two-stage routing.
2. To save network resources one can mark all-to all flow as using two-stage routing.
3. It is layout of network component running on remote system.
4. two-stage routing is a conitnuos component.

Show Answer

 
 
37) When to use two-stage routing.

1. Use two-stage routing if the there are than 30 component in the graph.
2. Use two-stage routing there are continuous component used.
3. Use two-stage routing if the all-to-all flows in a graph have more than 30 partitions
4. It should not be used at all.

Show Answer

 
 
38) When is memory mapping of lookup file not possible
 

1. Lookup file is remote.
2. Lookup file is indexed
3. Lookup file has complex key set
4. When size of lookup file is more than 2GB

Show Answer

 
 
39) When a lookup plus reformat is better than JOIN

1. You need to make the graph easy to read and understand.
2. All but one of inputs are small enough to fit into memory.
3. One of your non-driving inputs is too large to fit into memory.
4. The lookup file may grow significantly over time.

Show Answer

 
 
40) When  a lookup plus reformat cannot replace a JOIN

1. While performing full outer join
2. While performing full inner join
3. The joining expression is complex and uses several lookup tables.
4. The joining expression involves intervals or pattern matching.

Show Answer

 
41) What is true about Common projects

1. Common projects are always  created by Ab Initio environment.
2. All common projects are public
3. Any project included by another project is, by definition, common
4. None of the above

Show Answer

 
 
42) When to export a parameter to the environment

1. Always export a parameter to the environment
2. When the graph is deplyed with “dynamic script generation”
3. When a parameter is declared as constant.
4. It will be referenced indirectly in some other parameter value expression

Show Answer

 
 
43) How to determine whether a sandbox is attached to a technical repository project?

1. air sandbox show-common
2. air sandbox info
3. air sandbox find
4. air repository show

Show Answer

 
 
44) What are .abi-unc files

1. It is an alias of .abinitiorc file.
2. .abi-unc files are temporary files used by the checkout process.
3. This file contains information for unix connectivity.
4. No such file is created or exist in Ab Initio.

Show Answer

 
 
45) What is the layout of watcher files

1. Watchers data is not written anywhere.
2. It places in the AB_WORK_DIR.
3. It places in the layout of the component upstream of the watcher.
4. It places in the layout of the component downstream of the watcher.

Show Answer

 
 
46) When database layout is set to default then which working directory does the Co>Operating System use?

1. AB_WORK_DIR
2. AB_DATA_DIR
3. AB_JOB
4. AB_WORK

Show Answer

 
 
47) What is ABLOCAL and when shall it be used

1. When graph needs to be run locally.
2. When complex SQL statement contains grammar that cannot be recognized by the Ab Initio parser when unloading in parallel.
3. When Co>Operating system and GDE are installed on same system.
4. None of the above

Show Answer

 
 
48) If we have a source File  and a lookup file – both are multifiles and are partitioned on same key, Which lookup function will give the faster performance ??

1. Lookup () Function
2. Lookup_local () Function
3. Lookup and Lookup_local will give the same performance
4. None of the above

Show Answer

 
 
49) How to improve the performance of a graph?

1. Use a limited number of components in a particular phase
2. Use optimum value of max core values for sort and join components
3. Minimize the number of sort components
4. All of the Above

Show Answer

 
 
50) Specify the option for command line equivalent while analysing dependency for generic graphs

1. expand
2. ignore-sql-errors
3. link
4. none

Show Answer