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

Exact2Pass Menu

Question # 4

A fact table is populated by using which transformation in SAS Data Integration Studio?

A.

SCD Type 2 Loader

B.

Data Validation

C.

Lookup

D.

DataFlux IS Job

Full Access
Question # 5

Which statement regarding propagation is FALSE?

A.

Automatic propagation can be set globally, so every new job will automatically propagate.

B.

Propagation can only occur in the direction of the job flow diagram (from beginning to end). Propagation from

the end to the beginning is not available.

C.

Automatic propagation that is set globally can be overridden and disabled within a job.

D.

Automatic propagation that is set globally or at the job level can be overridden and disabled for a selected

transformation.

Full Access
Question # 6

In SAS Data Integration Studio, where must the columns included in a business key exist?

A.

in the source and standardization tables

B.

in the source and dimension tables

C.

in the target and fact tables

D.

in the source, dimension and standardization tables

Full Access
Question # 7

When writing postcode in the Precode and Postcode tab of the Transpose transformation in SAS Data Integration Studio, which symbol allows you to reference the transformation output table regardless of the actual physical name for that target table?

A.

&syslast

B.

syslast

C.

&target

D.

%target

Full Access
Question # 8

The SAS platform application that can surface the different types of business and analytic content such as information maps, stored processes, and reports on the web browser is:

A.

SAS Information Delivery Portal

B.

SAS Information Map Studio

C.

SAS Web Report Studio

D.

SAS OLAP Cube Studio

Full Access
Question # 9

In SAS Data Integration Studio, which component allows the definition of job flows with dependencies between different jobs?

A.

the deployment wizard of SAS Data Integration Studio

B.

the Scheduling Manager plug-in in SAS Management Console

C.

the Scheduling Server

D.

the SAS DATA Step Batch Server

Full Access
Question # 10

In SAS Data Integration Studio, which output format is supported for the default "out-of-the-box" job report?

A.

HTML

B.

PDF

C.

RTF

D.

XML

Full Access