A00-415 시험 - SAS Institute실제시험문제와 답 - 254문항

Question No : 1

Which table.update parameter specifies the column to update?

A.Assign
B.Update
C.Set
D.ComputedVars

정답:

Question No : 2

If a dictionary named res contains a table named fetch, which statement will print the table?

A.if res="fetch" then print res.fetch;
B.if res contains "fetch" then print res.fetch;
C.if dim(res, "fetch") > 0 then print res.fetch;
D.if exists(res, "fetch") then print res.fetch;

정답:

Question No : 3

Which CAS action is used to create a new CAS table based on specified conditions?

A.FILTER
B.SELECT
C.WHERE
D.SUBSET

정답:

Question No : 4

Which SAS Viya component is responsible for executing CAS-enabled procedures?

A.CAS server
B.SAS Studio
C.SAS Metadata Server
D.SAS Data Connector

정답:

Question No : 5

Which CASL program will fetch all 428 rows from the cars table?

A.proc cas; table.fetch / table={name="cars", caslib="casuser"}, from=1, to=1000; quit;
B.proc cas; table.fetch / table={name="cars", caslib="casuser"}, from=1, to=_all_; quit;
C.. proc cas; table.fetch / table={name="cars", caslib="casuser"}, from=1, to=_maxrows_; quit;
D.proc cas; table.fetch / table={name="cars", caslib="casuser"}, from=1; quit;

정답:

Question No : 6

What data types does FedSQL support in CAS?

A.BIGINT, CHAR(n), DATE, DOUBLE, DECIMAL, VARBINARY
B.CHAR(n), DOUBLE, VARCHAR(n), TIMESTAMP, DATE, TIME
C.INT64, CHAR(n), DOUBLE, INT32, VARCHAR(n), FLOAT
D.INT64, CHAR(n), DOUBLE, INT32, VARBINARY, VARCHAR(n)

정답:

Question No : 7

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;

정답:

Question No : 8

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

A.noUniqueKeys
B.noDuplicateKeys
C.groupBy
D.uniqueOut

정답:

Question No : 9

Which CAS action is used to import data into CAS?

A.CASLIB
B.LOAD
C.EXPORT
D.ALTER TABLE

정답:

Question No : 10

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

A.CASLIB
B.CASDATA
C.CASTABLE
D.CASSET

정답:

Question No : 11

Which SAS procedure is used for generating descriptive statistics?

A.PROC SUMMARY
B.PROC REPORT
C.PROC MEANS
D.PROC TABULATE

정답:

Question No : 12

Which CAS action is used to remove duplicate records from a CAS table?

A.cas.distinct
B.cas.unique
C.cas.dedup
D.cas.remove

정답:

Question No : 13

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

A.SQL
B.RUN
C.SUBMIT
D.EXECUTE

정답:

Question No : 14

Which CAS-enabled procedure is used to combine multiple CAS tables based on a common key variable?

A.CASMERGE
B.CASCOMBINE
C.CASTABLE
D.CASEJOIN

정답:

Question No : 15

Which CAS action is used to validate the integrity of relationships between variables in a CAS table?

A.cas.integrity
B.cas.relationship
C.cas.validate
D.cas.link

정답:

SAS Institute A00-415 시험