Question 1

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?

Options :

A : SAS Event Stream Processing (ESP)

B : SAS Micro Analytic Service (MAS)

C : SAS Environment Manager

D : SAS Cloud Analytic Services (CAS)

Answer: D

Question 2

A SAS Viya data analyst is tasked with selecting a random subset of data from a dataset called 'CustomerData', which contains over 1 million records. The requirement is to analyze a manageable subset without any bias. How should the analyst use the 'subSet=' parameter in a procedure to ensure a random selection?

Options :

A : PROC SURVEYSELECT DATA=CustomerData subSet=/METHOD=SRS SAMPRATE=0.01 OUT=SampleData;

B : PROC SURVEYSELECT DATA=CustomerData METHOD=SRS SAMPRATE=0.01 OUT=SampleData;

C : PROC SURVEYSELECT DATA=CustomerData subSet=(RANDOM 0.01) OUT=SampleData;

D : PROC SURVEYSELECT DATA=CustomerData / subSet=(RANDOM 0.01) OUT=SampleData;

Answer: B

Question 3

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 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

You are given a raw data file with a variable that contains currency amounts, including a dollar sign, commas, and decimal points (e.g., "$1,234.56"). You need to create a new SAS dataset and ensure that these amounts are read as numeric values without the currency formatting. Which informat would appropriately read the variable as a numeric value?

Options :

A : COMMAw.d

B : DOLLARw.d

C : NUMERICw.d

D : DOLLARw.

Answer: A

Confidently Practice Online with Free A00-420 Exam Cram

Buying Options: