EMT Practice Test

1. Question Content...

---

Question1: Which statement will show all available caslibs in the log?

Question2: Which PROC MDSUMMARY step produces results?

Question3: Which operator is used for assignment in SAS Viya?

Question4: Which statement is true about the CAS server?

Question5: Given an array cars with an unknown number of elements, use a CASL function to complete the following program segment to complete the DO loop:
do i=1 to _________
;
print cars[i];
end;

Question6: What is the purpose of the VALUE statement in PROC FORMAT?

Question7: Which SAS Viya component is responsible for executing CAS-enabled procedures?

Question8: Which statement will display column name, type, label and format information for the clientes table in the casuser caslib?

Question9: In PROC CASUTIL, what does the LOAD FILE= statement do?

Question10: Which CAS action is used to generate a summary report of missing values in a CAS table?

Question11: Which CAS action is used to generate a random sample from a CAS table?

Question12: Which statement is true about the order of the rows in an output table produced by a DATA step running in CAS?

Question13: Which CAS-enabled procedure is used to perform market basket analysis?

Question14: Which of the following statements about the CAS server is true?

Question15: Which CAS action is used to load data into the CAS environment?

Question16: If a dictionary named res contains a table named fetch, which statement will print the table?

Question17: Which DATA step function is supported in CAS?

Question18: What is the primary advantage of using CAS-enabled procedures in SAS?

Question19: Which CAS action is used to create a new variable in the DATA step?

Question20: Which CAS action is used to select specific columns from a CAS table?

Question21: Which CAS action is used to merge two or more CAS tables based on a common key variable?

Question22: Which SQL clause is used to filter rows in a CAS table based on specified conditions?

Question23: Which CAS action is used to split a string variable into multiple variables based on a delimiter in a CAS table?

Question24: What is the purpose of the SET action in CAS language programming?

Question25: Which CAS action is used to rename variables in a CAS table?

Question26: Using the altertable action, which is the correct statement to rename the make column to veh_make in a CAS table?
proc cas;
table.altertable / caslib="casuser", name="cars",
<enter code segment here>;
quit;

Question27: Which CAS action is used to compute the frequency distribution of a categorical variable in a CAS table?

Question28: Which procedure can run in CAS?

Question29: Which CAS action is used to validate the integrity of relationships between variables in a CAS table?

Question30: Which program will display ODS output?

Question31: Which programming language is used in the DATA step of SAS CAS?

Question32: In which situation is it best to leverage the CAS server?

Question33: Which CAS action is used to create a new CASLIB?

Question34: Given that this program:
simple.numRows /
table={caslib="casuser",name="cars"};
produces this output in the Log:
{numrows=428}
Which program produces the following output in the Log?
Table casuser.cars has 428 rows.

Question35: Which PROC CASUTIL step suppresses error messages if the table is not found in-memory?

Question36: Which DATA step feature is NOT supported in CAS?

Question37: Which SAS Viya procedure is used for statistical modeling and regression analysis?

Question38: How can you define a user-defined format in SAS?

Question39: Which CAS action is used to perform a join operation between two CAS tables based on a common key variable?

Question40: Which statement is FALSE regarding loading data into CAS?

Question41: Which CAS-enabled procedure is used for regression analysis and modeling?

Question42: Which CAS action is used to calculate the mode(s) of a categorical variable in a CAS table?

Question43: Which CAS action is used to sort data based on one or more variables?

Question44: Which CASL program correctly runs two DATA step programs that are stored in separate source blocks named Program1 and Program2?

Question45: Which program will successfully load cars.csv from the casuser caslib data source to an in-memory table named cars?

Question46: How can you view the contents of a CAS table?

Question47: What is the syntax for submitting a SAS Viya program in SAS Studio?

Question48: When loading a data set into memory using PROC CASUTIL and the LOAD statement, what option will set the in-memory table's scope to GLOBAL?
Enter your answer in the space below: _________

Question49: Which CAS action is used to identify potential duplicate records in a CAS table?

Question50: Which data format should be used when saving a CAS table so that it will later load into CAS memory the fastest?

Question51: What is the purpose of the SAS Explorer in SAS Studio?

Question52: Which CAS-enabled procedure is used to perform decision tree analysis on CAS tables?

Question53: Which CAS-enabled procedure is used to create user-defined formats?

Question54: Which SAS Viya component is used for creating interactive dashboards and reports?

Question55: Select the correct way to define formats and labels in a FedSQL CREATE TABLE statement.

Question56: The table casuser.employees is partitioned onto 3 CAS worker nodes.
Which SAS program will correctly accumulate a total of the salary variable and store it in the variable totalSalary?

Question57: What is the purpose of the GROUP BY clause in SQL programming?

Question58: What is the purpose of the LIBNAME statement in SAS Viya?

Question59: Which statement is used to define a user-defined format in SAS Viya?

Question60: Which CAS action is used to calculate the frequency distribution of a categorical variable in a CAS table?

Question61: Which CAS action is used to recode the values of a categorical variable in a CAS table?

Question62: What is the purpose of the BY statement in CAS language programming?

Question63: In SAS Viya, what is the purpose of the SAS Studio application?

Question64: What is the purpose of the BY statement in the DATA step?

Question65: Which statement is used to create a new variable in SAS Viya?

Question66: Which CAS action is used to perform data profiling to analyze the distribution of values in a CAS table?

Question67: Which CAS action is used to compute the frequency count of unique values in a column of a CAS table?

Question68: Which CAS action is used to perform data transformations, such as creating new variables or modifying existing variables?

Question69: What is a CASLIB in CAS?

Question70: Which programming language is primarily used in CAS?

Question71: Which Compute Server system option prevents inadvertently moving large in-memory tables to the Compute Server?

Question72: Which SAS program will list tables contained in caslib public?

Question73: Which action loads the cars.csv file from the casuser caslib into memory?

Question74: Which CASL program correctly adds the Sales caslib to access data in the /data/sales folder?

Question75: You want to use the MEANS procedure to summarize data using the CAS server.
Which statement is true?

Question76: Which DATA step statement is used to merge two or more CAS tables based on a common key variable?

Question77: Which CAS statement is used to assign a CAS table to a CAS library?

Question78: Which DATA step will NOT run in CAS?

Question79: Which PROC TRANSPOSE step will execute entirely in CAS?

Question80: Which CAS-enabled procedure is used for data exploration and visualization?

Question81: Complete the CASL statement below to save the result stored in r to a SAS data set named class in the mylib library.
saveresult r _________ =mylib.class;

Question82: Which CAS-enabled procedure allows the creation of user-defined formats?

Question83: In SQL programming, which statement is used to filter rows based on conditions?

Question84: Which CAS action is used to calculate the standard deviation, variance, and range for numeric variables in a CAS table?

Question85: Which CAS action is used to aggregate data at a higher level of granularity in a CAS table?

Question86: What is a CAS table in CAS?

Question87: Which action from the table action set lists the files in a caslib's data source?

Question88: Which CAS action is used to execute a DATA step program in SAS CAS?

Question89: Which statement is used to apply a user-defined format within a PROC SQL query?

Question90: Which PROC CASUTIL step correctly saves a CSV file in the casuser caslib and overwrites any files with the same name?

Question91: Which CAS action is used to calculate the frequency and percentage of values for categorical variables in a CAS table?

Question92: Which PROC CASUTIL statement successfully applies the regnm format to the Region column of the sales table in the public caslib?

Question93: Which SAS Viya procedure is used for data exploration and analysis?

Question94: After submitting the following SAS program, the log below is created.
Code:
proc casutil;
droptable incaslib='primary_school' casdata="teachers";
quit;
Log:
ERROR: The table teachers could not be located in caslib primary_school of Cloud Analytic Services.
ERROR: The action stopped due to errors.
Why is the table not dropped?

Question95: What does CAS stand for in CAS language programming?

Question96: Which CAS-enabled procedure is used to perform data partitioning?

Question97: Which CAS action is used to retrieve a subset of rows and columns from a CAS table?

Question98: The set parameter of the table.update CAS action requires a specific type of value.
Which type is correct?

Question99: Which PROC CAS step will transpose the CLASS table so that the values of the NAME column are used to create the column names in the output table?

Question100: What is the purpose of the PROMOTE action in CAS?

Question101: Which CAS-enabled procedure is used to perform clustering analysis on CAS tables?

Question102: In the DATA step, which statement is used to output the processed data?

Question103: In the following code, complete the PRINT statement to print only rows where column begins with MPG:
proc cas;
simple.summary result=res / table={name="cars"};
resultTable = res.summary;
print <insert code segment here>;
run;

Question104: Which CASL program will fetch all 428 rows from the cars table?

Question105: Which CAS-enabled procedure is used to perform data manipulation operations like filtering and transforming data?

Question106: Which CAS action is used to delete rows from a CAS table?

Question107: Which CAS action is used to perform aggregations and summary statistics in the DATA step?

Question108: Which CASL statement correctly saves a SAS data set keeping only the empid and hrdate variables?

Question109: What is the purpose of the CASLIB statement in SAS Viya?

Question110: Which CAS action is used to format the values of a numeric variable in a CAS table?

Question111: Which CAS action is used to create a new CAS table based on specified conditions?

Question112: Which CAS statement is used to join two or more CAS tables based on a common key variable?

Question113: What is the main purpose of the DATA step in SAS Viya?

Question114: Which statement about the MDSUMMARY procedure is true?

Question115: What CASL data type is created from the following assignment statement?
half = 1/2;

Question116: Which programming language is primarily used in SAS Viya?

Question117: The following code is executed multiple times:
data casuser.eurorders;
set casuser.orders end=eof;
if Continent="Europe" then EurOrders+1;
if eof=1 then output;
keep EurOrders;
run;
proc print data=casuser.eurorders;
run;
Will the rows in the output table be sorted the same way for each execution and why?

Question118: Given the following SAS program:
data casuser.national;
set casuser.baseball(where=(league='National'));
r=ranuni(625);
drop league;
run;
Why is the above program processed by the Compute Server rather than the CAS server?

Question119: Assume all caslib names follow libref naming conventions.
Which code assigns librefs of the same name to each caslib?

Question120: Which CAS action is used to convert a character variable to a numeric variable in a CAS table?

Question121: Which CAS-enabled procedure is used to perform text mining on CAS tables?