SAS DI

1.

When using SAS Data Integration Studio's SQL Join transformation, which SQL join type can be constructed as either an implicit or an explicit join?

Union Full Inner Cross

2.

How do you enable performance statistics for a SAS Data Integration Studio job?

Define Collect Runtime Statistics on the SAS Data Integration Studio job. Define Collect Table Statistics on the SAS Data Integration Studio job. Define Collect Diagnostics on the SAS Data Integration Studio job. Define Collect Table Statistics on the SAS Data Integration Studio options.

3.

Within SAS Data Integration Studio's SQL Join transformation, the Validate Expression button is located in

a Where clause definition an Expression Builder window a field Expression definition a Subquery definition

4.

Which definition cannot be imported using a SAS Metadata Bridge?

Server definition Library definition Table definition Column Definition

5.

When exporting a SAS package file using SAS Data Integration Studio, where can it be saved?

in metadata on any machine that SAS Data Integration Studio can write to in a SAS catalog only on the machine where SAS Data Integration Studio is running

6.

Which statements are true regarding columns when using SAS Data Integration Studio's New Tables wizard?

You can access metadata for any column from any table already registered in metadata but cannot change it. You can access metadata for any column from any table already registered in metadata and can override the imported information. You can define new columns for the table. You cannot define new columns.

7.

Within SAS Data Integration Studio, automatic mappings are disabled for a job. A transformation has defined source columns and defined target columns. One of the source columns, named COL1, is character with a length of 50. One of the target columns, named COL1, is also character but of length 25. What will happen if the COL1 columns are mapped?

The COL1 columns are successfully mapped, one-to-one, with no warnings. The COL1 columns are not mapped because the lengths are different. The COL1 columns are mapped but an expression is defined for the target COL1 that uses a generic specification of the LENGTH function The COL1 columns are successfully mapped, one-to-one, but a warning occurs.

8.

The profile reports generated in dfPower Profile jobs are viewed

in dfPower Profile (Viewer) in the Reports tab of dfPower Profile (Configurator) in any HTML viewer in any text viewer

9.

A SAS administrator has performed the "Clear Projects" action to remove the lock on a SAS Data Integration Studio job called "Create Tables" that some user has checked out in their project repository. What will be the outcome of this action on the user's project repository?

It will become empty and all new and checked out metadata objects will revert to the not checked out state. It will only contain the new metadata objects. All checked out metadata objects will revert to the not checked out state It will become empty and the DI job called "Create Tables" will no longer be in a checked out state. It will become empty and will not be accessible until the administrator grants permissions for it to be used again

10.

Which statement best describes the DataFlux Integration Server?

An application server that executes service requests based on Simple Object Access Protocol (SOAP) to call dfPower Architect or dfPower Profile jobs. A plug-in to SAS Data Integration Studio allowing you to design jobs specialized for data cleansing operations An application interface that allows you to build dfPower Architect and dfPower Profile jobs specialized for data cleansing operations. . A third party server defined in the SAS metadata repository that allows you to build flows integrating multiple jobs and establishing job dependencies within the flow.

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

SAS DI

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner