A00-420試験無料問題集（256題）「SASInstitute SAS Viya Intermediate Programming 認定」

出題：1

Which statement correctly creates a global caslib called mycas that is connected to the
/workshop/data location?

A. caslib mycas path="/workshop/data" global;

B. caslib path="/workshop/data" mycas global;

C. caslib path="/workshop/data" mycas promote;

D. caslib mycas path="/workshop/data" promote;

正解：A 解答を投票する

出題：2

Which CAS action is used to retrieve a subset of rows and columns from a CAS table?

A. cas.sample

B. cas.filter

C. cas.fetch

D. cas.select

正解：C 解答を投票する

出題：3

You want to generate totals and averages by year for a very large Teradata table using SAS Viya programming methods.
What is the most efficient way to achieve this?

A. Load the table into CAS memory and use a CAS procedure to summarize it.

B. Create a SAS dataset copy of the table, load it into CAS memory and summarize with a CAS procedure.

C. Read the table directly with a SAS summary procedure that executes on the Compute Server.

D. Summarize the data using a SAS in-database procedure.

正解：D 解答を投票する

出題：4

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

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

B. Enable multi-threading on the CAS server.

C. Use the SGPLOT procedure on the CAS table.

D. Execute graph actions on the CAS tables.

正解：A 解答を投票する

出題：5

In SAS Viya, what is the purpose of the DATA step?

A. To generate statistical reports

B. To perform data visualization

C. To import external data into SAS

D. To create and modify SAS datasets

正解：D 解答を投票する

出題：6

Which table.update parameter specifies the column to update?

A. Assign

B. ComputedVars

C. Set

D. Update

正解：C 解答を投票する

出題：7

Which CAS-enabled procedure is used for frequency analysis and cross-tabulations?

A. PROC GLM

B. PROC MEANS

C. PROC SQL

D. PROC FREQ

正解：D 解答を投票する

出題：8

What is the purpose of the SELECT statement in SQL programming?

A. To define the output columns

B. To filter rows based on conditions

C. To join multiple tables

D. To sort the result set

正解：A 解答を投票する

出題：9

What is the purpose of applying a user-defined format to a variable in SAS?

A. To apply data validation rules to the variable

B. To change the data type of the variable

C. To modify the appearance of the variable's values

D. To rename the variable

正解：C 解答を投票する

出題：10

Which statement is true regarding BY group processing in the CAS DATA step?

A. Using the BY statement automatically sends all DATA step processing to a single thread.

B. The data must be sorted before the DATA step begins processing.

C. The DATA step orders the rows within a BY group and then orders the BY groups in the output.

D. Every row in a BY group is sent to the same thread and processed as a group.

正解：D 解答を投票する

出題：11

Which CAS action is used to delete rows from a CAS table?

A. ALTER TABLE

B. DROP TABLE

C. EXPORT

D. DELETE

正解：D 解答を投票する

出題：12

Which Compute Server system option prevents inadvertently moving large in-memory tables to the Compute Server?

A. NOCOMPUTE

B. CASDATALIMIT=

C. MAXDATA=

D. MAXOBS=

正解：B 解答を投票する

出題：13

The table casuser.employees is partitioned onto 3 CAS worker nodes.
Which SAS program will correctly accumulate a total of the salary variable and store it in the variable totalSalary?

A.

B.

C.

D.

正解：D 解答を投票する

出題：14

After submitting the following SAS program, the log below is created.
Code:
proc casutil;
droptable incaslib='primary_school' casdata="teachers";
quit;
Log:
ERROR: The table teachers could not be located in caslib primary_school of Cloud Analytic Services.
ERROR: The action stopped due to errors.
Why is the table not dropped?

A. Primary_school should be in double quotes.

B. The user does not have the permissions to drop tables from this caslib.

C. The casdata= option should be before the incaslib= option.

D. The teachers table does not exist in-memory in the primary_school caslib.

正解：D 解答を投票する

A00-420試験無料問題集「SASInstitute SAS Viya Intermediate Programming 認定」