Tag: databases

Questions Related to databases

Function of Multicast Transformation is:

technology databases

  1. distributes a row to single output and another to the other output

  2. distributes its input to one or more outputs

  3. join two inputs

  4. extract data from a connection

Show answer
Correct Option: B

Which of the following is not a Control Flow Element?
technology databases

  1. Containers

  2. Tasks

  3. Transformations

  4. Precedence Constraints

Show answer
Correct Option: C

ETL stands for
technology databases

  1. Export Transform Load

  2. Extract Track Load

  3. Extract Tool Load

  4. Extract Transform Load

Show answer
Correct Option: D

Variables can only be defined at scope of entire package.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

How is a parent package variable value passed to child package?

technology databases

  1. by global variables

  2. by setting package configurations in child package

  3. by setting package configurations in parent package

  4. by Execute Package task

Show answer
Correct Option: B

Partition Primary Index would be defined in which stage of modeling?
technology databases

  1. Logical

  2. Extended Logical

  3. Physical

  4. Extended Physical

Show answer
Correct Option: C

Number of NULLs is considered a data demographic
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which two data demographics should you consider when deciding whether or not to store or calculate derived data? (Select 2)
technology databases

  1. Maximum Number of NULLs

  2. Access Frequency

  3. Change Rating

  4. Typical Rows Per Value

Show answer
Correct Option: B,C

Pick the two statements that are true regarding Identity Columns. (Select 2)
technology databases

  1. They don't have to be a Primary Index column

  2. They are not allowed to be a Primary Index column.

  3. They are required to be a Non-Unique Primary Index

  4. You can only specify one Identity Column per table.

Show answer
Correct Option: A,D

What is contained in a USI subtable? (Select 3)
technology databases

  1. The buckets containing the AMP numbers where the data is stored.

  2. The USI column value

  3. The Row ID of the base row.

  4. The Secondary Index Row ID.

  5. The Integer Type of all Value-Ordered NUSIs.

Show answer
Correct Option: B,C,D