최신SASInstitute SAS Viya Intermediate Programming - A00-420무료샘플문제
문제1
Which CAS action is used to perform aggregations and summary statistics in the DATA step?
Which CAS action is used to perform aggregations and summary statistics in the DATA step?
정답: A
문제2
Which CAS action is used to perform data quality checks on variables in a CAS table?
Which CAS action is used to perform data quality checks on variables in a CAS table?
정답: C
문제3
Which CAS action is used to execute a DATA step program in SAS CAS?
Which CAS action is used to execute a DATA step program in SAS CAS?
정답: D
문제4
Select the correct way to define formats and labels in a FedSQL CREATE TABLE statement.
Select the correct way to define formats and labels in a FedSQL CREATE TABLE statement.
정답: C
문제5
Which Compute Server system option prevents inadvertently moving large in-memory tables to the Compute Server?
Which Compute Server system option prevents inadvertently moving large in-memory tables to the Compute Server?
정답: C
문제6
The following SAS program is submitted:
What is the output to the log?
The following SAS program is submitted:
What is the output to the log?
정답: D
문제7
Which statement can execute successfully using PROC FEDSQL?
Which statement can execute successfully using PROC FEDSQL?
정답: D
문제8
Which CAS statement is used to perform summary statistics on a CAS table?
Which CAS statement is used to perform summary statistics on a CAS table?
정답: D
문제9
When submitted, this program runs normally on the Compute Server and produces a cross-tab report:
proc freq data=casuser.cars;
by descending origin;
table type*make / nocol norow nopercent;
run;
What happens when this program is submitted instead?
proc freqtab data=casuser.cars;
by descending origin;
table type*make / nocol norow nopercent;
run;
When submitted, this program runs normally on the Compute Server and produces a cross-tab report:
proc freq data=casuser.cars;
by descending origin;
table type*make / nocol norow nopercent;
run;
What happens when this program is submitted instead?
proc freqtab data=casuser.cars;
by descending origin;
table type*make / nocol norow nopercent;
run;
정답: B
문제10
What is the main purpose of the DATA step in SAS Viya?
What is the main purpose of the DATA step in SAS Viya?
정답: C
문제11
Which CAS action is used to generate a summary report of missing values in a CAS table?
Which CAS action is used to generate a summary report of missing values in a CAS table?
정답: A
문제12
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;
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;
정답: D