• technology Online Quiz - 1556
Back
0

technology Online Quiz - 1556

Description: technology Online Quiz - 1556
Number of Questions: 20
Created by:
Tags: technology
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

How the data can be read from the output of one or more source programs

technology

  1. External Source Stage

  2. External Target Stage

  3. Complex Flat File Stage

  4. Internal File Stage

Show answer
Correct Option: A

What is the hierarchy in DataStage

technology

  1. Project, category, jobs

  2. Category, jobs, project

  3. Jobs, project, category

  4. Project, jobs, category

Show answer
Correct Option: D

What is (are) the difference between Lookup, Join and Merge

technology

  1. Memory usage

  2. Sorting

  3. Treatment of rows with unmatched keys

  4. All the above

Show answer
Correct Option: D

Which are the Datastage server components?

technology

  1. Data Stage Engine, Meta Data Repository, Package Installer

  2. Data Stage Administrator, Data Stage Designer, Data Stage Director

  3. Data Stage Engine and Meta Data Repository

  4. Data Stage Engine and Package Installer

Show answer
Correct Option: A

Which two must be specified to manage Runtime Column Propagation? (Choose two.)

technology

  1. enabled in DataStage Administrator

  2. attached to a table definition in DataStage Manager

  3. enabled at the stage level

  4. enabled with environmental parameters set at runtime

Show answer
Correct Option: A,C

Which three are valid ways within a Job Sequence to pass parameters to Activity stages? (Choose three.)

technology

  1. ExecCommand Activity stage

  2. UserVariables Activity stage

  3. Sequencer Activity stage

  4. Routine Activity stage

  5. Nested Condition Activity stage

Show answer
Correct Option: A,B,D

Which statement is true about lookup stage?

technology

  1. The lookup stages use more memory than the Merge and join stages.

  2. The source primary input link must be sorted.

  3. Both

  4. None of the above

Show answer
Correct Option: A

Which of the following is valid about shared containers?

technology

  1. These are reusable job elements.

  2. They can only be used within a project

  3. When shared containers are modified. Modifications are reflected in all the jobs that use them.

  4. None of the above

Show answer
Correct Option: C

AI Explanation

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

Option A) These are reusable job elements - This option is incorrect. Shared containers are not necessarily job elements. They can be used to share common resources or configurations across multiple jobs or projects.

Option B) They can only be used within a project - This option is incorrect. Shared containers can be used across multiple projects, not limited to a single project.

Option C) When shared containers are modified, modifications are reflected in all the jobs that use them - This option is correct. Shared containers allow for centralizing configurations or resources that are common to multiple jobs. When a shared container is modified, these modifications are reflected in all the jobs that use the shared container, ensuring consistency across jobs.

Option D) None of the above - This option is incorrect since option C is valid about shared containers.

The correct answer is C. This option is correct because shared containers allow for modifications to be reflected in all the jobs that use them.

  1. What are the ways to execute datastage jobs? a. From Datastage Director (menu Job -> Run now...) b. From command line using a dsjob command c. Datastage routine can run a job (DsRunJob command) d. By a job sequencer
technology

  1. a, b & d

  2. a & b

  3. a & d

  4. a, b, c &d

Show answer
Correct Option: D

How copying of data between Parallel Stage Operators be minimized

technology

  1. Combinability mode

  2. Preserve partitioning

  3. Execution Mode

  4. Don’t combine mode

Show answer
Correct Option: B

Which records are taken in the reject link in Transformer stage?

technology

  1. Condition not met

  2. Mismatched Meta data

  3. Null records

  4. None of the above

Show answer
Correct Option: A

Which options allow you to specify a string at the end each record?

technology

  1. Record delimiter string

  2. Field delimiter string

  3. Record Prefix

  4. Final delimiter

Show answer
Correct Option: A

Click the odd man out

technology

  1. dml

  2. sql

  3. run

  4. mp

Show answer
Correct Option: B

How the data can be read from the output of one or more source programs

technology

  1. External Source Stage

  2. External Target Stage

  3. Complex Flat File Stage

  4. Internal File Stage

Show answer
Correct Option: A

What is the hierarchy in DataStage

technology

  1. Project, category, jobs

  2. Category, jobs, project

  3. Jobs, project, category

  4. Project, jobs, category

Show answer
Correct Option: D

What is (are) the difference between Lookup, Join and Merge

technology

  1. Memory usage

  2. Sorting

  3. Treatment of rows with unmatched keys

  4. All the above

Show answer
Correct Option: D

Which are the Datastage server components?

technology

  1. Data Stage Engine, Meta Data Repository, Package Installer

  2. Data Stage Administrator, Data Stage Designer, Data Stage Director

  3. Data Stage Engine and Meta Data Repository

  4. Data Stage Engine and Package Installer

Show answer
Correct Option: A

Which two must be specified to manage Runtime Column Propagation? (Choose two.)

technology

  1. enabled in DataStage Administrator

  2. attached to a table definition in DataStage Manager

  3. enabled at the stage level

  4. enabled with environmental parameters set at runtime

Show answer
Correct Option: A,C

Which three are valid ways within a Job Sequence to pass parameters to Activity stages? (Choose three.)

technology

  1. ExecCommand Activity stage

  2. UserVariables Activity stage

  3. Sequencer Activity stage

  4. Routine Activity stage

  5. Nested Condition Activity stage

Show answer
Correct Option: A,B,D

Which statement is true about lookup stage?

technology

  1. The lookup stages use more memory than the Merge and join stages.

  2. The source primary input link must be sorted.

  3. Both

  4. None of the above

Show answer
Correct Option: A
- 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