Question 1

A SAS programmer is designing a table that will store customer feedback text of variable lengths. The table needs to efficiently manage space since the lengths of the feedback vary widely. Which of the following column definitions would be the most appropriate for this scenario?

Options :

A : feedback CHAR(500)

B : feedback VARCHAR(500)

C : feedback TEXT

D : feedback STRING

Answer: B

Question 2

A data analyst needs to create a view that includes data from the 'transactions' table but only for the records where the transaction amount is higher than 5000. Which PROC SQL code snippet would allow the analyst to create this view in SAS Viya correctly?

Options :

A : PROC SQL; CREATE VIEW high_value_transactions AS SELECT * FROM transactions WHERE transaction_amount > 5000; QUIT;

B : PROC PRINT; CREATE VIEW high_value_transactions AS SELECT * FROM transactions WHERE transaction_amount > 5000; RUN;

C : DATA high_value_transactions; SET transactions; WHERE transaction_amount > 5000; RUN;

D : PROC SQL; CREATE VIEW high_value_transactions AS SELECT * FROM transactions HAVING transaction_amount > 5000; QUIT;

Answer: A

Question 3

You have developed a SAS Viya application that generates several data visualizations. The visualizations need to be updated periodically based on user interactions. What is the best practice for managing the data and scripts for these visualizations?

Options :

A : Maintain the data and scripts on the server-side, and utilize server processing to update visualizations.

B : Store the scripts on the client-side and push them to the server whenever an update is required.

C : Keep the data on the client-side and transfer it to the server every time a visualization update is triggered.

D : Store visualization scripts on the client-side for easier debugging, and use AJAX calls to pull data from the server as needed.

Answer: A

Question 4

A data scientist is planning to leverage Python code within a SAS Viya environment to enhance their analyses. They want to integrate the Python code so that it can be executed as part of a larger SAS workflow. Which of the following methods allows for seamless integration of Python code in a SAS Viya environment?

Options :

A : Copying and pasting Python code into the SAS Enterprise Guide and executing as a stored process.

B : Using the SASPy library to establish a connection between the Python environment and the SAS session, allowing for the execution of Python code within SAS.

C : Writing Python code into a .sas file and running it as a SAS script.

D : Calling Python scripts via the Command Line from within a SAS program without any direct data transfer between Python and SAS.

Answer: B

Question 5

A database administrator is tasked with removing an obsolete table named "sales_data" from the SAS Viya environment to free up storage space. The administrator needs to ensure that the operation is irreversible and that the table is permanently deleted. Which of the following SQL statements should the administrator use?

Options :

A : PROC SQL; DROP TABLE sales_data; QUIT;

B : PROC SQL; DELETE TABLE sales_data; QUIT;

C : PROC SQL; DROPTABLE sales_data; QUIT;

D : PROC SQL; REMOVE TABLE sales_data; QUIT;

Answer: A