Q1. Select the valid reasons for using SAS Data Integration Studio's Table Loader transformation. (Choose two.)
A.Create and replace permanent tables.
B. Maintain access privileges to permanent tables.
C. Apply and maintain constraints on permanent tables.
D. Delete and remove permanent tables.
Correct Answer: C, D
Q2. 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
Correct Answer: A
Q3. When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?
A.the old record is deleted and the changed record is added
B. the old record is updated with the new values from the changed record
C. the old record is flagged and the changed record is added
D. the old record is merged with the changed record
Correct Answer: C
Q4. Registering metadata for an ODBC data source involves registering:
A.a library that will use a SASIACCESS engine to a specific database
B. only an ODBC data source definition
C. a server definition that points to the ODBC data source and a library accessing this server definition
D. a table pointing directly to the ODBC data source
Correct Answer: C
Q5. Within SAS Data Integration Studio, how is the internal code of a SAS Code transformation assigned to its options?
A.SAS macro variables
B. columns of SAS datasets
C. SAS formats
D. SAS macro calls
Correct Answer: A
$ 39
Reviews
There are no reviews yet.