SAS Institute A00-415 問題練習

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

答えを確認する

正解: