Which two statements are accurate regarding usage of database stages? (Choose two.)

You set environment variable $APT_ORACLE_LOAD_OPTIONS=PTIONS(DIRECT=TRUE,
PARALLEL=TRUE)?for loading index organized tables.You set environment variable
$APT_ORACLE_LOAD_OPTIONS=?PTIONS(DIRECT=TRUE, PARALLEL=TRUE)?for loading
index organized tables. Which statement is accurate regarding the resulting effect of this
environment variable setting?

In which two situations is it appropriate to use a Sparse Lookup? (Choose two.)

Which of the following is not an ODBC connector property?

You have a job that reads in Sequential File followed by a Transformer stage. When you run this
job, which partitioning method will be used by default?

A job reads from a sequential file using a SequentialFile stage with option “number of readers” set
to 2. This data goes to a Transformer stage and then is written to a dataset using the DataSet
stage. The default configuration file has three nodes. The environment variable
$APT_DISABLE_COMBINATION is set to “True” and partitioning is set to “Auto”. How many
processes will be created?

Which two properties can be set to read a fixed width sequential file in parallel? (Choose two.)

Which two partitioning methods require keys? (Choose two.)

Click the Exhibit button.
These three Sequential Files shown in the exhibit need to be joined. Join_1 is on Columns CustID
and OrderID. Join_2 is on CustID and LocationID. What is the most efficient hash partitioning
strategy for each link?

A job design consists of an input sequential file, a Modify stage, followed by a Filter stage and an
output SequentialFile stage. The job is run on an SMP machine with a configuration file defined
with three nodes. No environment variables were set for the job. How many osh processes will this
job create?