March Special Sale - Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 575363r9

Welcome To DumpsPedia

C2090-424 Sample Questions Answers

Questions 4

The Lookup stage is one of three stages that join records based on the values of key columns. What are the other stages? (Choose two.)

Options:

A.

Join

B.

Merge

C.

Modify

D.

Funnel

E.

Difference

Buy Now
Questions 5

You are experiencing performance issues for a given job. You are assigned the task of understanding what is happening at run time for that job.

What steps should you take to understand the job performance issues? (Choose two.)

Options:

A.

Use the resource estimation tool

B.

Use the performance analysis tool

C.

Replace Join stages by Lookup stages

D.

Run the job with $APT_TRACE_RUN set to true

E.

Run the job with $APT_DUMP_SCORE set to true

Buy Now
Questions 6

Which statement about shared containers is TRUE?

Options:

A.

A shared container is an independently compiled unit

B.

A local container can be converted to a shared container

C.

A shared container can be converted to a local container

D.

A container cannot be created by selecting a group of stages and links in a job

Buy Now
Questions 7

In order to collect operational metadata, you must do which of the following?

Options:

A.

Enable “Generate operational metadata” in the Execution tab of the job properties using the Designer client

B.

Enable “Generate operational metadata” in the General tab of the project properties using the Director client

C.

Enable “Record job performance data” in the General tab of the project properties using the Administrator client

D.

Enable “Generate operational metadata” in the General tab of the Job Run Options dialog box in the Director client

Buy Now
Questions 8

The APT_SubProcessOperator is used for what purpose?

Options:

A.

It allows you to incorporate a third-party executable into the framework

B.

It provides the capability to break predefined operatorsinto sub processes

C.

It provides the capability to define custom operators at the sub process level

D.

It allows you to incorporatecomposite operators, which contain more than one operator

Buy Now
Questions 9

When building an UPDATE statement in SQL Query builder, which of the following is TRUE?

Options:

A.

Predicates cannot refine what rows are updated

B.

Table(s) referenced must have table definitions imported previously

C.

Column values can be job parameters or input columns but not expressions

D.

Columns to update must be selected individually from the column selection grid

Buy Now