Question 1

When a user submits a PROC MEANS in a SAS Viya environment, the procedure is automatically directed to run in a specific execution context based on the data's location. Assuming the PROC MEANS is using a dataset that resides within the CAS server, where will the code execute?

Options :

A : The code will execute locally on the user-s machine.

B : The code will execute on the SAS Viya compute server accessing the data via implicit SQL pass-through.

C : The code will execute within the CAS server where the dataset resides.

D : The code execution will prompt the user to choose the execution environment. E. The code will execute within the SAS Viya environment, but the exact location will be determined by the network latency.

Answer: C

Question 2

When using the SIMPLE action set in SAS Viya to calculate summary statistics for a given dataset, which of the following actions would you use to obtain the mean, sum, minimum, and maximum of a numeric variable?

Options :

A : simple.summary

B : simple.describe

C : simple.statistics

D : simple.aggregate

Answer: B

Question 3

A data analyst is working on a series of data transformations in a SAS Viya environment. They create an in-memory table called 'work.session_data' to use in their session. Later, the analyst decides that this table should be used across multiple sessions and by other users as well. Which of the following steps should the analyst take to ensure that 'session_data' is accessible globally?

Options :

A : Use the 'save' statement to write 'work.session_data' to a permanent location.

B : Use the PROC DATASETS procedure to move 'work.session_data' to the 'public' library.

C : Promote 'work.session_data' using the 'table.promote' task in SAS Viya.

D : Rename 'work.session_data' to 'global.session_data' to automatically promote the table.

Answer: C

Question 4

An analyst is developing a data manipulation task that involves sorting a large dataset and merging it with another. Given two environments, one using serial processing and the other using parallel processing, which of the following statements would be true regarding performance expectations?

Options :

A : Sorting and merging would take longer in the parallel processing environment, as these tasks are I/O intensive.

B : There would be no difference in performance between the two environments as the types of operations involved do not benefit from parallel execution.

C : Sorting and merging would be faster in the serial processing environment due to the simpler nature of the computation.

D : Sorting and merging would benefit from the parallel processing capabilities leading to potential decreases in execution time.

Answer: D

Question 5

When analyzing the time between customer purchases, a data analyst needs to extract the month from a date variable 'purchase_date' in the SAS Viya environment. Which function can be appropriately used to extract the month component from the date?

Options :

A : `DATEPART()`

B : `MONTH()`

C : `DAY()`

D : `EXTRACT()`

Answer: B