Which CAS action is used to load data from an external file into a CAS table?
- A . cas.load
- B . cas.fetch
- C . cas.upload
- D . cas.import
Which CAS action is used to convert a character variable to a numeric variable in a CAS table?
- A . cas.convert
- B . cas.cast
- C . cas.change
- D . cas.transform
Which statement is used to sort a SAS dataset in ascending order?
- A . SORT DESCENDING
- B . PROC SORT
- C . ORDER BY
- D . SORT DSN
Given the following SAS program?
caslib _all_ assign;
proc sgplot data=casuser.cars;
vbar Make;
run;
What will the program do?
- A . Produce an error because the SGPLOT procedure cannot access the CAS table.
- B . Execute the SGPLOT procedure on the CAS server.
- C . Summarize the results in CAS and process the summarized results on the Compute Server.
- D . Transfer the data to the Compute Server and then execute the SGPLOT procedure.
Which statement is true for the table.copyTable action?
- A . Both the table= and casout= parameters are required to use the copyTable action.
- B . The table= parameter specifies the name of the table that you want to replace.
- C . The table= parameter allows you to create calculated columns.
- D . The casout= parameter is required, but the table= parameter is not required.
Which CAS action is used to delete a CASLIB?
- A . CASLIB
- B . DROP TABLE
- C . EXPORT
- D . ALTER TABLE
Which programming language is primarily used in SAS Viya?
- A . Python
- B . R
- C . Java
- D . SAS
Which CAS action is used to compute the frequency count of unique values in a column of a CAS table?
- A . cas.count
- B . cas.uniq
- C . cas.distinct
- D . cas.frequency
Which PROC CASUTIL statement successfully applies the regnm format to the Region column of the sales table in the public caslib?
- A . altertable caslib="public" casdata="sales" columns={name="Region" format="regnm."};
- B . altertable incaslib="public" table="sales" columns={{name="Region" format="regnm."}};
- C . altertable incaslib="public" casdata="sales" columns={{name="Region" format="regnm."}};
- D . altertable caslib="public" table="sales" columns={name="Region" format="regnm."};
Which CAS action is used to delete rows from a CAS table?
- A . DELETE
- B . DROP TABLE
- C . EXPORT
- D . ALTER TABLE
Which statement about the CASL language is true?
- A . All CAS-enabled procedures are converted to CASL behind the scenes to run in CAS.
- B . CASL runs actions on both the SAS Compute Server and in CAS.
- C . Actions in CASL are grouped into PROCs, and optional information is provided with parameters.
- D . CASL code is submitted to the CAS server using PROC CASUTIL.
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?
A)
B)
C)
D)
- A . Option A
- B . Option B
- C . Option C
- D . Option D
Which statement about CASL is true?
- A . CASL is a replacement for the DATA Step.
- B . CASL allows you to run any CAS action.
- C . CASL is an open source language.
- D . CASL is a replacement for SQL.
Which CAS action is used to delete a CAS table from memory?
- A . cas.delete
- B . cas.remove
- C . cas.drop
- D . cas.discard
Which CAS statement is used to load data from an external file into a CAS table?
- A . CASLIB
- B . CASTABLE
- C . CASIMPORT
- D . CASDATA
How can you define a user-defined format in SAS?
- A . Using the FORMAT statement in the DATA step
- B . Using the DEFINE statement in PROC SQL
- C . Using the OPTIONS statement in PROC FORMAT
- D . Using the FORMAT procedure in SAS Studio
Which SAS Viya component allows users to create and manage machine learning models?
- A . SAS Data Preparation
- B . SAS Studio
- C . SAS Visual Analytics
- D . SAS Model Studio
Which CAS-enabled procedure allows the use of user-defined formats for data summarization?
- A . PROC MEANS
- B . PROC SQL
- C . PROC FREQ
- D . PROC FORMAT
Given the following SAS program:
proc mdsummary data=casuser.orders;
var RetailPrice;
output out=casuser.orders_sum;
run;
Which CAS action produces the same result as the code above without ERROR if you run it twice?
- A . proc cas;
simple.summary /
table={name="orders", caslib="casuser"},
input={"RetailPrice"},
casOut={name=’orders_sum’};
quit; - B . proc cas;
simple.mdsummary /
table={name="orders", caslib="casuser"},
input={"RetailPrice"},
casOut={name=’orders_sum’, replace=true};
quit; - C . proc cas;
simple.summary /
table={name="orders", caslib="casuser"},
input={"RetailPrice"},
casOut={name=’orders_sum’, replace=true};
quit; - D . proc cas;
md.summary /
table={name="orders", caslib="casuser"},
input={"RetailPrice"},
casOut={name=’orders_sum’};
quit;
Which CASL program segment correctly defines a source block to be run from a subsequent action?
- A . source myCode;
"data OutData;
set
casuser.cars;
where
""make = ‘Honda’"";
run;"
endsource; - B . source myCode;
"data OutData;
set
casuser.cars;
where make =
‘Honda’;
run;"
endsource; - C . source myCode;
data OutData;
set casuser.cars;
where make = ‘Honda’;
run;
endsource; - D . source myCode;
"data OutData;" ||
"set
casuser.cars;" ||
"where
make = ‘Honda’;" ||
"run;"
endsource;
Which Compute Server system option prevents inadvertently moving large in-memory tables to the Compute Server?
- A . MAXDATA=
- B . CASDATALIMIT=
- C . NOCOMPUTE
- D . MAXOBS=
What does CAS stand for in CAS language programming?
- A . Centralized Analytical System
- B . Cloud Analytic Services
- C . Clustered Analytical Server
- D . Computerized Analytical Software
Which CAS-enabled procedure is used to generate descriptive statistics for CAS tables?
- A . CASTATS
- B . CASMEANS
- C . CASUTIL
- D . CASDESCRIBE
What is the main purpose of the DATA step in SAS Viya?
- A . Creating plots and graphs
- B . Importing and exporting data
- C . Performing statistical analysis
- D . Transforming and manipulating data
Given the following array: x={"May", "August", "September"};
What is the correct reference to the element containing the value May?
- A . x[0]
- B . x[1]
- C . x.get(0)
- D . x.get(1)
Which CAS action is used to generate a summary report of missing values in a CAS table?
- A . cas.missing
- B . cas.validate
- C . cas.summary
- D . cas.check
Which procedure can run in CAS?
- A . PROC SQL
- B . PROC GCHART
- C . PROC SGRENDER
- D . PROC MEANS
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?
- A . The WHERE option is not supported in the SET statement.
- B . The SESSREF= option is not specified in the DATA statement.
- C . The DROP statement is not supported.
- D . The RANUNI function is not supported.
Which CAS action is used to calculate the frequency and percentage of values for categorical variables in a CAS table?
- A . cas.frequencies
- B . cas.counts
- C . cas.histogram
- D . cas.summary
In the space provided, enter the text for ensuring the table is available to any subsequent CAS session.
table.loadTable / caslib="public", path="sales.xlsx",
casOut={caslib="public", name="sales",______=true};
Which DATA step function is supported in CAS?
- A . SYMGET
- B . CATX
- C . FILEREF
- D . RANUNI
Which code can be used to load a SAS data set, sashelp.cars, into caslib public?
- A . proc casutil;
load data=sashelp.cars caslib=public;
quit; - B . proc casutil;
load data=sashelp.cars outcaslib="public";
quit; - C . libname public cas sessref=public;
data public.cars;
set sashelp.cars;
run; - D . data public.cars / sessref=casuser;
set sashelp.cars;
run;
What is the purpose of the VALUE statement in PROC FORMAT?
- A . To define the range of values for a format
- B . To specify the format name and type
- C . To define the appearance of formatted values
- D . To assign a format to a variable
Which DATA step feature is NOT supported in CAS?
- A . DO Loops
- B . GIT functions
- C . Arrays
- D . IF-THEN/ELSE statements
Which CAS-enabled procedure is used to perform market basket analysis?
- A . CASMINER
- B . CASPROC
- C . CASASSOC
- D . CASSTAT
Which CASL program correctly runs two DATA step programs that are stored in separate source blocks named Program1 and Program2?
- A . proc cas;
dataStep.RunCode /
code=("Program1", "Program2");
quit; - B . proc cas;
dataStep.RunCode / code=Program1;
dataStep.RunCode / code=Program2;
quit; - C . proc cas;
dataStep.RunCode /
code=source(Program1, Program2);
quit; - D . proc cas;
dataStep.RunCode /
code=source(Program1, Program2);
quit;
Which SQL clause is used to calculate summary statistics for variables in a CAS table?
- A . SELECT
- B . FROM
- C . GROUP BY
- D . HAVING
Which CAS action is used to perform a join operation between two CAS tables based on a common key variable?
- A . cas.merge
- B . cas.join
- C . cas.link
- D . cas.combine
Which programming language is used for SQL programming in SAS CAS?
- A . SAS
- B . SQL
- C . R
- D . Python
Which CAS action is used to generate descriptive statistics for numeric variables in a CAS table?
- A . cas.summarize
- B . cas.statistics
- C . cas.describe
- D . cas.profile
Which CAS-enabled procedure is used for frequency analysis and cross-tabulations?
- A . PROC MEANS
- B . PROC SQL
- C . PROC FREQ
- D . PROC GLM
Which statement will display column name, type, label and format information for the clientes table in the casuser caslib?
- A . table.tableInfo /
table={caslib="casuser", name="clientes"}; - B . table.columnInfo /
table={caslib="casuser", name="clientes"}; - C . table.tableInfo /
caslib="casuser",
name="clientes"; - D . table.columnInfo /
caslib="casuser",
name="clientes";
In which situation is it best to leverage the CAS server?
- A . When you need to use the LASR procedure to access data.
- B . When executing BY statements with high cardinality variables.
- C . When using large data and computationally complex code.
- D . When you need to SORT all of your data before processing.
Which DATA step function is used to concatenate character variables in CAS programming?
- A . LENGTH
- B . CAT
- C . CONCAT
- D . CATS
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?
- A . Yes, because only one row will be printed.
- B . Yes, because by default CAS sorts the output table.
- C . No, because each thread inserts a row into the casuser.eurorders table when it ends.
- D . No, because the CAS Controller randomly reads the casuser.eurorders table when processing the proc print.
What is the purpose of the GROUP BY clause in SQL programming?
- A . To sort the result set
- B . To filter rows based on conditions
- C . To define the output columns
- D . To group rows based on common values
Given the following log output:
– NOTE: The WHERE data set option on the DATA statement is not supported with DATA step in Cloud Analytic Services.
– NOTE: Could not execute DATA step code in Cloud Analytic Services. Running DATA step in the SAS client.
– NOTE: There were 19 observations read from the data set CASUSER.CLASS.
– NOTE: The data set CASUSER.CLASS2 has 1 observations and 5 variables.
Which DATA step program produced the above log output?
- A . options msglevel=n;
data casuser.class2(where=(Age>15));
set casuser.class;
run; - B . options msglevel=verbose;
data casuser.class2(where=(Age>15));
set casuser.class;
run; - C . options msglevel=i;
data casuser.class2(where=(Age>15));
set casuser.class;
run; - D . data casuser.class2(where=(Age>15));
set casuser.class;
run;
Which CAS action is used to execute a DATA step program in SAS CAS?
- A . DATA
- B . RUN
- C . SUBMIT
- D . EXECUTE
Which PROC TRANSPOSE step will execute entirely in CAS?
- A . proc transpose data=casuser.table out=casuser.table_transposed;
id group;
run; - B . proc transpose data=casuser.table out=work.table_transposed;
id group;
run; - C . proc transpose data=work.table out=casuser.table_transposed;
id group;
run; - D . proc transpose data=work.table out=work.table_transposed;
id group;
run;
Which of the following statements about the CAS server is true?
- A . CAS data is AES256 encrypted by default.
- B . CAS can execute R programs.
- C . CAS integrates with many open source languages.
- D . CAS natively runs base SAS programs.
Which operator is used for assignment in SAS Viya?
- A . =
- B . ==
- C . :=
- D . EQ
Which CAS-enabled procedure is used for data exploration and visualization?
- A . PROC MEANS
- B . PROC SQL
- C . PROC FREQ
- D . PROC SGPLOT
What is the primary programming language used in SAS Viya?
- A . SAS
- B . R
- C . Python
- D . Java
Which SAS Viya component provides self-service data preparation capabilities?
- A . SAS Data Preparation
- B . SAS Cloud Analytic Services (CAS)
- C . SAS Studio
- D . SAS Visual Analytics
Which SQL clause is used to filter rows in a CAS table based on specified conditions?
- A . SELECT
- B . FROM
- C . WHERE
- D . GROUP BY
Which CAS action is used to calculate summary statistics for variables in a CAS table?
- A . cas.describe
- B . cas.stats
- C . cas.summary
- D . cas.aggregate
What is CAS in SAS Viya?
- A . A programming language
- B . A data management tool
- C . A distributed computing environment
- D . A data visualization tool
What is the purpose of the SET statement in the DATA step?
- A . To define the input data source
- B . To create a new variable
- C . To specify conditional logic
- D . To apply formatting to variables
Which CAS action is used to calculate the frequency distribution of a categorical variable in a CAS table?
- A . cas.frequency
- B . cas.distribution
- C . cas.histogram
- D . cas.tabulate
Which CAS action is used to merge two or more CAS tables based on a common key variable?
- A . cas.combine
- B . cas.append
- C . cas.union
- D . cas.merge
Which CAS action is used to calculate the standard deviation, variance, and range for numeric variables in a CAS table?
- A . cas.stddev
- B . cas.variance
- C . cas.range
- D . cas.statistics
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;
- A . columns={name="make" = "veh_make"};
- B . columns=[[name="make" , rename="veh_make"]];
- C . columns={{rename="make" , name="veh_make"}};
- D . columns={{name="make" , rename="veh_make"}};
Which function is used to calculate the mean of a variable in SAS Viya?
- A . AVG
- B . MEAN
- C . SUM
- D . MEDIAN
Assume all caslib names follow libref naming conventions.
Which code assigns librefs of the same name to each caslib?
- A . caslib _all_ assign;
- B . caslib assign _all_;
- C . caslib libref assign;
- D . caslib assign libref;
Which CAS-enabled procedure is used for descriptive statistics and data summarization?
- A . PROC MEANS
- B . PROC SQL
- C . PROC FREQ
- D . PROC GLM
Which PROC CASUTIL step correctly saves a CSV file in the casuser caslib and overwrites any files with the same name?
- A . proc casutil;
save casdata="employees" incaslib="casuser"
outcaslib="casuser" casout="out_employees.csv" replace;
quit; - B . proc casutil;
save casdata="employees" incaslib="casuser"
outcaslib="casuser" casout="out_employees.csv";
quit; - C . proc casutil;
save type="csv" casdata="employees" incaslib="casuser"
outcaslib="casuser" casout="out_employees";
quit; - D . proc casutil;
save type="csv" casdata="employees" incaslib="casuser"
outcaslib="casuser" casout="out_employees" replace;
quit;
In SAS Viya, what is the purpose of the LIBNAME statement?
- A . To create a new library
- B . To import external data
- C . To assign a library reference
- D . To delete a library
Which program will display ODS output?
- A . proc cas;
print casuser.class;
quit; - B . proc cas;
simple.summary /
table={caslib="casuser" name="class"};
quit; - C . proc mdsummary data=casuser.class;
var height;
output out=casuser.result;
run; - D . proc cas;
table.fetch result=r /
table={caslib="casuser" name="class"};
quit;
Which CAS action is used to create a new variable in the DATA step?
- A . DROP
- B . ALTER TABLE
- C . COMPUTE
- D . FORMAT
Which CAS-enabled procedure is used to perform clustering analysis on CAS tables?
- A . CASSTAT
- B . CASCLUSTER
- C . CASKMEANS
- D . CASPROC
Which CAS action is used to append rows to an existing CAS table?
- A . APPEND
- B . LOAD
- C . EXPORT
- D . ALTER TABLE
What is the purpose of the BY statement in CAS language programming?
- A . To specify the output format
- B . To merge multiple tables
- C . To subset the data
- D . To group data by one or more variables
DATA step performance in CAS is most affected:
- A . when the NOTSORTED option is used in the BY statement.
- B . when the DESCENDING option is used in the BY statement.
- C . by the cardinality of the first variable listed in the BY statement.
- D . when data is not sorted prior to using a BY statement.
A CAS table has a CHAR column called FirstName with a length of 10.
How many bytes are used to store the value "Inez" in the column FirstName?
- A . 4 bytes
- B . 8 bytes
- C . 10 bytes
- D . 20 bytes
Given the following program:
data casuser.noInput / sessref=casauto;
x=1;
run;
Which statement is true?
- A . The DATA step runs on the SAS Compute Server.
- B . The DATA step runs in CAS.
- C . The DATA step runs on the SAS Workspace Server.
- D . The DATA step produces an error.
Which programming language is primarily used in CAS?
- A . Python
- B . R
- C . Java
- D . SAS
Which CAS action is used to filter rows in a CAS table based on specified conditions?
- A . cas.select
- B . cas.filter
- C . cas.where
- D . cas.subset
Which statement will show all available caslibs in the log?
- A . caslib listall;
- B . caslib all list;
- C . caslib list;
- D . caslib _all_ list;
Complete the code below to create an in-memory table named cars_cas in the casuser caslib.
proc casutil;
load data=sashelp.cars outcaslib="casuser" casout=__________;
run;
Which CAS action is used to create a new variable in a CAS table based on a conditional expression?
- A . cas.derive
- B . cas.calculate
- C . cas.transform
- D . cas.generate
Which statement is used to create a new variable in SAS Viya?
- A . IF-THEN statement
- B . DROP statement
- C . RENAME statement
- D . LENGTH statement
Which PROC MDSUMMARY step produces results?
- A . proc mdsummary data=casuser.orders;
var profit;
output out=casuser.sumorders;
run; - B . proc mdsummary data=casuser.orders;
var profit;
out casuser.sumorders;
run; - C . proc mdsummary data=casuser.orders;
var profit /
out=casuser.sumorders;
run; - D . proc mdsummary data=casuser.orders;
var profit;
run;
Which SAS component enables CAS-enabled procedures?
- A . SAS Studio
- B . SAS Data Preparation
- C . SAS Visual Analytics
- D . SAS Cloud Analytic Services (CAS)
Which CAS-enabled procedure is used to perform data exploration and summarization?
- A . CASUTIL
- B . CASDATA
- C . CASSTAT
- D . CASPROC
Which CAS action is used to rename variables in a CAS table?
- A . cas.rename
- B . cas.modify
- C . cas.alter
- D . cas.change
Which CAS action is used to validate the integrity of relationships between variables in a CAS table?
- A . cas.integrity
- B . cas.relationship
- C . cas.validate
- D . cas.link
Which CAS-enabled procedure is used to combine multiple CAS tables based on a common key variable?
- A . CASMERGE
- B . CASCOMBINE
- C . CASTABLE
- D . CASEJOIN
Which CAS action is used to execute SQL queries in SAS CAS?
- A . SQL
- B . RUN
- C . SUBMIT
- D . EXECUTE
Which CAS action is used to remove duplicate records from a CAS table?
- A . cas.distinct
- B . cas.unique
- C . cas.dedup
- D . cas.remove
Which SAS procedure is used for generating descriptive statistics?
- A . PROC SUMMARY
- B . PROC REPORT
- C . PROC MEANS
- D . PROC TABULATE
Which CAS statement is used to assign a CAS table to a CAS library?
- A . CASLIB
- B . CASDATA
- C . CASTABLE
- D . CASSET
Which CAS action is used to import data into CAS?
- A . CASLIB
- B . LOAD
- C . EXPORT
- D . ALTER TABLE
In the deduplication.deduplicate action, which parameter eliminates rows with duplicate group-by variable values?
- A . noUniqueKeys
- B . noDuplicateKeys
- C . groupBy
- D . uniqueOut
Which statement correctly creates a global caslib called mycas that is connected to the /workshop/data location?
- A . caslib mycas path="/workshop/data" global;
- B . caslib path="/workshop/data" mycas global;
- C . caslib path="/workshop/data" mycas promote;
- D . caslib mycas path="/workshop/data" promote;
What data types does FedSQL support in CAS?
- A . BIGINT, CHAR(n), DATE, DOUBLE, DECIMAL, VARBINARY
- B . CHAR(n), DOUBLE, VARCHAR(n), TIMESTAMP, DATE, TIME
- C . INT64, CHAR(n), DOUBLE, INT32, VARCHAR(n), FLOAT
- D . INT64, CHAR(n), DOUBLE, INT32, VARBINARY, VARCHAR(n)
Which CASL program will fetch all 428 rows from the cars table?
- A . proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1,
to=1000;
quit; - B . proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1,
to=_all_;
quit; - C . . proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1,
to=_maxrows_;
quit; - D . proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1;
quit;
Which SAS Viya component is responsible for executing CAS-enabled procedures?
- A . CAS server
- B . SAS Studio
- C . SAS Metadata Server
- D . SAS Data Connector
Which CAS action is used to create a new CAS table based on specified conditions?
- A . FILTER
- B . SELECT
- C . WHERE
- D . SUBSET
If a dictionary named res contains a table named fetch, which statement will print the table?
- A . if res="fetch" then print res.fetch;
- B . if res contains "fetch" then print res.fetch;
- C . if dim(res, "fetch") > 0 then print res.fetch;
- D . if exists(res, "fetch") then print res.fetch;
Which table.update parameter specifies the column to update?
- A . Assign
- B . Update
- C . Set
- D . ComputedVars