Free SAS Institute A00-420 Exam Questions

Which of the following components is responsible for managing user sessions and ensuring that the processing of SAS tasks is distributed effectively across the SAS Viya environment?

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?

In a multi-session SAS Viya environment, a data analyst needs to execute a DATA step that assigns a permanent library using the LIBNAME statement. The analyst needs to ensure that the dataset created within the DATA step is available in the assigned library for all subsequent sessions. Which DATA statement option should the analyst use to specify the session where the library and dataset will be accessible?

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?

A SAS programmer wants to delete certain observations from a data set 'sales' where the 'product_code' is '1234'. The data set is indexed by 'product_code'. Which combination of statements is the most efficient way to accomplish this task?