A00-420 exam

Which function is used to calculate the mean of a variable in SAS Viya?A . AVGB . MEANC . SUMD . MEDIANView AnswerAnswer: B

Which data format should be used when saving a CAS table so that it will later load into CAS memory the fastest?A . sashdatB . sas7bdatC . csvD . txtView AnswerAnswer: A

Which SAS Viya component provides self-service data preparation capabilities?A . SAS Data PreparationB . SAS Cloud Analytic Services (CAS)C . SAS StudioD . SAS Visual AnalyticsView AnswerAnswer: A

Which SQL clause is used to filter rows in a CAS table based on specified conditions?A . SELECTB . FROMC . WHERED . GROUP BYView AnswerAnswer: C

Which CAS statement is used to select specific columns from a CAS table?A . CASTABLEB . CASSELECTC . CASCOLUMND . CASWHEREView AnswerAnswer: A

What is the purpose of the WHERE clause in CAS language programming?A . To filter rows based on specified conditionsB . To define the input data sourceC . To specify the output variablesD . To join multiple tables togetherView AnswerAnswer: A

In SAS Viya, what is the purpose of the SAS Studio application?A . To create interactive reportsB . To perform data visualizationC . To write and execute SAS programsD . To build machine learning modelsView AnswerAnswer: C

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...

How can you view the contents of a CAS table?A . Using the CASLIB actionB . Using the LOAD actionC . Using the FETCH actionD . Using the TABLE actionView AnswerAnswer: D

Which CAS action is used to compute descriptive statistics for numeric variables in a CAS table?A . cas.summarizeB . cas.statisticsC . cas.describeD . cas.profileView AnswerAnswer: C