Practice Free A00-420 Exam Online Questions
Question #1
Which DATA step function is used to concatenate character variables in CAS programming?
- A . LENGTH
- B . CAT
- C . CONCAT
- D . CATS
Correct Answer: D
Question #2
Which statement can execute successfully using PROC FEDSQL?
- A . create table work.age12 as
select Name, Height, Weight
from casuser.class
where age=12
; - B . select Species, SepalWidth, SepalLength
from casuser.iris
where Species ^= "Setosa"
; - C . select HouseID, Brand, exp(logPrice) as Price
from casuser.margarin
where calculated Price > 5
; - D . create table casuser.incomplete as
select AgeAtStart, Height, cholesterol, Chol_Status
from casuser.heart
where cholesterol is null
;
Correct Answer: D
Question #3
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
Correct Answer: A
Question #4
Which CAS action is used to create a new CASLIB?
- A . CASLIB
- B . LOAD
- C . EXPORT
- D . ALTER TABLE
Correct Answer: A
Question #5
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)
Correct Answer: D
Question #6
Which DATA step feature is NOT supported in CAS?
- A . DO Loops
- B . GIT functions
- C . Arrays
- D . IF-THEN/ELSE statements
Correct Answer: B
Question #7
What is the primary programming language used in SAS Viya?
- A . SAS
- B . R
- C . Python
- D . Java
Correct Answer: A
Question #8
Which CAS-enabled procedure is used to perform text mining on CAS tables?
- A . CASTEXT
- B . CASTEXTMINE
- C . CASTEXTPROC
- D . CASTEXTSUMMARY
Correct Answer: B
Question #9
Given the following SAS program?
caslib _all_ assign;
proc sgplot data=casuser.cars;
vbar Make;
run;
What will the program do?
- A . Produce an error because the SGPLOT procedure cannot access the CAS table.
- B . Execute the SGPLOT procedure on the CAS server.
- C . Summarize the results in CAS and process the summarized results on the Compute Server.
- D . Transfer the data to the Compute Server and then execute the SGPLOT procedure.
Correct Answer: D
Question #10
Which CAS action is used to generate a summary report of missing values in a CAS table?
- A . cas.missing
- B . cas.validate
- C . cas.summary
- D . cas.check
Correct Answer: A