Question 1

As a data analyst, you are tasked with utilizing multiple CAS sessions in your SAS Viya program to segregate various data management tasks. Given that you need to switch between these CAS sessions within the same program, how would you specify a particular session for the DATA step to run in?

Options :

A : proc cas data=mydata; set casdata; sessref=session2; run;

B : data mydata / sessref=session2; set casdata; run;

C : data mydata; set casdata; cas sessref=session2; run;

D : data mydata (sessref=session2); set casdata; run;

Answer: D

Question 2

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 3

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

Question 4

As a data analyst, you are tasked with utilizing multiple CAS sessions in your SAS Viya program to segregate various data management tasks. Given that you need to switch between these CAS sessions within the same program, how would you specify a particular session for the DATA step to run in?

Options :

A : proc cas data=mydata; set casdata; sessref=session2; run;

B : data mydata / sessref=session2; set casdata; run;

C : data mydata; set casdata; cas sessref=session2; run;

D : data mydata (sessref=session2); set casdata; run;

Answer: D

Question 5

You have loaded a data set into a CAS session and need to perform a simple aggregation that summarizes total sales by region. Which of the following CAS actions allows you to do this most efficiently?

Options :

A : table.loadTable

B : simple.sum

C : aggregation.aggregate

D : fedSql.execDirect

Answer: C

Free A00-420 Mock Exam – Practice Online Confidently

Buying Options: