최신 A00-420 무료덤프 - SASInstitute SAS Viya Intermediate Programming

문제1

Which CAS action is used to execute SQL queries in SAS CAS?

A. RUN

B. SQL

C. EXECUTE

D. SUBMIT

정답: B

문제2

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

A. proc cas;
table.loadTable /
incaslib="casuser"
casdata="cars.csv"
outcaslib="casuser"
casout="cars";
quit;

B. proc cas;
table.loadTable /
incaslib="casuser"
casdata="/home/&sysuserid/casuser/cars.csv"
outcaslib="casuser"
casout="cars";
quit;

C. proc cas;
table.loadTable /
caslib="casuser"
path="cars.csv"
casout={caslib="casuser", name="cars"};
quit;

D. proc cas;
table.loadTable /
caslib="casuser"
path="/home/&sysuserid/casuser/cars.csv"
casout={caslib="casuser", name="cars"};
quit;

정답: C

문제3

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;

정답:

"cars_cas"

문제4

Which PROC MDSUMMARY step produces results?

A. proc mdsummary data=casuser.orders;
var profit;
run;

B. proc mdsummary data=casuser.orders;
var profit;
output out=casuser.sumorders;
run;

C. proc mdsummary data=casuser.orders;
var profit / out=casuser.sumorders;
run;

D. proc mdsummary data=casuser.orders;
var profit;
out casuser.sumorders;
run;

정답: B

문제5

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

A. INFORMAT statement

B. FORMAT statement

C. LENGTH statement

D. LABEL statement

정답: B

문제6

Which statement about CASL is true?

A. CASL is an open source language.

B. CASL is a replacement for SQL.

C. CASL allows you to run any CAS action.

D. CASL is a replacement for the DATA Step.

정답: C

문제7

Select the CASL statement that correctly removes the key named region from the dept dictionary.

A. remove region.dept;

B. remove dept.region;

C. delete dept.region;

D. delete region.dept;

정답: C

문제8

Given the following SAS program?
caslib _all_ assign;
proc sgplot data=casuser.cars;
vbar Make;
run;
What will the program do?

A. Summarize the results in CAS and process the summarized results on the Compute Server.

B. Produce an error because the SGPLOT procedure cannot access the CAS table.

C. Transfer the data to the Compute Server and then execute the SGPLOT procedure.

D. Execute the SGPLOT procedure on the CAS server.

정답: C

문제9

Which statement is used to read data from an external file into a SAS dataset?

A. SET statement

B. PROC SQL

C. MERGE statement

D. OUTPUT statement

정답: A

문제10

Which data types are supported by CAS tables?

A. CHAR, DOUBLE, VARCHAR, BINARY

B. CHAR, DOUBLE, VARBINARY, DECIMAL

C. CHAR, DOUBLE, DECIMAL, TIMESTAMP

D. CHAR, DOUBLE, VARCHAR, INT64

정답: D

문제11

Complete the following FedSQL code to convert the character variable markup to a numeric variable.
proc cas;
session mysess;
fedSql.execDirect /
query="create table casuser.cars_fedsql {options replace=true} as
select make, model, mpg_city, mpg_highway, <insert code segment here> as markup_N from casuser.cars"; run;

A. cast(markup,'best12.')

B. put(markup,'best12.')

C. inputn(markup,'best12.')

D. input(markup,'best12.')

정답: C

문제12

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', replace=true};
quit;

B. proc cas;
simple.mdsummary / table={name="orders", caslib="casuser"},
input={"RetailPrice"},
casOut={name='orders_sum', replace=true};
quit;

C. proc cas;
md.summary / table={name="orders", caslib="casuser"},
input={"RetailPrice"},
casOut={name='orders_sum'};
quit;

D. proc cas;
simple.summary / table={name="orders", caslib="casuser"},
input={"RetailPrice"},
casOut={name='orders_sum'};
quit;

정답: A

문제13

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

A. To define the output columns

B. To group rows based on common values

C. To filter rows based on conditions

D. To sort the result set

정답: B

문제14

What is the purpose of the APPEND action in CAS language programming?

A. To append columns to an existing CAS table

B. To add new observations to an existing CAS table

C. To merge multiple CAS tables horizontally

D. To concatenate multiple CAS tables vertically

정답: B

문제15

Which table.update parameter specifies the column to update?

A. Update

B. Assign

C. ComputedVars

D. Set

정답: D

문제16

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

A. tableDetails

B. fileInfo

C. caslibInfo

D. tableInfo

정답: B

문제17

In the deduplication.deduplicate action, which parameter eliminates rows with duplicate group-by variable values?

A. uniqueOut

B. noDuplicateKeys

C. groupBy

D. noUniqueKeys

정답: B

문제18

Which CAS statement is used to perform summary statistics on a CAS table?

A. CASTATS

B. CASDESCRIBE

C. CASMEANS

D. CASUTIL

정답: C

최신 A00-420 무료덤프 - SASInstitute SAS Viya Intermediate Programming

우리와 연락하기

유용한 링크

최신 업데이트