SAS A00-260 Quiz 1 Topic 7 Questions 1-5

Question: 1

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

Aland2only

Bland3only

C1,2and4only

D1,2,3,and4

Show Answer

Question: 2

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

Aa Where clause definition

Ban Expression Builder window

Cafield Expression definition

Da Subquery definition

Show Answer

Question: 3

The SAS Data Integration Studio SCD Type 2 Loader transformation can do which of the following?

Agenerate cpu statistics

Bgenerate a datetime value

Cgenerates cluster numbers

Dgenerates standardization values

Show Answer

Question: 4

When using the Table Loader transformation in SAS Data Integration Studio to update an existing table containing indexes or constraints, which statement is true?

AYou can control the removal and/or creation of indexes and constraints in the target table only if you are using a Load style other than Replace.

BYou can control the removal and/or creation of indexes and constraints in the target table for all Load Styles.

CIf using the Append to Existing load style, indexes and constraints can be added but not removed.

DFor the Update/Insert load style it is possible to remove indexes not required for the Update/Insert processing, but no indexes can be added.

Show Answer

Question: 5

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:

ASAS Information Delivery Portal

BSAS Information Map Studio

CSAS Web Report Studio

DSAS OLAP Cube Studio

Show Answer

SAS A00-260 Quiz:1 Topic:7 Questions:1-5