Practice Free A00-420 Exam Online Questions
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 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
Which PROC CASUTIL step suppresses error messages if the table is not found in-memory?
- A . Option A
- B . Option B
- C . Option C
- D . Option D
Which CAS action is used to delete a CASLIB?
- A . CASLIB
- B . DROP TABLE
- C . EXPORT
- D . ALTER TABLE
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;
- A . resultTable.where(column like ‘MPG%’)
- B . resultTable.where("column like ‘MPG%’")
- C . resultTable / where("column like ‘MPG%’")
- D . resultTable / where(column like ‘MPG%’)
Which CAS action is used to perform outlier detection on numeric variables in a CAS table?
- A . cas.detect
- B . cas.identify
- C . cas.outlier
- D . cas.anomaly
Which programming language is used for SQL programming in SAS CAS?
- A . SAS
- B . SQL
- C . R
- D . Python
Which SAS Viya procedure is used for statistical modeling and regression analysis?
- A . PROC GLM
- B . PROC MEANS
- C . PROC FREQ
- D . PROC SQL
Which CAS action is used to format the values of a numeric variable in a CAS table?
- A . cas.modify
- B . cas.transform
- C . cas.format
- D . cas.style
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