SAS DI Set 1

1.

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?

&syslast

syslast

&target

%target

2.

You want to create a table containing all customers from Italy. Assume that global customer order information is available in a single table. Identify the SAS Data Integration Studio transformation that will help you perform the task easily.

Append Extract Lookup Mining Results

3.

You want to create a job that checks conditions for your data before that data is loaded into a data warehouse. The job should be able to detect error conditions
such as missing data or duplicate data and take appropriate actions like registering error conditions in log, etc. Which SAS Data Integration Studio transformation
should you use?

Data Transfer Data Validation Data Quality Data Extract

4.

Within SAS Data Integration Studio, which type of expression can be created using the Expression Builder window in the Where tab of SAS Extract transformation? 1) a SAS expression 2) an SQL expression 3) an XML expression 4) a constant

1 and 2 only 1 and 3 only 1, 2 and 4 only 1, 2, 3, and 4

5.

Which of the following is NOT a feature of SAS Data Integration Studio's Data Validation transformation?

The Data Validation transformation can generate match codes to provide de-duplication capabilities. The Data Validation transformation can perform missing-value detection and invalid-value validation in a single pass of the data. The Data Validation transformation provides de-duplication capabilities The Data Validation transformation provides error-condition handling.

6.

In SAS Data Integration Studio, which statement is FALSE regarding status handling?

When a job is executed in SAS Data Integration Studio, a return code for each transformation in the job is captured in a macro variable. The return code for the job is set to the least successful transformation in the job. SAS Data Integration Studio enables you to associate a return code condition, such as Successful, with an action, such as Send Email. If status handling has been defined for a transformation or the job, a macro definition (and a call to it) will be added to the generated code to check for the specified condition(s) Only one Condition/Action pair can be defined for a single transformation or for a job. The available Condition/Action pairs for transformations and jobs will vary - that is, different Condition/Action pairs may exist for the SQL Join transformation versus the Table Loader transformation.

7.

The Platform Process Manager server is part of the Platform Suite for SAS. Which statement is FALSE regarding the Platform Process Manager server?

The server enables you to schedule jobs using a variety of recurrence criteria and dependencies on other jobs, time events, or file events. The server enables you to schedule jobs using a variety of recurrence criteria but does NOT allow you to specify any type of dependencies The Flow Manager application (part of the Platform Suite for SAS) can be used to manage already scheduled jobs. Metadata for the Platform Process Manager server must be defined and must include the network address or host name of a machine as well as the port number for the server.

8.

After creating a stored process from a SAS Data Integration Studio job, how can you test the stored process to make sure it runs correctly?

Execute the stored process in SAS Data Integration Studio Execute the stored process in SAS Management Console. Execute the stored process using the SAS Add-In for Microsoft Office or SAS Enterprise Guide Execute the stored process using SAS Display Manager's Stored Process Test window.

9.

Which statement regarding scheduling SAS Data Integration Studio jobs is true?

A folder or directory location on a server where the SAS code from a deployed SAS Data integration Studio job is stored A location in the metadata repository where job flows are deployed A location in the SAS Management console job directory storing the metadata for jobs that can be added to job flows A SAS Folder in the Schedule Manager plug-in within SAS Management Console containing listings of all flows organized by server type.

10.

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

the deployment wizard of SAS Data Integration Studio the Scheduling Manager plug-in in SAS Management Console the Scheduling Server the SAS DATA Step Batch Server

SAS DI Set 1

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 Set 1

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