0

technology Online Quiz - 1681

Description: technology Online Quiz - 1681
Number of Questions: 20
Created by:
Tags: technology
Attempted 0/20 Correct 0 Score 0

The source can be imported as target but the target cant be imported as source

  1. True

  2. False


Correct Option: A

Truncate table option set in session level when run for the first time will throw error

  1. True

  2. False


Correct Option: A

Database sort order need not match with session sort order

  1. True

  2. False


Correct Option: B

Debugger is available in designer

  1. True

  2. False


Correct Option: A

Debugger is available in designer

  1. True

  2. False


Correct Option: A

Define Vin ?

  1. Vehicle Indentification Number

  2. Vehicle Information Number

  3. Van Information Number

  4. Van Indentification Number

  5. Vehicle Index Number

  6. Van Index Number


Correct Option: A

i/p ports are allowed for sequence generator

  1. True

  2. False


Correct Option: B

We can create tasks directly in workflow designer w/o actually creating it in task developer

  1. True

  2. False


Correct Option: A

Variable ports are not available in which of the following transformation?

  1. Expression

  2. Aggregator

  3. Rank

  4. Router


Correct Option: D

alt-t--is the keyboard shortcut for adding ports in a transformation

  1. True

  2. False


Correct Option: B

In workflow monitor - abort has a 30 second timeout

  1. True

  2. False


Correct Option: B

1.What is the lowest CPU cost partitioning method for parallel stage to parallel stage?

  1. Range

  2. Modulus

  3. Entire

  4. Same


Correct Option: D

AI Explanation

To answer this question, you need to understand the concept of partitioning methods in parallel processing.

The lowest CPU cost partitioning method for parallel stage to parallel stage is the "Same" method.

The "Same" partitioning method ensures that the same data is sent to all parallel stages. This means that the data is not divided or partitioned in any way, and each parallel stage receives the entire dataset.

Let's go through each option to understand why it is correct or incorrect:

Option A) Range - This option is incorrect because the "Range" partitioning method divides the data into ranges or intervals and assigns each range to a different parallel stage. This can increase the CPU cost as it requires additional computation to determine the ranges and assign data to each stage.

Option B) Modulus - This option is incorrect because the "Modulus" partitioning method uses a modulo operation to assign data to different parallel stages based on the remainder of a division. This can also increase the CPU cost as it requires additional computation to determine the modulo and assign data to each stage.

Option C) Entire - This option is incorrect because the "Entire" partitioning method sends the entire dataset to a single parallel stage. This can lead to a higher CPU cost as it requires a single stage to process the entire dataset.

Option D) Same - This option is correct because the "Same" partitioning method sends the same data to all parallel stages. This eliminates the need for data division or computation to determine ranges or modulo, resulting in the lowest CPU cost.

The correct answer is D) Same. This option is correct because it eliminates the need for data division or computation, resulting in the lowest CPU cost.

Which Oracle Enterprise stage read property can be set using db options to tune job performance?

  1. memsize

  2. arraysize

  3. partitionsize

  4. transactsize


Correct Option: B

What is the Default partitioning method used between 2 "parallel" stages?

  1. same

  2. Round Robin

  3. Hash

  4. Random


Correct Option: A

You need to invoke a job from the command line that is a multi-instance enabled. What is the correct syntax to start a multi-instance job

  1. dsjob -run -mode NORMAL -instance

  2. dsjob -run -mode NORMAL -wait -instance

  3. dsjob -run -mode NORMAL .

  4. dsjob -run -mode MULTI .


Correct Option: C

Which three statements are true about File Sets? (Choose three.)

  1. File sets are partitioned.

  2. File sets are unpartitioned.

  3. File sets are stored as a single file.

  4. File sets are readable by external applications.

  5. File sets are stored as header file and data files


Correct Option: A,D,E

Which three lookup types may be performed in the Lookup stage? (Choose three.)

  1. Equality match

  2. Negative match

  3. Range on stream link

  4. Range on the reject link

  5. Range on the reference link


Correct Option: A,C,E

Which three actions can improve sort performance in a DataStage job? (Choose three.)

  1. Specify only the key columns which are necessary.

  2. Use the stable-sort option to avoid the random ordering of non-key data.

  3. Minimize the number of sorts used within a job flow.

  4. Adjusting the "Restrict Memory Usage" option in the Sort stage.

  5. Run the job sequentially so that only one sort process is invoked.


Correct Option: A,C,D

Which import option can be used to import metadata from a data modeling tool such as Erwin or Rational Data Architect?

  1. Import using bridges.

  2. Import a table definition using the Connector wizard.

  3. Import DataStage components.

  4. Import a table definition using the Plug-In Meta Data facility.


Correct Option: A

AI Explanation

To answer this question, you need to understand the different import options available for importing metadata from a data modeling tool such as Erwin or Rational Data Architect. Let's go through each option to understand why it is correct or incorrect:

Option A) Import using bridges - This option is correct because importing metadata from a data modeling tool can be done using bridges. Bridges are connectors that provide a seamless integration between different tools and platforms, allowing for the exchange of data and metadata.

Option B) Import a table definition using the Connector wizard - This option is incorrect because the Connector wizard is typically used for importing data from different sources, not for importing metadata from data modeling tools.

Option C) Import DataStage components - This option is incorrect because DataStage components are specific to IBM InfoSphere DataStage, a data integration tool, and not related to importing metadata from data modeling tools.

Option D) Import a table definition using the Plug-In Meta Data facility - This option is incorrect because the Plug-In Meta Data facility is a general term and does not specifically refer to importing metadata from data modeling tools.

The correct answer is A) Import using bridges. This option is correct because it allows for the import of metadata from data modeling tools like Erwin or Rational Data Architect using dedicated connectors or bridges.

- Hide questions