Practice A00-415 Exam Online

Question 1

A database administrator is tasked with removing an obsolete table named "sales_data" from the SAS Viya environment to free up storage space. The administrator needs to ensure that the operation is irreversible and that the table is permanently deleted. Which of the following SQL statements should the administrator use?

A : PROC SQL; DROP TABLE sales_data; QUIT;

B : PROC SQL; DELETE TABLE sales_data; QUIT;

C : PROC SQL; DROPTABLE sales_data; QUIT;

D : PROC SQL; REMOVE TABLE sales_data; QUIT;

Answer: A

Question 2

When using the CASUSER caslib in a SAS Viya environment, which of the following statements is correct regarding data accessibility?

A : Data in the CASUSER caslib is private to each individual user and is deleted after the user-s session ends.

B : All users share the same CASUSER caslib, which allows for easy data sharing across the SAS Viya environment.

C : Data in the CASUSER caslib is replicated across all nodes in the CAS cluster to ensure high availability.

D : The CASUSER caslib is read-only, and users can only import data to other caslibs.

Answer: A

Question 3

You are using the SIMPLE action set in a data analysis task and want to perform a data transformation by applying a mathematical formula to a variable in your dataset. Which action would allow you to create a new variable with these transformed values?

A : simple.transmute

B : simple.compute

C : simple.modify

D : simple.impute

Answer: A

Question 4

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?

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

Question 5

You are designing a stored process in SAS Viya and you need to dynamically pass a table name into a SQL step. Which of the following SAS macro invocations would correctly supply a dataset name to the macro so that it can be used in the SQL step to reference a table parameter named 'myTable'?

A : %let tableName = 'work.myData'; %myMacro(table=tableName);

B : %let tableName = work.myData; %myMacro(table=tableName);

C : %let tableName = work.myData; %myMacro(table=&tableName;);

D : %let tableName = 'work.myData'; %myMacro(table=&tableName.;);

Answer: C

Name:	SAS Viya Fundamentals of Programming
Exam Code:	A00-415
Certification:	SAS Foundation
Vendor:	SAS Institute
Total Questions:	155
Last Updated:	Feb 10, 2026

SAS Institute A00-415 Answers