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

What is the correct way to use the CAS library to save the results of a procedure in SAS Viya?

Options :

A : Use a DATA step with the CASLIB statement to specify the target CAS library where the results should be saved.

B : Use the PROC COPY command with the TO= and FROM= options to move result tables to a specified CAS library.

C : Assign a libref to the desired CAS library and then specify that libref in the OUT= option of the procedure.

D : Result tables are automatically saved to the CAS library assigned to the user at login and no additional steps are required.

Answer: C

Question 3

A data analyst is using the fedSQL action set to combine data from separate tables stored in a distributed environment. They want to perform a left join on two tables, 'customers' and 'orders', based on the customer ID. Which of the following fedSQL statements accomplishes this?

Options :

A : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers INNER JOIN orders ON customers.customer_id = orders.customer_id; QUIT;

B : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers LEFT JOIN orders ON customers.id = orders.customer_id; QUIT;

C : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers t1 LEFT JOIN orders t2 ON t1.customer_id = t2.customer_id; QUIT;

D : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers FULL JOIN orders ON customers.customer_id = orders.customer_id; QUIT;

Answer: C

Question 4

When using the dataStep action set in SAS Viya, you need to create a new table that includes a calculated column based on conditional processing of other columns in the data. Which of the following OPTIONS correctly demonstrates how to create a new variable that assigns a value of 'High' if the variable 'Sales' is above 1000 and 'Low' if 'Sales' is 1000 or below using the dataStep.runCode action?

Options :

A : datastep.runCode / code="data newTable; set oldTable; if Sales > 1000 then Sales_Level = 'High'; else Sales_Level = 'Low'; run;";

B : datastep.runCode / code="data newTable; set oldTable; if Sales then if Sales > 1000 then Sales_Level = 'High'; else Sales_Level = 'Low'; run;";

C : datastep.runCode / code="proc newTable; set oldTable; if Sales > 1000 then Sales_Level = 'High'; else Sales_Level = 'Low'; end;";

D : datastep.runCode / code="data newTable; set oldTable; if Sales > 1000 then do; Sales_Level = 'High'; end; else do; Sales_Level = 'Low'; end; run;";

Answer: A

Question 5

You are working with a large, partitioned dataset in a CAS session and you want to ensure that a PROC MEANS calculation is performed in parallel across all data partitions to enhance performance. Which option would you use to accomplish this?

Options :

A : Use the PARTBY statement in the PROC MEANS code to specify the variable that defines the data partitions.

B : Explicitly define a BY statement and sort the data by the partitioning variable before calling PROC MEANS.

C : Use the NWAY option in the PROC MEANS code to enforce group processing only on the class variables.

D : Implement an ORDER BY clause in a preceding PROC SQL step to arrange the data by partitions.

Answer: A

Higher Test Marks with Free Online A00-420 Exam Practice

Buying Options: