Question 1

You are designing a table to store customer information for a loyalty program. One of the fields is 'BirthDate,' which stores the date of birth of each customer. What data type should you assign to 'BirthDate' to ensure proper date operations can be performed?

Options :

A : Char

B : Numeric

C : Date

D : VARCHAR

Answer: C

Question 2

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 3

When working with the CAS procedure PROC CASUTIL to load data into the CAS server, what is the effect of setting the DATALIMIT= option to a specific value, such as DATALIMIT=100?

Options :

A : It specifies that only the first 100 bytes of the data set should be loaded.

B : It sets the limit for the maximum number of variables to be included in the output table in the CAS server.

C : It imposes a restriction on the number of observation rows to be processed by the CAS action.

D : It controls the maximum number of characters for string variables to be loaded into the CAS server.

Answer: C

Question 4

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 5

You are utilizing the TABLE action set in SAS Viya for a data manipulation task that requires you to append new rows to an existing table. Which TABLE action would you employ to accomplish this, and what is the important option or parameter to ensure new rows are appended correctly?

Options :

A : The 'appendTo' action with the 'casOut' parameter.

B : The 'table.addRows' action with the 'set' parameter.

C : The 'append' action with the 'source' parameter.

D : The 'update' action with the 'set' parameter.

Answer: A