Question 1

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 2

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

Question 3

When using PROC MEANS to summarize data, a programmer needs to display only the variables "Time", "Distance", and "Speed" from a dataset, while also calculating the mean and standard deviation for those variables. Which of the following VAR statements is the most efficient way to achieve this while maintaining the original order in the dataset?

Options :

A : `proc means data=work.RunData mean std; var Time Distance Speed; run;`

B : `proc means data=work.RunData mean std; var Speed Distance Time; run;`

C : `proc means data=work.RunData; var Time Speed; run;`

D : `proc means data=work.RunData; run;`

Answer: A

Question 4

As a data analyst, you are tasked with utilizing multiple CAS sessions in your SAS Viya program to segregate various data management tasks. Given that you need to switch between these CAS sessions within the same program, how would you specify a particular session for the DATA step to run in?

Options :

A : proc cas data=mydata; set casdata; sessref=session2; run;

B : data mydata / sessref=session2; set casdata; run;

C : data mydata; set casdata; cas sessref=session2; run;

D : data mydata (sessref=session2); set casdata; run;

Answer: D

Question 5

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

Confidently Practice Online with Free A00-420 Exam Cram

Buying Options: