SAS Institute A00-420 Exam Questions Simulate Actual A00-420 Exam

Category:

Comments:

0 Comments

Post Date:

December 23, 2024

A00-420 exam dumps questions are designed to simulate the actual exam. This means that you will get a feel for the types of questions you can expect to see on the exam, as well as the format and difficulty level. In addition, SAS Viya Programming Specialist A00-420 dumps are often accompanied by detailed explanations and answers. This means that if you get a question wrong, you can learn from your mistake and understand why the correct answer is the right one. Test free online A00-420 exam dumps below.

Page 1 of 8

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

noUniqueKeys

noDuplicateKeys

groupBy

uniqueOut

2. Which CAS action is used to rename variables in a CAS table?

cas.rename

cas.modify

cas.alter

cas.change

3. Which CASL program will create the sample2 table in the casuser caslib?

proc cas; datastep.runCode result=r/ code=" data casuser.sample2; set casuser.class; by age; if first.age then y=age; run; "; quit;

proc cas; datastep.runCode result=r/ code=" data casuser.sample2; set casuser.class(firstobs=3); run; "; quit;

proc cas; datastep.runCode result=r/ code=" data casuser.sample1; set casuser.class; y=1; run; data casuser.sample2; set casuser.class; y=2; run; "; quit;

proc cas; datastep.runCode result=r/ code=" data casuser.sample2; set casuser.class; y=ranuni(123)*100; run; "; run;

4. A CAS table has a CHAR column called FirstName with a length of 10.

How many bytes are used to store the value "Inez" in the column FirstName?

4 bytes

8 bytes

10 bytes

20 bytes

5. Which program will successfully load cars.csv from the casuser caslib data source to an in-memory table named cars?

proc cas; table.loadTable / caslib="casuser" path="cars.csv" casout={caslib="casuser", name="cars"}; quit;

proc cas; table.loadTable / incaslib="casuser" casdata="cars.csv" outcaslib="casuser" casout="cars"; quit;

proc cas; table.loadTable / incaslib="casuser" casdata="/home/&sysuserid/casuser/cars.csv" outcaslib="casuser" casout="cars"; quit;

proc cas; table.loadTable / caslib="casuser" path="/home/&sysuserid/casuser/cars.csv" casout={caslib="casuser", name="cars"}; quit;

6. Which PROC CAS step will transpose the CLASS table so that the values of the NAME column are used to create the column names in the output table?

proc cas; transpose.transpose / table={caslib="casuser",name="class"}, transpose={"name"}, casout={caslib="casuser", name="outclass", replace=true}; quit;

proc cas; transpose.transpose / table={caslib="casuser", name="class", groupby={name="name"}}, casout={caslib="casuser", name="outclass", replace=true}; quit;

proc cas; transpose.transpose / table={caslib="casuser", name="class"} , id={"name"}, casout={caslib="casuser", name="outclass", replace=true}; quit;

proc cas; transpose.transpose / table={caslib="casuser", name="class", orderby={name="name"}}, id={"age"}, casout={caslib="casuser", name="outclass", replace=true}; quit;

7. Which CAS action is used to split a string variable into multiple variables based on a delimiter in a CAS table?

cas.extract

cas.split

cas.parse

cas.separate

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

CAS server

SAS Studio

SAS Metadata Server

SAS Data Connector

9. Which CAS statement is used to perform summary statistics on a CAS table?

CASMEANS

CASTATS

CASUTIL

CASDESCRIBE

10. What is the primary purpose of using the DATA step in CAS programming?

Creating plots and graphs

Importing and exporting data

Performing complex statistical analyses

Transforming and manipulating data

Page 2 of 8

11. Which CAS statement is used to perform data manipulation operations like filtering and transforming data?

CASUTIL

CASTABLE

CASDATA

CASWHERE

12. Which SQL clause is used to filter rows in a CAS table based on specified conditions?

SELECT

FROM

WHERE

GROUP BY

13. Which CAS action is used to import data into CAS?

CASLIB

LOAD

EXPORT

ALTER TABLE

14. Which CAS action is used to identify potential duplicate records in a CAS table?

cas.duplicate

cas.identify

cas.verify

cas.check

15. Which CAS action is used to calculate the total count, distinct count, and missing count for variables in a CAS table?

cas.count

cas.unique

cas.missing

cas.summary

16. What is the purpose of the SAS Explorer in SAS Studio?

To manage and organize SAS files and folders

To visualize data in graphical format

To write and execute SAS programs

To perform data cleaning and transformation

17. How can you associate a user-defined format with a variable in SAS?

Using the FORMAT statement in the DATA step

Using the WHERE statement in PROC SQL

Using the BY statement in PROC FORMAT

Using the LABEL statement in PROC FORMAT

18. Which CAS-enabled procedure is used to fit regression models?

CASTAT

CASPROC

CASREG

CASANALYZE

19. Which CAS-enabled procedure is used to generate descriptive statistics for CAS tables?

CASTATS

CASMEANS

CASUTIL

CASDESCRIBE

20. Which data format should be used when saving a CAS table so that it will later load into CAS memory the fastest?

sashdat

sas7bdat

csv

txt

Page 3 of 8

21. Which statement will show all available caslibs in the log?

caslib listall;

caslib all list;

caslib list;

caslib _all_ list;

22. Which CAS action is used to calculate the mean, median, and quartiles for numeric variables in a CAS table?

cas.summary

cas.describe

cas.quantiles

cas.statistics

23. Which DATA step function is supported in CAS?

SYMGET

CATX

FILEREF

RANUNI

24. What CASL data type is created from the following assignment statement?

half = 1/2;

INT32

INT64

DOUBLE

DECIMAL

25. Which statement is used to sort a SAS dataset in ascending order?

SORT DESCENDING

PROC SORT

ORDER BY

SORT DSN

26. Which CASL statement correctly saves a SAS data set keeping only the empid and hrdate variables?

table.save / caslib="hr", exportoptions={filetype="basesas"}, name="hiredate", table={caslib="casuser", name="emp", keep={{name="empid"}, {name="hrdate"}}};

table.save / caslib="hr", exportoptions={filetype="sas7bdat"}, name="hiredate", table={caslib="casuser", name="emp", vars={{name="empid"}, {name="hrdate"}}};

table.save / caslib="hr", exportoptions={filetype="basesas"}, name="hiredate", table={caslib="casuser", name="emp", vars={"empid", "hrdate"}};

table.save / caslib="hr", exportoptions={filetype="sas7bdat"}, name="hiredate", table={caslib="casuser", name="emp", keep={"empid", "hrdate"}};

27. Which DATA step function is used to concatenate character variables in CAS programming?

LENGTH

CAT

CONCAT

CATS

28. Which CAS-enabled procedure is used to create user-defined formats?

CASFORMAT

CASPROC

CASLIB

CASUTIL

29. Which statement is used to create a new variable in SAS Viya?

IF-THEN statement

DROP statement

RENAME statement

LENGTH statement

30. Which CAS-enabled procedure is used for frequency analysis and cross-tabulations?

PROC MEANS

PROC SQL

PROC FREQ

PROC GLM

Page 4 of 8

31. Which CAS-enabled procedure allows the use of user-defined formats for data summarization?

PROC MEANS

PROC SQL

PROC FREQ

PROC FORMAT

32. Which CAS action is used to perform a cross-tabulation of two categorical variables in a CAS table?

cas.tabulate

cas.crosstab

cas.pivot

cas.summary

33. When submitted, this program runs normally on the Compute Server and produces a cross-tab report:

proc freq data=casuser.cars;

by descending origin;

table type*make / nocol

norow nopercent;

run;

What happens when this program is submitted instead?

proc freqtab data=casuser.cars;

by descending origin;

table type*make / nocol

norow nopercent;

run;

The program runs normally on the Compute Server and produces a cross-tab report.

The program runs normally on the CAS server and produces a cross-tab report.

The program produces an error indicating the DESCENDING option is not supported in the BY statement.

The program produces an error indicating the NOPERCENT option is not supported in the TABLE statement.

34. Which CAS object is used to store and manage data?

CASLIB

CASDATA

CASTABLE

CASSET

35. Employees is a 5,000 row table.

Which program executes in CAS using a single thread?

data casuser.employees /single=yes;    set work.employees;    totcomp = sum(salary,bonus); run;

data casuser.employees;    set work.employees;    by department;    totcomp = sum(salary,bonus); run;

data casuser.employees;    set casuser.employees;    by department;    totcomp = sum(salary,bonus); run;

data casuser.employees /single=yes;    set casuser.employees;    totcomp = sum(salary,bonus); run;

36. Which statement is used to read data from an external file into a SAS dataset?

PROC SQL

SET statement

MERGE statement

OUTPUT statement

37. Which CAS action is used to compute the frequency distribution of a categorical variable in a CAS table?

cas.frequency

cas.distribution

cas.histogram

cas.tabulate

38. Which PROC TRANSPOSE step will execute entirely in CAS?

proc transpose data=casuser.table out=casuser.table_transposed; id group; run;

proc transpose data=casuser.table out=work.table_transposed; id group; run;

proc transpose data=work.table out=casuser.table_transposed; id group; run;

proc transpose data=work.table out=work.table_transposed; id group; run;

39. Which CAS action is used to compute the frequency count of unique values in a column of a CAS table?

cas.count

cas.uniq

cas.distinct

cas.frequency

40. In SAS Viya, what is the purpose of the LIBNAME statement?

To create a new library

To import external data

To assign a library reference

To delete a library

Page 5 of 8

41. Which statements are true about CASL? (Select two)

CASL programs can include statements, actions, and functions.

CASL running in CAS is always faster than processing on the Compute Server.

CASL code is only written and submitted from SAS Studio.

CASL programs are best suited for processing very large data.

42. Which DATA step statement is used to read data from an external file in CAS programming?

PROC SQL

SET statement

MERGE statement

OUTPUT statement

43. Which CAS action is used to sort a CAS table based on one or more variables?

SORT

LOAD

EXPORT

ALTER TABLE

44. The following SAS program is submitted:

What is the output to the log?

A syntax error

A list of CAS sessions associated with the current user

A list of all active CAS sessions for all users

A NOTE with information about the new CAS session listsessions

45. Which statement correctly creates a global caslib called mycas that is connected to the /workshop/data location?

caslib mycas path="/workshop/data" global;

caslib path="/workshop/data" mycas global;

caslib path="/workshop/data" mycas promote;

caslib mycas path="/workshop/data" promote;

46. In SAS Viya, what is the purpose of the SAS Studio application?

To create interactive reports

To perform data visualization

To write and execute SAS programs

To build machine learning models

47. Which CAS action is used to generate descriptive statistics for numeric variables in a CAS table?

cas.summarize

cas.statistics

cas.describe

cas.profile

48. Which CAS action is used to merge two or more CAS tables based on a common key variable?

cas.combine

cas.append

cas.union

cas.merge

49. What is the purpose of the WHERE clause in CAS language programming?

To filter rows based on specified conditions

To define the input data source

To specify the output variables

To join multiple tables together

50. Which statement is true about the Compute Server?

It processes programs written in SAS, Python, Java, and other open source client languages.

It generally outperforms the CAS server for data sources that are larger than 50 Gigabytes.

It processes distributed data in multiple threads.

It supports the creation and execution of Macro programs.

Page 6 of 8

51. Which CAS action is used to generate a summary report of missing values in a CAS table?

cas.missing

cas.validate

cas.summary

cas.check

52. Which SAS Viya component provides self-service data preparation capabilities?

SAS Data Preparation

SAS Cloud Analytic Services (CAS)

SAS Studio

SAS Visual Analytics

53. Which CAS action is used to generate a random sample from a CAS table?

cas.sample

cas.fetch

cas.random

cas.select

54. Which CAS statement is used to select specific columns from a CAS table?

CASTABLE

CASSELECT

CASCOLUMN

CASWHERE

55. Which CAS-enabled procedure is used for descriptive statistics and data summarization?

PROC MEANS

PROC SQL

PROC FREQ

PROC GLM

56. Which CAS action is used to perform aggregations and summary statistics?

SUMMARY

AGGREGATE

DESCRIBE

SUMMARIZE

57. In which situation is it best to leverage the CAS server?

When you need to use the LASR procedure to access data.

When executing BY statements with high cardinality variables.

When using large data and computationally complex code.

When you need to SORT all of your data before processing.

58. Which CAS action is used to delete rows from a CAS table?

DELETE

DROP TABLE

EXPORT

ALTER TABLE

59. How can you rename a CAS table in CAS?

Using the RENAME action

Using the MODIFY action

Using the EXPORT action

Using the ALTER TABLE action

60. Which CAS action is used to create a new variable in a CAS table based on a conditional expression?

cas.derive

cas.calculate

cas.transform

cas.generate

Page 7 of 8

61. Which SAS Viya component allows users to run SAS code on a distributed grid?

SAS Studio

SAS Data Preparation

SAS Cloud Analytic Services (CAS)

SAS Visual Analytics

62. Which statement is true about the order of the rows in an output table produced by a DATA step running in CAS?

The order of the rows is guaranteed.

The order of the rows is not guaranteed.

The order of the rows is guaranteed if the ORDER=TRUE option is specified.

The order of the rows is guaranteed if the SINGLE=YES option is specified.

63. Which CAS action is used to convert a character variable to a numeric variable in a CAS table?

cas.convert

cas.cast

cas.change

cas.transform

64. Which statement is true about SAS Viya?

It contains the SAS launcher server, which is the primary server for processing big data.

It supports only single-threaded DATA step processing.

It can employ multiple servers to execute programs.

Its primary interface for submitting programs is the SAS Windowing Environment.

65. Which programming language is primarily used in SAS Viya?

Python

Java

SAS

66. DATA step performance in CAS is most affected:

when the NOTSORTED option is used in the BY statement.

when the DESCENDING option is used in the BY statement.

by the cardinality of the first variable listed in the BY statement.

when data is not sorted prior to using a BY statement.

67. What is the syntax for submitting a SAS Viya program in SAS Studio?

RUN;

EXECUTE;

SUBMIT;

PROCESS;

68. What is the purpose of the PROMOTE action in CAS?

To create an index on a CAS table

To promote a CAS table to an in-memory table

To convert a CAS table to a different format

To rename variables in a CAS table

69. Which CAS-enabled procedure is used to perform decision tree analysis on CAS tables?

CASFOREST

CASCART

CASCORR

CASFIT

70. The table casuser.employees is partitioned onto 3 CAS worker nodes.

Which SAS program will correctly accumulate a total of the salary variable and store it in the variable totalSalary?

A)

Option A

Option B

Option C

Option D

Page 8 of 8

71. Which CAS action is used to merge two or more CAS tables based on common variables?

MERGE

LOAD

EXPORT

ALTER TABLE

72. Which CAS action is used to create a new variable in the DATA step?

DROP

ALTER TABLE

COMPUTE

FORMAT

73. Which SAS Viya procedure is used for data exploration and analysis?

PROC SQL

PROC MEANS

PROC FREQ

PROC GLM

74. What is the purpose of the BY statement in CAS language programming?

To specify the output format

To merge multiple tables

To subset the data

To group data by one or more variables

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

CASMERGE

CASCOMBINE

CASTABLE

CASEJOIN

76. 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",

segment here>;

quit;

columns={name="make" = "veh_make"};

columns=[[name="make" , rename="veh_make"]];

columns={{rename="make" , name="veh_make"}};

columns={{name="make" , rename="veh_make"}};

77. The regnm format has been created and stored in an CAS format library.

Which program associates the format regnm with the region column in the orders table?

proc casutil; load data=work.orders casout="orders" outcaslib="public"; format region regnm.; quit;

proc casutil; load data=work.orders casout="orders" outcaslib="public" format=yes; format region regnm.; quit;

proc casutil; format region regnm.; load data=work.orders casout="orders" outcaslib="public" format=yes; quit;

proc casutil; format region regnm.; load data=work.orders casout="orders" outcaslib="public"; quit;

TAGS:

A00-420, A00-420 exam dumps

Notify of

Label

Name*

Email*

Website

Label

Name*

Email*

Website

0 Comments

Oldest

Newest Most Voted

Inline Feedbacks

View all comments

Get A00-420 Dumps Full Version

Q&As: 254
Versions: PDF and Software Download Now

About Dumpsinfo

Dumpsinfo is a good platform providing the latest exam information and dumps questions for all IT certification exams. You can study all the latest exam dumps questions online.

[email protected]

Mon - Sat 9:00am - 6:00pm

SAS Institute A00-420 Exam Questions Simulate Actual A00-420 Exam

Related

Posts

A00-415 Exam Dumps – Reliable Way to Pass and Get Certified

Online A00-485 Exam Dumps Help You Build Confidence

SAS Institute A00-470 Exam Questions Simulate Actual A00-470 Exam

Good A00-451 Exam Dumps Save Your Preparation Time

About Us

EMAIL

Services

Opening Hours