0

platforms and products Online Quiz - 66

Description: platforms and products Online Quiz - 66
Number of Questions: 20
Created by:
Tags: platforms and products
Attempted 0/20 Correct 0 Score 0

8) Setting Limit=1 and Ramp=1 output will be

  1. a. Never Abort

  2. b. Abort on first Reject

  3. c. Abort after 50 errors

  4. d. Abort after 100 errors


Correct Option: A

To get the cumulative summary output component used is

  1. a. Rollup

  2. b. Scan

  3. c. Normalize

  4. d. Replicate


Correct Option: B

There are two ports in0 & in1. To call transform for every record on in0 regardless of whether there is a matching record on the in1 port the options

  1. a. Set the join type as inner join

  2. b. Set the join type as explicit with require parameter true for in0

  3. c. Set the join type as explicit with require parameter true for in1

  4. d. Set the join type as full outer join


Correct Option: B

Component used to distribute the record evenly in each partition

  1. a. Partition by Key

  2. b. Partition by Round Robin

  3. c. Partition by Expression

  4. d. Partition by Range


Correct Option: B

To achieve data parallelism component used

  1. a. Replicate

  2. b. Gather

  3. c. Broadcast

  4. d.Reformat


Correct Option: C

To terminate a graph based on condition use

  1. a. Reformat component

  2. b. Reformat component with force_error

  3. c. Set condition in graph’s end script

  4. d. Replicate


Correct Option: B

Setting Limit=1 and Ramp=1 output will be

  1. a. Never Abort

  2. b. Abort on first Reject

  3. c. Abort after 50 errors

  4. d. Abort after 100 errors


Correct Option: A

To generate test data records, make use of

  1. a. Gather log

  2. b. Generate Record

  3. c. Validate Record

  4. d. Compare Record


Correct Option: B

Prints information about data records, their record format, and the evaluations of expression

  1. a. m_ls

  2. b. m_cat

  3. c. m_dump

  4. d. m_dbload


Correct Option: C

Command to create multifile system

  1. a. cat

  2. b. m_mkdir

  3. c. m_mkfs

  4. d. m_cat


Correct Option: C

We can change the values in data records using Redefine component

  1. True

  2. False


Correct Option: A

Prompt Tables always validate against the underlying Record?

  1. True

  2. False


Correct Option: B

What is the record field property that should be set to validate dates for <> 30 days?

  1. Setting %Date as constant

  2. Required

  3. Specifying Default using Record and Field values

  4. Reasonable date

  5. Validate date


Correct Option: D

AI Explanation

To answer this question, we need to understand the different record field properties that can be set to validate dates.

Option A) Setting %Date as constant - This option is incorrect because setting %Date as a constant does not validate dates for less than or greater than 30 days. It only sets a constant value for the %Date field.

Option B) Required - This option is incorrect because setting a field as required does not specifically validate dates for less than or greater than 30 days. It only ensures that a value is entered for the field.

Option C) Specifying Default using Record and Field values - This option is incorrect because specifying a default value using record and field values does not validate dates for less than or greater than 30 days. It only sets a default value for the field.

Option D) Reasonable date - This option is correct. The "Reasonable date" property can be set to validate dates for less than or greater than 30 days. It allows you to define a range of reasonable dates and ensures that the entered date falls within that range.

Option E) Validate date - This option is incorrect because the "Validate date" property only validates the format of the entered date, such as ensuring that it is in the correct format (e.g., mm/dd/yyyy).

The correct answer is D) Reasonable date. This option is correct because it allows you to validate dates for less than or greater than 30 days by defining a range of reasonable dates.

What is the event that fires after all database updates are over?

  1. Save Post Change

  2. Post Build

  3. Save Pre Change

  4. Workflow


Correct Option: A

Which of the following record definition is not required to be built?

  1. SQL View

  2. Sub Record

  3. SQL Table

  4. Work Record


Correct Option: D

Where is Meta-Sql stored?

  1. Temp Table

  2. SQL Table

  3. Query Table

  4. Dynamic View


Correct Option: A

What type of a field can have Auto Update?

  1. CHAR

  2. LONG CHAR

  3. DATE

  4. NUMBER


Correct Option: C
  1. Component

  2. Sub Page

  3. Secondary Page

  4. All of the above


Correct Option: C

Which of the following is not a Component Event?

  1. Post Build

  2. Save Post Change

  3. Workflow

  4. Save Edit


Correct Option: D

EFFDT cannot occur at what occurs levels?

  1. 0

  2. 1

  3. 2

  4. 3

  5. 4


Correct Option: A
- Hide questions