Question 1

You are working on a project where multiple in-memory tables have been created during a CAS session using SAS Viya. As part of memory management, you've been asked to remove a specific table, 'sales_data', from memory. Which of the following code snippets correctly uses the table.dropTable action to accomplish this task?

Options :

A : cas.table.dropTable(caslib='casuser', name='sales_data')

B : proc cas; table.dropTable / caslib='casuser' name='sales_data'; quit;

C : table.dropTable / table='casuser.sales_data';

D : dropTable 'casuser.sales_data';

Answer: B

Question 2

You have a CAS table named "sales_data" and you want to use the ALTERTABLE CASDATA statement in SAS Viya to change the data type of the column "total_sales" from varchar to double. Assuming the column "total_sales" exists and originally contains character data representing numeric values, which of the following statements would correctly alter the column data type?

Options :

A : ALTER TABLE CASDATA.sales_data MODIFY COLUMN total_sales SET TYPE double;

B : ALTER TABLE CASDATA.sales_data ALTER COLUMN total_sales TYPE double;

C : ALTER TABLE CASDATA.sales_data CHANGE COLUMN total_sales total_sales double;

D : ALTER TABLE CASDATA.sales_data MODIFY total_sales TYPE TO double;

Answer: B

Question 3

You are working on a project with a dataset named `sales` in the SAS Viya environment. You have been tasked to create a new dataset `luxury_sales` that includes records of luxury items with a price greater than $10,000. You decide to use the `WHERE=` subparameter in your code to filter the dataset. What is the correct way to apply the `WHERE=` subparameter to achieve this?

Options :

A : PROC COPY DATA=sales OUT=luxury_sales WHERE=(price > 10000);

B : DATA luxury_sales; SET sales (WHERE=(price > 10000)); RUN;

C : PROC SORT DATA=sales; BY price; WHERE price > 10000; OUTPUT OUT=luxury_sales; RUN;

D : PROC SQL; CREATE TABLE luxury_sales AS SELECT * FROM sales WHERE price > 10000; RUN;

Answer: B

Question 4

An analyst is using fedSQL to write a query that requires case-sensitive string comparison between two columns, 'user_name' from the 'user_accounts' table and 'login' from the 'login_attempts' table. Given that the database is case-insensitive by default, which of the following code snippets would correctly perform a case-sensitive comparison?

Options :

A : SELECT * FROM user_accounts INNER JOIN login_attempts ON user_accounts.user_name = login_attempts.login;

B : SELECT * FROM user_accounts INNER JOIN login_attempts ON BINARY user_accounts.user_name = login_attempts.login;

C : SELECT * FROM user_accounts INNER JOIN login_attempts ON STRCMP(user_accounts.user_name, login_attempts.login) = 0;

D : SELECT * FROM user_accounts INNER JOIN login_attempts ON UPPER(user_accounts.user_name) = UPPER(login_attempts.login);

Answer: B

Question 5

When setting up a data step in a SAS Viya environment, your code needs to read a database table hosted on a remote server, which is registered as a library in SAS Viya's library manager. What would be the appropriate LIBNAME statement to ensure that your data step can access this table?

Options :

A : libname mylib base 'server_path_to_data';

B : libname mylib meta LIBRARY="RemoteServerLib";

C : libname mylib sasiohttp HOSTNAME="remoteserver.com";

D : libname mylib v9 'server_path_to_data';

Answer: B

Confidently Practice Online with Free A00-420 Exam Cram

Buying Options: