Question 1

You have a CAS table named "sales_data" and you want to use the ALTERTABLE CASDATA statement in SAS Viya to change the data type of the column "total_sales" from varchar to double. Assuming the column "total_sales" exists and originally contains character data representing numeric values, which of the following statements would correctly alter the column data type?

Options :

A : ALTER TABLE CASDATA.sales_data MODIFY COLUMN total_sales SET TYPE double;

B : ALTER TABLE CASDATA.sales_data ALTER COLUMN total_sales TYPE double;

C : ALTER TABLE CASDATA.sales_data CHANGE COLUMN total_sales total_sales double;

D : ALTER TABLE CASDATA.sales_data MODIFY total_sales TYPE TO double;

Answer: B

Question 2

When using SAS Viya, you want to perform a linear regression analysis on a dataset stored in the cloud. You decide to use an action from the 'regression' action set. Which of the following actions should you invoke to perform this task using a CAS session?

Options :

A : table.loadTable

B : simpleReg

C : regression.linear

D : fedSql.execDirect

Answer: C

Question 3

When performing a data manipulation task using the simple action set in SAS Viya, you need to group the data by the 'region' variable and then calculate the total sales for each region. Which action should you use to accomplish this task within the simple action set?

Options :

A : simple.groupby

B : aggregation.groupby

C : simple.summary

D : simple.aggregate

Answer: D

Question 4

Which of the following is a true statement regarding variable scope in CASL?

Options :

A : Global variables declared outside of any function or action block are accessible only within the same script and cannot be accessed by other scripts or sessions.

B : CASL does not support local variables; all variables are global and can be accessed from any part of the program.

C : Variables in CASL are dynamically typed, and their scope is determined at runtime based on the execution context.

D : Local variables in CASL can be accessed and modified by any other blocks of code within the same action set.

Answer: A

Question 5

A SAS Viya data analyst is tasked with selecting a random subset of data from a dataset called 'CustomerData', which contains over 1 million records. The requirement is to analyze a manageable subset without any bias. How should the analyst use the 'subSet=' parameter in a procedure to ensure a random selection?

Options :

A : PROC SURVEYSELECT DATA=CustomerData subSet=/METHOD=SRS SAMPRATE=0.01 OUT=SampleData;

B : PROC SURVEYSELECT DATA=CustomerData METHOD=SRS SAMPRATE=0.01 OUT=SampleData;

C : PROC SURVEYSELECT DATA=CustomerData subSet=(RANDOM 0.01) OUT=SampleData;

D : PROC SURVEYSELECT DATA=CustomerData / subSet=(RANDOM 0.01) OUT=SampleData;

Answer: B