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 created a data table 'work.sales_data' using SAS procedures and want to use the 'table.save' method to store this data table permanently in the 'mydata' library. Which of the following code snippets correctly accomplishes this task, assuming that the 'mydata' library has already been assigned?

Options :

A : proc cas; table.save / table=work.sales_data caslib=mydata name="SalesDataPermanent"; run;

B : table.save / source=work.sales_data target=mydata.SalesDataPermanent; run;

C : saveTable / from=work.sales_data to=mydata.SalesDataPermanent; quit;

D : data mydata.SalesDataPermanent; set work.sales_data; run; quit;

Answer: A

Question 3

When working in a SAS Viya environment, a programmer intends to save a series of informats and formats so that they are shared across various sessions and persisted beyond the current session. They specify the CASFMTLIB= option in their PROC FORMAT code. Which of the following is a result of executing this code with the CASFMTLIB= option set?

Options :

A : The informats and formats are saved to the specified caslib and can be shared across sessions, but they are not persistent after the session ends.

B : The new informats and formats are only available to the current session and must be recreated in subsequent sessions.

C : The informats and formats are saved to the specified caslib and are persistent, meaning they are available to subsequent sessions without needing to be recreated.

D : The CAS session is terminated, and all informats and formats are saved to sashelp library.

Answer: C

Question 4

A data analyst is using the fedSQL action set to combine data from separate tables stored in a distributed environment. They want to perform a left join on two tables, 'customers' and 'orders', based on the customer ID. Which of the following fedSQL statements accomplishes this?

Options :

A : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers INNER JOIN orders ON customers.customer_id = orders.customer_id; QUIT;

B : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers LEFT JOIN orders ON customers.id = orders.customer_id; QUIT;

C : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers t1 LEFT JOIN orders t2 ON t1.customer_id = t2.customer_id; QUIT;

D : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers FULL JOIN orders ON customers.customer_id = orders.customer_id; QUIT;

Answer: C

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: