Question 1

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

Question 2

When a user begins a new SAS Viya session, what is the default behavior for the CASUSER caslib with respect to data management?

Options :

A : The CASUSER caslib is preloaded with common datasets available to all users for convenience.

B : The CASUSER caslib retains all data from previous user sessions for continuity unless manually cleared.

C : The CASUSER caslib starts empty and is intended to temporarily store session-specific data which is cleansed after the session ends.

D : The CASUSER caslib automatically archives user data to a permanent storage solution when the session is closed.

Answer: C

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

A data analyst needs to run a data manipulation task that involves sorting a table by multiple columns, then creating a new column based on a conditional statement. Which of the following sets of actions should be used in the given scenario when programming in SAS Viya?

Options :

A : table.loadTable followed by table.sortTable and then table.addTable

B : table.loadTable followed by table.sort and then column.addDerivedColumn

C : table.fetch followed by column.sort and then column.addCondition

D : fedSql.execDirect for the entire manipulation in a single step

Answer: B

Question 5

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

Confidently Practice Online with Free A00-415 Exam Cram

Buying Options: