[Oct-2024] Exam A00-420: New Brain Dump Professional - Prep4pass
Free A00-420 Exam Dumps to Improve Exam Score
NEW QUESTION # 25
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 # 26
What is CAS in SAS Viya?
- A. A data management tool
- B. A data visualization tool
- C. A programming language
- D. A distributed computing environment
Answer: D
NEW QUESTION # 27
In PROC CASUTIL, what does the LOAD FILE= statement do?
- A. It loads files from a file path on the CAS server to a CAS table.
- B. It loads the data from a CAS table to a file on the Compute Server.
- C. It loads a file from a file path on the Compute Server to a CAS table.
- D. It loads a file from a file location on the Compute Server to the CAS controller file system.
Answer: C
NEW QUESTION # 28
Which CAS action is used to generate a random sample from a CAS table?
- A. cas.sample
- B. cas.fetch
- C. cas.select
- D. cas.random
Answer: A
NEW QUESTION # 29
What data types does FedSQL support in CAS?
- A. INT64, CHAR(n), DOUBLE, INT32, VARBINARY, VARCHAR(n)
- B. CHAR(n), DOUBLE, VARCHAR(n), TIMESTAMP, DATE, TIME
- C. BIGINT, CHAR(n), DATE, DOUBLE, DECIMAL, VARBINARY
- D. INT64, CHAR(n), DOUBLE, INT32, VARCHAR(n), FLOAT
Answer: A
NEW QUESTION # 30
Using the altertable action, which is the correct statement to rename the make column to veh_make in a CAS table?
proc cas;
table.altertable / caslib="casuser", name="cars",
<enter code segment here>;
quit;
- A. columns={name="make" = "veh_make"};
- B. columns={{rename="make" , name="veh_make"}};
- C. columns=[[name="make" , rename="veh_make"]];
- D. columns={{name="make" , rename="veh_make"}};
Answer: D
NEW QUESTION # 31
Which program will successfully load cars.csv from the casuser caslib data source to an in-memory table named cars?
- A. proc cas;
table.loadTable /
caslib="casuser"
path="/home/&sysuserid/casuser/cars.csv"
casout={caslib="casuser", name="cars"};
quit; - B. proc cas;
table.loadTable /
incaslib="casuser"
casdata="/home/&sysuserid/casuser/cars.csv"
outcaslib="casuser"
casout="cars";
quit; - C. proc cas;
table.loadTable /
caslib="casuser"
path="cars.csv"
casout={caslib="casuser", name="cars"};
quit; - D. proc cas;
table.loadTable /
incaslib="casuser"
casdata="cars.csv"
outcaslib="casuser"
casout="cars";
quit;
Answer: C
NEW QUESTION # 32
You want to use the MEANS procedure to summarize data using the CAS server.
Which statement is true?
- A. All PROC MEANS statements are supported for CAS processing.
- B. You must sort the data before using BY-group processing on the CAS server.
- C. You must specify a CAS engine libref with the input table name.
- D. Statistics that are supported by PROC MEANS are also supported on the CAS server.
Answer: C
NEW QUESTION # 33
Which CAS action is used to sort a CAS table based on one or more variables?
- A. ALTER TABLE
- B. LOAD
- C. EXPORT
- D. SORT
Answer: D
NEW QUESTION # 34
Which CAS statement is used to load data from an external file into a CAS table?
- A. CASDATA
- B. CASIMPORT
- C. CASTABLE
- D. CASLIB
Answer: B
NEW QUESTION # 35
Which CAS-enabled procedure is used to perform text analytics?
- A. CASTEXT
- B. CASPROC
- C. CASTAT
- D. CASSENT
Answer: A
NEW QUESTION # 36
Which statement is used to read data from an external file into a SAS dataset?
- A. SET statement
- B. PROC SQL
- C. OUTPUT statement
- D. MERGE statement
Answer: A
NEW QUESTION # 37
The following SAS program is submitted:
What is the output to the log?
- A. A list of CAS sessions associated with the current user
- B. A NOTE with information about the new CAS session listsessions
- C. A syntax error
- D. A list of all active CAS sessions for all users
Answer: B
NEW QUESTION # 38
Which CAS-enabled procedure is used for frequency analysis and cross-tabulations?
- A. PROC GLM
- B. PROC FREQ
- C. PROC SQL
- D. PROC MEANS
Answer: B
NEW QUESTION # 39
The set parameter of the table.update CAS action requires a specific type of value.
Which type is correct?
- A. an array of dictionaries
- B. a dictionary of arrays
- C. an array of arrays
- D. a dictionary of dictionaries
Answer: A
NEW QUESTION # 40
Which Compute Server system option prevents inadvertently moving large in-memory tables to the Compute Server?
- A. MAXOBS=
- B. MAXDATA=
- C. NOCOMPUTE
- D. CASDATALIMIT=
Answer: D
NEW QUESTION # 41
Complete the CASL statement below to save the result stored in r to a SAS data set named class in the mylib library.
saveresult r _________ =mylib.class;
Answer:
Explanation:
Dataout
NEW QUESTION # 42
When specified on the PROC SUMMARY statement, which statistic causes processing to occur on the Compute Server?
- A. MEAN
- B. MIN
- C. STD
- D. SKEW
Answer: D
NEW QUESTION # 43
Which CAS-enabled procedure allows the creation of user-defined formats?
- A. PROC FORMAT
- B. PROC FREQ
- C. PROC SQL
- D. PROC MEANS
Answer: A
NEW QUESTION # 44
Which CAS-enabled procedure is used to perform market basket analysis?
- A. CASASSOC
- B. CASSTAT
- C. CASPROC
- D. CASMINER
Answer: A
NEW QUESTION # 45
Which DATA step function is used to concatenate character variables in CAS programming?
- A. CONCAT
- B. CATS
- C. LENGTH
- D. CAT
Answer: B
NEW QUESTION # 46
Which variables must be included in the CAS table that stores DATA step code to be executed by the dataStep.runCodeTable action?
- A. DataStepSrc
ModelName - B. PgmName
CASEngine - C. DataStepSrc
ModelName - D. Code
TableName - E. Source
Name
Answer: A
NEW QUESTION # 47
......
Powerful A00-420 PDF Dumps for A00-420 Questions: https://www.prep4pass.com/A00-420_exam-braindumps.html
2024 Realistic A00-420 Dumps Exam Tips Test Pdf Exam Material: https://drive.google.com/open?id=1NYibnnCV20uaHeroPR_GEV1UQAuWl3bp
