Free Practice SAS Institute A00-420 Exam Questions 2025

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?

You are required to modify an existing table named "sales_data" by adding a new column titled "discount_amount" that will store numerical values representing the discount given for each sale. Which of the following ALTER TABLE statements would correctly add the required column?

What is the correct way to use the CAS library to save the results of a procedure in SAS Viya?

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?

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?