• platforms and products Online Quiz - 89
Back
0

platforms and products Online Quiz - 89

Description: platforms and products Online Quiz - 89
Number of Questions: 20
Created by:
Tags: platforms and products
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Which of the following are keyless partitioning methods?

technology platforms and products

  1. Entire

  2. Round Robin

  3. Random

  4. Hash

  5. Modulus

Show answer
Correct Option: A,B,C

To generate a report to show the operators, processes and datasets in the job, -------?

technology platforms and products

  1. Set APT_JOB_REPORT to True

  2. Set APT_DUMP_SCORE to True

  3. Set APT_MONITOR_SIZE to true

  4. Set APT_RECORD_COUNTS to true

Show answer
Correct Option: B

The Datastage JobMon daemon --------

technology platforms and products

  1. Writes the job’s OSH script to the job log

  2. Automatically sets all environmental variables

  3. Graceful shutdown of datastage engine

  4. Provides a snapshot of a job’s performance

Show answer
Correct Option: D

Which sort stage option can be selected to sort a dataset to retain a single occurance of multiple records that have identical sorting key values?
technology platforms and products

  1. Unique sort keys must be set to True

  2. Allow Duplicates must be set to False

  3. Sort Group must include the sort key values

  4. Stable sort must be set to true

Show answer
Correct Option: B

Which of the following could be modified to improve the performance of a job which is using a sort stage executing slow due to the amount of data processed?
technology platforms and products

  1. Environmental variable APT_AUTO_TRANSPORT_SIZE

  2. Environmental variable APT_SORT_MEMORY_SIZE

  3. Sort stage Restrict memory usage property

  4. Sort stage Max memory limit property

Show answer
Correct Option: C

You need to read data from three oracle tables that store sales data from three regions to load into a single oracle table. These three tables are having the same table definitions and the only difference is that each table contains data for a particular region. Which of the following will do the required task?

technology platforms and products

  1. Create a task with single oracle enterprise stage that executes a custom SQL statement with FETCH ALL, that outputs to an Oracle enterprise stage.

  2. Create a job with three Oracle Enterprise stages to read from the tables and output to a collector stage which in turn outputs the data to an Oracle Enterprise stage.

  3. Create a job with a single Oracle Enterprise stage that executes a custom SQL statement with UNION ALL that outputs the data to an oracle enterprise stage.

  4. Create a job with three Oracle Enterprise stages to read from the tables and output to a Funnel stage which in turn outputs the data to an oracle enterprise stage.

Show answer
Correct Option: C,D

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) Create a task with a single Oracle Enterprise stage that executes a custom SQL statement with FETCH ALL, that outputs to an Oracle Enterprise stage.

This option is incorrect because using FETCH ALL in a custom SQL statement will only fetch all rows from a single table, not from multiple tables.

Option B) Create a job with three Oracle Enterprise stages to read from the tables and output to a collector stage which in turn outputs the data to an Oracle Enterprise stage.

This option is incorrect because using a collector stage will not combine the data from the three tables into a single table. It will only collect the data from each table separately.

Option C) Create a job with a single Oracle Enterprise stage that executes a custom SQL statement with UNION ALL that outputs the data to an Oracle Enterprise stage.

This option is correct because using UNION ALL in a custom SQL statement will combine the data from the three tables into a single result set. The Oracle Enterprise stage can then output this combined data to a single table.

Option D) Create a job with three Oracle Enterprise stages to read from the tables and output to a Funnel stage which in turn outputs the data to an Oracle Enterprise stage.

This option is correct because using a Funnel stage will combine the data from the three Oracle Enterprise stages into a single stream. The combined data can then be output to an Oracle Enterprise stage to load into a single table.

The correct answer is C, D. These options will allow you to read data from the three Oracle tables and load it into a single Oracle table. Option C uses UNION ALL in a custom SQL statement, while Option D uses a Funnel stage to combine the data.

How could repetition element identified on an XML input stage, which is processing an XML file?
technology platforms and products

  1. Auto detect by XML stage.

  2. Check the "Repetition Element Required" box on the output link tab.

  3. Set the key property for the column on the output link to 'Yes'

  4. Set the 'Nullable' property for the column on the output link to 'Yes'

Show answer
Correct Option: C

What can be used to derive values for the column 'JobName' that is to contain the name of the job that is running.

technology platforms and products

  1. Datastaage function

  2. Datastage Macro

  3. A system variable

  4. a link variable

Show answer
Correct Option: B

Which of the following is true to abort a job from within the Transformer stage?

technology platforms and products

  1. Call the DSLoggFatal function from a stage variable derivation

  2. Call the DSStopJob function from a stage or column derivation

  3. Use the SETENV function to set the environmental variable APT_PM_KILL_NOWAIT

  4. Create a dummy output link with a constraint that tests for the condition to abort on; set the 'Abort After rows' property to 1

Show answer
Correct Option: D

--------------- controls the display of performance statistics in Designer?
technology platforms and products

  1. APT_NO_JOBMON

  2. APT_PERFORMANCE_DATA

  3. APT_PM_SHOW_PIDS

  4. APT_RECORD_COUNTS

Show answer
Correct Option: A

The uv command in a UNIX datastage server is used to --------?

technology platforms and products

  1. Cleanup resources from a failed datastage job

  2. Start and stop datastage engine.

  3. Provide read access to Datastage configuration file.

  4. Report datastage client connections.

Show answer
Correct Option: B

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) Cleanup resources from a failed Datastage job - This option is incorrect. The "uv" command in a UNIX Datastage server is not used specifically to clean up resources from a failed Datastage job. There are other commands and processes in Datastage that handle job cleanup.

Option B) Start and stop Datastage engine - This option is correct. The "uv" command in a UNIX Datastage server is used to start and stop the Datastage engine. It is used to control the Datastage server and manage the execution of Datastage jobs.

Option C) Provide read access to Datastage configuration file - This option is incorrect. The "uv" command is not used to provide read access to the Datastage configuration file. Access to the configuration file is typically managed through file permissions and other access control mechanisms.

Option D) Report Datastage client connections - This option is incorrect. The "uv" command does not specifically report Datastage client connections. There are other commands and tools that can be used to monitor and report on Datastage client connections.

The correct answer is B) Start and stop Datastage engine. This option is correct because the "uv" command in a UNIX Datastage server is used to start and stop the Datastage engine, allowing for the control and management of Datastage jobs.

What type of channel is required for connecting an application to a queue manager in CLIENT mode?
technology platforms and products

  1. Sender

  2. Receiver

  3. Sender/Receiver pair

  4. SVRCONN

Show answer
Correct Option: D

A MQ reason code 2035 indicates

technology platforms and products

  1. Queue Manger Not available

  2. Queue Not Available

  3. Security Error

  4. Invalid options specified in a call to connect to queue manager

Show answer
Correct Option: C

The utility used to create JNDI bindings for JMS objects is

technology platforms and products

  1. runmqsc

  2. jmsadmin

  3. MQ Explorer

  4. rfhutil

Show answer
Correct Option: B

What command is used to set authorisation permission for user Id's on MQ objects

technology platforms and products

  1. dmpmqaut

  2. runmqsc

  3. setmqaut

  4. defmqaut

Show answer
Correct Option: C

To retrieve a message from a queue as a JMS Text message, what should be the value MQMD Format?

technology platforms and products

  1. TEXT

  2. STRING

  3. MQSTR

  4. MQSTRING

Show answer
Correct Option: C

What does MQ reason code 2085 indicate?
technology platforms and products

  1. Queue Not available

  2. Security Error

  3. Queue Manager Not Available

  4. 2085 is not a valid return code

Show answer
Correct Option: A

When defining a connection factory for a JNDI binding the default value for Transport is:
technology platforms and products

  1. Client

  2. Bindings

  3. No default. The transport has to be defined explicitly

  4. None of the above

Show answer
Correct Option: B

What utility can be used to see the description for a particular reason code?

technology platforms and products

  1. runmqsc

  2. mqrc

  3. rfhutil

  4. jmsadmin

Show answer
Correct Option: B

The sample program amqsbcg is used for :

technology platforms and products

  1. purge queue

  2. put messages to a queue

  3. get messages from a queue

  4. browse messages in the queue

Show answer
Correct Option: D
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions