問題1
Which CASL program correctly adds the Sales caslib to access data in the /data/sales folder?
Which CASL program correctly adds the Sales caslib to access data in the /data/sales folder?
正確答案: B
問題2
You want to generate totals and averages by year for a very large Teradata table using SAS Viya programming methods.
What is the most efficient way to achieve this?
You want to generate totals and averages by year for a very large Teradata table using SAS Viya programming methods.
What is the most efficient way to achieve this?
正確答案: A
問題3
Which CAS action is used to perform data quality checks on variables in a CAS table?
Which CAS action is used to perform data quality checks on variables in a CAS table?
正確答案: D
問題4
Which CAS server component distributes data and code for processing?
Which CAS server component distributes data and code for processing?
正確答案: D
問題5
Which programming language is primarily used in CAS?
Which programming language is primarily used in CAS?
正確答案: C
問題6
What data types does FedSQL support in CAS?
What data types does FedSQL support in CAS?
正確答案: D
問題7
Which CAS action is used to load data from an external file into a CAS table?
Which CAS action is used to load data from an external file into a CAS table?
正確答案: A
問題8
How can you define a user-defined format in SAS?
How can you define a user-defined format in SAS?
正確答案: D
問題9
Which SAS Viya component provides self-service data preparation capabilities?
Which SAS Viya component provides self-service data preparation capabilities?
正確答案: A
問題10
Which DATA step statement is used to merge two or more CAS tables based on a common key variable?
Which DATA step statement is used to merge two or more CAS tables based on a common key variable?
正確答案: D
問題11
Which CAS-enabled procedure is used to perform time series analysis on CAS tables?
Which CAS-enabled procedure is used to perform time series analysis on CAS tables?
正確答案: A
問題12
Given the CAS table casuser.shoes and the following SAS program:
data casuser.shoes2(where=(region="Africa" and Product="Slipper"));
set casuser.shoes;
keep Region Product Sales;
run;
Which statement is true?
Given the CAS table casuser.shoes and the following SAS program:
data casuser.shoes2(where=(region="Africa" and Product="Slipper"));
set casuser.shoes;
keep Region Product Sales;
run;
Which statement is true?
正確答案: C
問題13
Complete the following FedSQL code to convert the character variable markup to a numeric variable.
proc cas;
session mysess;
fedSql.execDirect /
query="create table casuser.cars_fedsql {options replace=true} as
select make, model, mpg_city, mpg_highway, <insert code segment here> as markup_N from casuser.cars"; run;
Complete the following FedSQL code to convert the character variable markup to a numeric variable.
proc cas;
session mysess;
fedSql.execDirect /
query="create table casuser.cars_fedsql {options replace=true} as
select make, model, mpg_city, mpg_highway, <insert code segment here> as markup_N from casuser.cars"; run;
正確答案: C
問題14
Which CAS action is used to merge two or more CAS tables based on common variables?
Which CAS action is used to merge two or more CAS tables based on common variables?
正確答案: B