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

2:** Imagine you are performing data analysis in SAS Viya and you have created several in-memory tables in your session. After performing your analysis, you decide to drop all the in-memory tables you have created to free up resources. Which of the following CAS actions allows you to drop an in-memory table named 'sessionData'?

Options :

A : table.dropTable / name='sessionData';

B : drop / table='sessionData';

C : table.drop / name='sessionData';

D : endSession / dropTables=true;

Answer: C

Question 4

A programmer is using the SAS Viya environment for analysis and needs to write output data to a secured location that multiple users can access. The location is on a server where permissions are managed through access control lists. How should the programmer reference the secured location for the output data to ensure that the correct access controls are applied?

Options :

A : Reference the secured location directly within the DATA step using a filename with a hardcoded path and set the file permissions using the X command after the DATA step.

B : Use the LIBNAME statement with appropriate engine options to dynamically assign a libref to the secured location, ensuring it complies with established access control lists.

C : Ignore server permissions and use the CAS engine-s default settings for output data location, relying on SAS Viya-s internal security model to manage file permissions.

D : Manually copy the output data to the secured location using an operating system command after the completion of the SAS job.

Answer: B

Question 5

A programmer wants to accumulate the total sales for each month in a dataset named 'monthly_sales' that has two variables: 'month' and 'sales'. Which DATA Step code properly accumulates the total sales for each month?

Options :

A : data totals;set monthly_sales;retain total_sales;total_sales + sales;run;

B : data totals;set monthly_sales;by month;if first.month then total_sales=0;total_sales + sales;if last.month then output;run;

C : data totals(drop=month);set monthly_sales;total_sales + sales;output;run;

D : data totals;set monthly_sales;retain total_sales 0;total_sales + sales;output;run;

Answer: B

Higher Test Marks with Free Online A00-415 Exam Practice

Buying Options: