Question 1

When working with the CAS (Cloud Analytic Services) using SAS Viya, you need to reference a custom data format that you previously created for a data analytics project. In which location within CAS would you likely store and access this custom format to ensure it can be applied to your datasets during your analysis sessions?

Options :

A : In the caslibs designated for user data

B : In the casuser personal folder

C : In the formats catalog within a specific caslib

D : In the CAS global environment settings

Answer: C

Question 2

A developer needs to store a set of fixed format codes in a database column where each code is exactly 8 characters long. The codes will be used frequently in query predicates and joins. Which data type would be the most appropriate for the developer to use?

Options :

A : CHAR(8)

B : VARCHAR(10)

C : CHAR(10)

D : VARCHAR(8)

Answer: A

Question 3

A data scientist is working on a SAS Viya environment and wants to access data files stored in the default location where personal files are kept when the SAS Viya session starts. Which of the following CASLIB attributes should be considered to directly access these files?

Options :

A : Session

B : Local

C : Active

D : Personal

Answer: D

Question 4

A data scientist wants to create a new variable in a dataset 'monthly_sales' that classifies each observation as "High", "Medium", or "Low" based on the value of 'total_sales'. Which function should be used to accomplish this?

Options :

A : The `IFN()` function

B : The `FLOOR()` function

C : The `CATEGORIZE()` function

D : The `CHOOSE()` function

Answer: A

Question 5

You are designing a stored process in SAS Viya and you need to dynamically pass a table name into a SQL step. Which of the following SAS macro invocations would correctly supply a dataset name to the macro so that it can be used in the SQL step to reference a table parameter named 'myTable'?

Options :

A : %let tableName = 'work.myData'; %myMacro(table=tableName);

B : %let tableName = work.myData; %myMacro(table=tableName);

C : %let tableName = work.myData; %myMacro(table=&tableName;);

D : %let tableName = 'work.myData'; %myMacro(table=&tableName.;);

Answer: C

Confidently Practice Online with Free A00-415 Exam Cram

Buying Options: