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

문제1

What is the primary advantage of using CAS-enabled procedures in SAS?

A. Enhanced modeling techniques

B. Faster processing of large datasets

C. Easier data preparation

D. Better visualization capabilities

정답: B

문제2

Which CAS action is used to perform data quality checks on variables in a CAS table?

A. cas.check

B. cas.quality

C. cas.verify

D. cas.validate

정답: D

문제3

Which CAS statement is used to assign a CAS table to a CAS library?

A. CASSET

B. CASDATA

C. CASTABLE

D. CASLIB

정답: D

문제4

Which CAS action is used to join multiple tables in SQL programming?

A. MERGE

B. CONCATENATE

C. JOIN

D. UNION

정답: C

문제5

Which CAS action is used to calculate summary statistics for variables in a CAS table?

A. cas.aggregate

B. cas.stats

C. cas.summary

D. cas.describe

정답: C

문제6

Which CAS action is used to import data into CAS?

A. LOAD

B. ALTER TABLE

C. CASLIB

D. EXPORT

정답: A

문제7

Which statement about the MDSUMMARY procedure is true?

A. The results are displayed in the Result tab.

B. It requires an in-memory table as input.

C. Not all statements execute in CAS.

D. The CAS libname engine is not required.

정답: B

문제8

When creating SAS graphs on extremely large CAS tables, the best practice is to:

A. Execute graph actions on the CAS tables.

B. Summarize the data in CAS and work with the output on the Compute Server.

C. Use the SGPLOT procedure on the CAS table.

D. Enable multi-threading on the CAS server.

정답: B

문제9

Which CAS action is used to calculate the total count, distinct count, and missing count for variables in a CAS table?

A. cas.count

B. cas.summary

C. cas.unique

D. cas.missing

정답: A

문제10

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

문제11

Which PROC CASUTIL statement will save the in-memory table cars in the casuser caslib to a SAS data set named cars in the public caslib?

A. save caslib='casuser' casdata='cars' out='public.cars';

B. savedata incaslib='casuser' casdata='cars' casout='cars.sas7bat' library='public';

C. savedata caslib='casuser' casdata='cars' dataout='cars.sas7bdat' outcaslib='public';

D. save incaslib='casuser' casdata='cars' casout='cars.sas7bdat' outcaslib='public';

정답: D

문제12

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

문제13

Which CAS-enabled procedure is used to perform data manipulation operations like filtering and transforming data?

A. CASDATA

B. CASUTIL

C. CASLIB

D. CASDATAPARTITION

정답: B

문제14

Which CAS-enabled procedure is used to perform text mining on CAS tables?

A. CASTEXTSUMMARY

B. CASTEXTPROC

C. CASTEXTMINE

D. CASTEXT

정답: C

문제15

Which CAS action is used to load data from an external file into a CAS table?

A. cas.upload

B. cas.fetch

C. cas.load

D. cas.import

정답: D

문제16

Which statement about the CASL language is true?

A. Actions in CASL are grouped into PROCs, and optional information is provided with parameters.

B. CASL code is submitted to the CAS server using PROC CASUTIL.

C. All CAS-enabled procedures are converted to CASL behind the scenes to run in CAS.

D. CASL runs actions on both the SAS Compute Server and in CAS.

정답: C

문제17

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

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

우리와 연락하기

유용한 링크

최신 업데이트