[Jan 07, 2025] A00-420 Test Prep Training Practice Exam Questions Practice Tests
Exam Questions Answers Braindumps A00-420 Exam Dumps PDF Questions
NEW QUESTION # 99
Which CAS statement is used to select specific columns from a CAS table?
- A. CASWHERE
- B. CASCOLUMN
- C. CASTABLE
- D. CASSELECT
Answer: C
NEW QUESTION # 100
Which operator is used for assignment in SAS Viya?
- A. EQ
- B. =
- C. :=
- D. ==
Answer: C
NEW QUESTION # 101
Which DATA step statement is used to read data from an external file in CAS programming?
- A. OUTPUT statement
- B. MERGE statement
- C. PROC SQL
- D. SET statement
Answer: D
NEW QUESTION # 102
Which CAS action is used to aggregate data at a higher level of granularity in a CAS table?
- A. cas.collapse
- B. cas.groupby
- C. cas.aggregate
- D. cas.summarize
Answer: B
NEW QUESTION # 103
Which statement is used to apply a user-defined format within a PROC SQL query?
- A. GROUP BY
- B. FORMAT
- C. FORMAT SASDATE
- D. WHERE
Answer: B
NEW QUESTION # 104
Which CAS action is used to perform data quality checks on variables in a CAS table?
- A. cas.check
- B. cas.quality
- C. cas.validate
- D. cas.verify
Answer: C
NEW QUESTION # 105
Which programming language is primarily used in CAS?
- A. Python
- B. SAS
- C. R
- D. Java
Answer: B
NEW QUESTION # 106
Which CAS action is used to append rows to an existing CAS table?
- A. LOAD
- B. EXPORT
- C. ALTER TABLE
- D. APPEND
Answer: D
NEW QUESTION # 107
Which statement is true about SAS Viya?
- A. It contains the SAS launcher server, which is the primary server for processing big data.
- B. Its primary interface for submitting programs is the SAS Windowing Environment.
- C. It supports only single-threaded DATA step processing.
- D. It can employ multiple servers to execute programs.
Answer: D
NEW QUESTION # 108
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. The casdata= option should be before the incaslib= option.
- B. The user does not have the permissions to drop tables from this caslib.
- C. Primary_school should be in double quotes.
- D. The teachers table does not exist in-memory in the primary_school caslib.
Answer: D
NEW QUESTION # 109
Which CAS-enabled procedure is used to generate descriptive statistics for CAS tables?
- A. CASDESCRIBE
- B. CASTATS
- C. CASMEANS
- D. CASUTIL
Answer: C
NEW QUESTION # 110
Which CAS action is used to import data into CAS?
- A. LOAD
- B. EXPORT
- C. ALTER TABLE
- D. CASLIB
Answer: A
NEW QUESTION # 111
Which Compute Server system option prevents inadvertently moving large in-memory tables to the Compute Server?
- A. NOCOMPUTE
- B. MAXDATA=
- C. MAXOBS=
- D. CASDATALIMIT=
Answer: D
NEW QUESTION # 112
Which data format should be used when saving a CAS table so that it will later load into CAS memory the fastest?
- A. txt
- B. sashdat
- C. sas7bdat
- D. csv
Answer: B
NEW QUESTION # 113
Which CAS object is used to store and manage data?
- A. CASSET
- B. CASLIB
- C. CASTABLE
- D. CASDATA
Answer: D
NEW QUESTION # 114
Which CAS statement is used to perform data manipulation operations like filtering and transforming data?
- A. CASDATA
- B. CASWHERE
- C. CASUTIL
- D. CASTABLE
Answer: C
NEW QUESTION # 115
Which CAS action is used to execute a DATA step program in SAS CAS?
- A. RUN
- B. DATA
- C. SUBMIT
- D. EXECUTE
Answer: C
NEW QUESTION # 116
In the space provided, enter the text for ensuring the table is available to any subsequent CAS session.
table.loadTable / caslib="public", path="sales.xlsx",
casOut={caslib="public", name="sales",______=true};
Answer:
Explanation:
promote
NEW QUESTION # 117
Which statement is FALSE regarding loading data into CAS?
- A. Both DATA step and PROC COPY can be used to load data into CAS.
- B. Data Connectors are required to load DBMS data directly into CAS.
- C. Excel files can be loaded directly into CAS.
- D. JSON files can be loaded directly into CAS.
Answer: D
NEW QUESTION # 118
Which CAS action is used to recode the values of a categorical variable in a CAS table?
- A. cas.recode
- B. cas.remap
- C. cas.transform
- D. cas.modify
Answer: A
NEW QUESTION # 119
Which statement about the MDSUMMARY procedure is true?
- A. The results are displayed in the Result tab.
- B. The CAS libname engine is not required.
- C. It requires an in-memory table as input.
- D. Not all statements execute in CAS.
Answer: C
NEW QUESTION # 120
Given the following log output:
- NOTE: The WHERE data set option on the DATA statement is not supported with DATA step in Cloud Analytic Services.
- NOTE: Could not execute DATA step code in Cloud Analytic Services. Running DATA step in the SAS client.
- NOTE: There were 19 observations read from the data set CASUSER.CLASS.
- NOTE: The data set CASUSER.CLASS2 has 1 observations and 5 variables.
Which DATA step program produced the above log output?
- A. options msglevel=i;
data casuser.class2(where=(Age>15));
set casuser.class;
run; - B. options msglevel=verbose;
data casuser.class2(where=(Age>15));
set casuser.class;
run; - C. options msglevel=n;
data casuser.class2(where=(Age>15));
set casuser.class;
run; - D. data casuser.class2(where=(Age>15));
set casuser.class;
run;
Answer: A
NEW QUESTION # 121
Which CAS action is used to create a new variable in the DATA step?
- A. FORMAT
- B. COMPUTE
- C. ALTER TABLE
- D. DROP
Answer: B
NEW QUESTION # 122
Which CAS-enabled procedure is used for regression analysis and modeling?
- A. PROC MEANS
- B. PROC GLM
- C. PROC SQL
- D. PROC FREQ
Answer: B
NEW QUESTION # 123
Which CAS-enabled procedure is used to perform linear regression analysis on CAS tables?
- A. CASREG
- B. CASPROC
- C. CASSCORE
- D. CASANALYZE
Answer: A
NEW QUESTION # 124
......
Download Free SASInstitute A00-420 Real Exam Questions: https://passleader.realexamfree.com/A00-420-real-exam-dumps.html
