# Ab Initio Latest Quiz

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By SGundrai
S
SGundrai
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,550
Questions: 30 | Attempts: 1,553

Settings

• 1.

### How to deploy the script?

• A.

GDE

• B.

COMMAND LINE

• C.

AIR COMMAND

• D.

NONE

A. GDE
B. COMMAND LINE
Explanation
To deploy the script, the GDE (Graphical Development Environment) and the command line can be used. The GDE provides a user-friendly interface for deploying the script, while the command line allows for more advanced and automated deployment options. The "GDE, COMMAND LINE" answer suggests that both methods can be used to deploy the script.

Rate this question:

• 2.

### Why do we have a phase in a graph?

• A.

Divide the graph

• B.

Easy to understand

• C.

Resource utilization

• D.

None

C. Resource utilization
Explanation
The phase in a graph is necessary for resource utilization. By dividing the graph into different phases, we can allocate and manage resources efficiently. Each phase represents a specific set of tasks or operations that can be executed concurrently or in parallel, maximizing the utilization of available resources. This allows for better performance and optimization of the overall system.

Rate this question:

• 3.

### What are the data quality functions in abinitio?

• A.

Force_error

• B.

Abort

• C.

Is_valid

• D.

Is_null

C. Is_valid
D. Is_null
Explanation
The data quality functions in Abinitio include "is_valid" and "is_null". The "is_valid" function checks if the data is valid or not, while the "is_null" function checks if the data is null or not. These functions are used to ensure the quality and integrity of the data being processed in Abinitio.

Rate this question:

• 4.

### How do you perform the manual rollback of a job?

• A.

Rm

• B.

M_rollback

• C.

M_delete

• D.

None

B. M_rollback
Explanation
To perform a manual rollback of a job, you would use the command "m_rollback". This command allows you to revert any changes made by the job and restore the system to its previous state. It is a specific command designed for rolling back jobs and is the correct option for performing this task. The other options, "rm" and "m_delete", do not specifically refer to rolling back a job, and "none" implies that there is no manual rollback option available.

Rate this question:

• 5.

### What type of flow buffering is enabled for a graph by default?

• A.

Manual

• B.

Automatic

• C.

Both of the above

• D.

None

B. Automatic
Explanation
By default, the type of flow buffering that is enabled for a graph is automatic. This means that the system will automatically determine the appropriate flow buffering based on the requirements of the graph. The system will dynamically adjust the flow buffering as needed to optimize the performance and efficiency of the graph. This allows for efficient processing and handling of data within the graph without the need for manual intervention or configuration.

Rate this question:

• 6.

### How do you create the summary tracking report?

• A.

M_report

• B.

AB_REPORT="summary"

• C.

AB_SUMMARY

• D.

None

B. AB_REPORT="summary"
Explanation
The correct answer is AB_REPORT="summary". This answer suggests that to create the summary tracking report, the variable AB_REPORT should be set to "summary". This indicates that the report being generated will provide a summary of the tracking data. The other variables mentioned in the question, m_report and AB_SUMMARY, do not seem to be relevant to the creation of the summary tracking report.

Rate this question:

• 7.

### Which are the following components used to filter the data?

• A.

FILTER BY EXPRESS

• B.

REDIFINE

• C.

REFORMAT

• D.

NONE

A. FILTER BY EXPRESS
C. REFORMAT
Explanation
FILTER BY EXPRESS and REFORMAT are the components used to filter the data. FILTER BY EXPRESS is used to filter the data based on specific conditions or expressions, allowing only the desired data to pass through. REFORMAT is used to transform the structure or format of the data, which can also include filtering out unwanted data. Therefore, both FILTER BY EXPRESS and REFORMAT are used as components to filter the data.

Rate this question:

• 8.

### How do you implement the sequence numbers for records?

• A.

Next_in_sequence

• B.

Surrogate key

• C.

• D.

None

A. Next_in_sequence
Explanation
The correct answer is "next_in_sequence." This means that to implement sequence numbers for records, the next number in the sequence is used. This could be achieved by incrementing a counter or using an auto-increment feature provided by a database system. This ensures that each record is assigned a unique and sequential number, allowing for easy identification and ordering of the records.

Rate this question:

• 9.

### What is reject-threshold?

• A.

No.of records to be processed successfully

• B.

How many rejected records are allowed

• C.

Abort the graph

• D.

None

B. How many rejected records are allowed
Explanation
The reject-threshold refers to the maximum number of rejected records that are allowed during a process. It is not the number of records to be processed successfully, nor does it relate to aborting the graph. Instead, it specifically focuses on determining the limit for the number of records that can be rejected before any further action needs to be taken.

Rate this question:

• 10.

### What is best fit for the tuning of the graph

• A.

Database functions to be defined in SQL

• B.

Drop the fields that are not required

• C.

Filter out what is not needed

• D.

None

B. Drop the fields that are not required
C. Filter out what is not needed
Explanation
The best fit for tuning the graph and optimizing database functions defined in SQL is to drop the fields that are not required and filter out what is not needed. By removing unnecessary fields and data, the graph can be streamlined and optimized for better performance and efficiency. This helps to reduce the amount of data being processed and improves the overall speed and responsiveness of the graph.

Rate this question:

• 11.

### What is max-core?

• A.

Swap memory

• B.

Amount of memory required for a component

• C.

Physical memory

• D.

None

B. Amount of memory required for a component
Explanation
Max-core refers to the maximum amount of memory that is required for a specific component. It represents the upper limit of memory usage for that component. This can be important for system administrators and developers to ensure that the component has enough memory allocated to function properly. It helps in optimizing memory usage and preventing any potential memory-related issues.

Rate this question:

• 12.

### Can join component be used to remove the duplicates?

• A.

True

• B.

False

A. True
Explanation
The join component in data processing can be used to remove duplicates by performing a join operation on a dataset with itself, using a unique identifier as the join key. This process will eliminate duplicate records from the dataset, resulting in a dataset without duplicates. Therefore, the statement is true.

Rate this question:

• 13.

### What is a layout?

• A.

Directory

• B.

Defines program component where to run

• C.

Logical directory

• D.

None

B. Defines program component where to run
Explanation
A layout refers to the arrangement or organization of program components in a specific way that determines where they will be executed or run. It provides a structure or blueprint for the program to follow, indicating which components should be placed where in order to ensure proper functionality.

Rate this question:

• 14.

### Where will be the GDE temporary files [ not job related files ] created?

• A.

Mp directory

• B.

Run directory

• C.

Host directory

• D.

None

B. Run directory
Explanation
The GDE temporary files, which are not job-related files, will be created in the run directory.

Rate this question:

• 15.

### When program components execute simultaneously on different branches of a graph is?

• A.

Pipeline parallelism

• B.

Data parallelism

• C.

Component parallelism

• D.

None

C. Component parallelism
Explanation
Component parallelism refers to the execution of program components simultaneously on different branches of a graph. In this type of parallelism, different components of a program can be executed concurrently, allowing for efficient utilization of resources and potentially reducing the overall execution time. This approach is particularly useful when different components of a program are independent of each other and can be executed in parallel without any dependencies or synchronization requirements.

Rate this question:

• 16.

• A.

Parallel dataset with data partitions with set of serial files

• B.

Parallel files

• C.

Multi-files

• D.

None

A. Parallel dataset with data partitions with set of serial files
Explanation
An adhoc multifile refers to a parallel dataset that consists of data partitions, which are further composed of a set of serial files. This means that the data is divided into multiple parts and stored in separate files, allowing for parallel processing and efficient data retrieval.

Rate this question:

• 17.

### Can SORT component used to implement pipeline parallelism?

• A.

True

• B.

False

B. False
Explanation
The SORT component is not used to implement pipeline parallelism. Pipeline parallelism refers to the technique of dividing a task into multiple stages, where each stage processes a portion of the data concurrently. The SORT component, as the name suggests, is used to sort data and is not directly related to parallel processing. Other components, such as SPLIT, MERGE, and AGGREGATE, are typically used to implement pipeline parallelism. Therefore, the correct answer is False.

Rate this question:

• 18.

### Can we have function fields in a dml?

• A.

True

• B.

False

A. True
Explanation
Function fields can be defined in a DML (Data Manipulation Language) statement. A function field is a computed field that derives its value from the result of a function or an expression. It allows users to perform calculations or transformations on data during the execution of a DML statement. These function fields can be used to manipulate data before inserting, updating, or deleting records in a database table. Therefore, the correct answer is true.

Rate this question:

• 19.

### Dependency analysis is meant for?

• A.

Code flexibility

• B.

Data lineage

• C.

Storage of the graphs

• D.

None

B. Data lineage
Explanation
Dependency analysis is a technique used to determine the relationships and dependencies between different components or elements in a system. In the context of the given options, data lineage refers to the ability to track and understand the origin, movement, and transformation of data throughout its lifecycle. Therefore, dependency analysis is primarily used for data lineage, as it helps to identify and analyze the dependencies between different data elements, ensuring data integrity and facilitating data management and governance processes.

Rate this question:

• 20.

### What is the abInitio's default source control system

• A.

Veritas

• B.

EME

• C.

Control-M

• D.

None

B. EME
Explanation
EME is the default source control system for abInitio. EME stands for Enterprise Meta>Environment, which is a metadata management and collaboration platform. It is specifically designed for the abInitio software and provides version control, audit trails, and other features necessary for managing and tracking changes to abInitio applications and components. Using EME, developers can efficiently collaborate, share, and manage their work in a controlled and organized manner.

Rate this question:

• 21.

• A.

True

• B.

False

B. False
• 22.

### Can we have 2 or more co->systems pointing to the latest version of the EME?

• A.

True

• B.

False

A. True
Explanation
Yes, we can have 2 or more co-systems pointing to the latest version of the EME. This means that multiple co-systems can access and utilize the latest version of the EME simultaneously. Having multiple co-systems pointing to the latest version allows for increased efficiency and collaboration among different systems.

Rate this question:

• 23.

### What is the extended ASCII range

• A.

0-127

• B.

128-255

• C.

0-1

• D.

All of the above

B. 128-255
Explanation
The extended ASCII range refers to the range of characters that can be represented using ASCII codes beyond the standard 7-bit ASCII range (0-127). This extended range includes characters with codes ranging from 128 to 255. Therefore, the correct answer is 128-255.

Rate this question:

• 24.

### Which type of DML is faster in processing the data sets?

• A.

Variable Length DML

• B.

Fixed Length DML

• C.

Conditional DML

• D.

All of the above

B. Fixed Length DML
Explanation
Fixed Length DML is faster in processing data sets because it operates on fixed-length records, which means that each record has a predetermined size. This allows for faster processing as the system knows the exact size of each record and can efficiently allocate memory and perform operations. On the other hand, Variable Length DML and Conditional DML involve records with varying sizes, which can result in slower processing due to the need for additional memory allocation and more complex operations. Therefore, Fixed Length DML is the preferred choice for faster data set processing.

Rate this question:

• 25.

### What is AB_LOCAL() construct in ab initio?

• A.

Abinitio local variable

• B.

Parse grammer in complex SQL statements

• C.

Function in abinitio

• D.

All of the above

B. Parse grammer in complex SQL statements
Explanation
The AB_LOCAL() construct in Ab Initio is used to parse grammar in complex SQL statements. It allows for the extraction and manipulation of data from SQL statements, making it easier to work with and analyze complex data structures. This construct is a function in Ab Initio that helps in handling and processing SQL statements effectively.

Rate this question:

• 26.

### What is ab_type_info in ab initio?

• A.

Ab initio information

• B.

Data type information of dml fields

• C.

Environment infomation

• D.

All of the above

B. Data type information of dml fields
Explanation
The ab_type_info in Ab Initio refers to the data type information of DML (Data Manipulation Language) fields. It provides details about the structure and format of the data fields used in Ab Initio graphs and transformations. This information is crucial for accurately processing and transforming the data within the Ab Initio environment. Therefore, the correct answer is "data type information of DML fields."

Rate this question:

• 27.

### Allocate() will

• A.

Construct an initial value for an object

• B.

Creates an object

• C.

Creates an object with 1

• D.

None

A. Construct an initial value for an object
Explanation
The function allocate() is used to construct an initial value for an object. It is responsible for creating and initializing the object with a starting value. This suggests that the allocate() function is used to allocate memory and resources for the object and set its initial state or value.

Rate this question:

• 28.

### What are the two database interface modes from abinitio?

• A.

• B.

Import

• C.

API

• D.

Utility

C. API
D. Utility
Explanation
Ab Initio provides two database interface modes: API and utility. API stands for Application Programming Interface, which allows users to interact with the database using programming languages and execute complex database operations. Utility mode, on the other hand, provides a user-friendly interface for performing routine database tasks such as data loading, extraction, and transformation. These two modes offer different levels of flexibility and functionality to suit different user requirements when working with databases in Ab Initio.

Rate this question:

• 29.

### A continuous graph can run

• A.

Forever

• B.

Exit when no more data is available

• C.

Exit based on the content of the data

• D.

None

A. Forever
B. Exit when no more data is available
C. Exit based on the content of the data
Explanation
A continuous graph can run forever because it represents a continuous function that has no breaks or interruptions. It can extend infinitely in both the positive and negative directions. However, it can also exit when no more data is available, meaning that the graph stops when there is no more information to plot. Additionally, the graph can also exit based on the content of the data, such as reaching a certain threshold or condition that determines the end of the graph.

Rate this question:

• 30.

### How to calculate the memory usage of a folded component

• A.

Main memory + swap memory

• B.

Base amount + lookups + max-core [ base amount represents the memory required to start each component process ]

• C.

Max-core+disk space

• D.

None

B. Base amount + lookups + max-core [ base amount represents the memory required to start each component process ]
Explanation
The memory usage of a folded component can be calculated by adding the base amount, which represents the memory required to start each component process, to the lookups and max-core. The base amount is the minimum amount of memory needed to initiate the component process, while lookups and max-core represent additional memory requirements. Therefore, the total memory usage is determined by these three factors.

Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

• Current Version
• Mar 21, 2023
Quiz Edited by
ProProfs Editorial Team
• Oct 15, 2013
Quiz Created by
SGundrai

Related Topics