Question 1

You are analyzing a dataset 'customer_data' using SAS Viya, where you have a categorical variable 'purchase_category' that represents the category of items each customer has purchased. You want to determine the distribution of customers across different purchase categories using the freq action in SAS Viya. Which of the following code snippets correctly achieves this?

Options :

A : proc freq data=customer_data; tables purchase_category; run;

B : proc means data=customer_data; class purchase_category; run;

C : proc cas; freq / table=customer_data var="purchase_category"; run;

D : data customer_data; set freq; by purchase_category; run;

Answer: C

Question 2

When working with the CAS (Cloud Analytic Services) using SAS Viya, you need to reference a custom data format that you previously created for a data analytics project. In which location within CAS would you likely store and access this custom format to ensure it can be applied to your datasets during your analysis sessions?

Options :

A : In the caslibs designated for user data

B : In the casuser personal folder

C : In the formats catalog within a specific caslib

D : In the CAS global environment settings

Answer: C

Question 3

A developer needs to store a set of fixed format codes in a database column where each code is exactly 8 characters long. The codes will be used frequently in query predicates and joins. Which data type would be the most appropriate for the developer to use?

Options :

A : CHAR(8)

B : VARCHAR(10)

C : CHAR(10)

D : VARCHAR(8)

Answer: A

Question 4

A data analyst needs to create a view that includes data from the 'transactions' table but only for the records where the transaction amount is higher than 5000. Which PROC SQL code snippet would allow the analyst to create this view in SAS Viya correctly?

Options :

A : PROC SQL; CREATE VIEW high_value_transactions AS SELECT * FROM transactions WHERE transaction_amount > 5000; QUIT;

B : PROC PRINT; CREATE VIEW high_value_transactions AS SELECT * FROM transactions WHERE transaction_amount > 5000; RUN;

C : DATA high_value_transactions; SET transactions; WHERE transaction_amount > 5000; RUN;

D : PROC SQL; CREATE VIEW high_value_transactions AS SELECT * FROM transactions HAVING transaction_amount > 5000; QUIT;

Answer: A

Question 5

A programmer needs to execute a series of data preparation steps that rely on traditional SAS data set access, manipulation, and reporting procedures, and some steps are highly I/O intensive due to the data size. Based on these requirements, which environment should the programmer choose for the execution of this code?

Options :

A : The Compute Server, to utilize the traditional SAS programming environment

B : The CAS environment, to benefit from its in-memory processing power

C : The client machine, because I/O intensive tasks are best handled locally

D : The execution environment does not matter as long as enough memory is allocated

Answer: A