Labour Day Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Login / Register

Question # 4

What transformation would you use to standardize data using a reference table?

A.

Labeler

B.

Decision

C.

Standardizer

D.

Parser

Full Access
Question # 5

Which of the following will Impact the total amount of time it takes to execute a column profiling process?

Options are :

A.

Number of Columns in the file

B.

Number of Rows in the source data

C.

Amount of memory and speed of the processor on the server

D.

All of the above

Full Access
Question # 6

When importing a flat file into a project. Developer and Analyst Tool work exactly the same

Options are :

A.

TRUE

B.

FALSE

Full Access
Question # 7

How is the data loaded into DQA and how is it configured?

A.

By running the DQ Client installer

B.

The Analyst defines the table in the Analyst tool, and the mappings in the Developer tool create and populate the appropriate tables

C.

The Analyst populates and creates the table in the Analyst tool

D.

The Administrator needs to create a DQA Service and associate it with the staging database

Full Access
Question # 8

Which transformations can be used in DQ for Excel?

A.

Only mappings using a Case Converter and a Standardizer can be used on data in Excel.

B.

Only mappings using non active transformations can be used in DQ for Excel.

C.

All DQ transformations, including Matching and Consolidation can be used in DQ for Excel.

D.

All DQ and Core Transformations can be used in DQ for Excel, there is no limitation.

Full Access
Question # 9

When sharing Projects across teams which of the following is True?

A.

The same icon is used to indicate a shared and non shared project.

B.

Comments that are added to a profile in the Analyst can be viewed by the Developer in the same profile in the Developer Tool.

C.

Permissions need to be assigned to each Folder within the project so users of shared projects can access all the objects.

D.

Rules that were created In the Analyst Tool will be visible In the Developer but Developer built rules can not be made available in the Analyst.

Full Access
Question # 10

Users would export DQ mappings to PowerCenter for which of the following reasons? (Choose 4 answers)

A.

Performance

B.

Scalability

C.

Batch access

D.

DQ as part of ETL process

Full Access