A00-420 SAS Viya Intermediate Programming Exam Dumps

dumps2024-11-28T11:22:30+08:00

A00-420 SAS Viya Intermediate Programming exam is easy for you to pass now. There are 65-70 multiple choice and short-answer questions in real A00-420 exam, and you have 110 minutes to finish the test. The required passing score for SAS Viya Intermediate Programming A00-420 exam is 71%. SAS Certified Associate: Intermediate Programming Using SAS Viya certification expires after five years. We have cracked the latest SAS Viya Intermediate Programming A00-420 exam dumps, which can make sure you pass easily. Free SAS Viya Intermediate Programming A00-420 exam dumps are available below.

Page 1 of 8

1. Given the following SAS program:

data casuser.national;

   set casuser.baseball(where=(league='National'));

   r=ranuni(625);

   drop league;

run;

Why is the above program processed by the Compute Server rather than the CAS server?

The WHERE option is not supported in the SET statement.

The SESSREF= option is not specified in the DATA statement.

The DROP statement is not supported.

The RANUNI function is not supported.

2. Which CAS action is used to execute SQL queries in SAS CAS?

SQL

RUN

SUBMIT

EXECUTE

3. Which CAS statement is used to join two or more CAS tables based on a common key variable?

CASMERGE

CASTABLE

CASJOIN

CASCOMBINE

4. Which CAS action is used to perform data profiling to analyze the distribution of values in a CAS table?

cas.summarize

cas.profile

cas.statistics

cas.inspect

5. The following code is executed multiple times:

data casuser.eurorders;

  set casuser.orders end=eof;

  if Continent="Europe" then EurOrders+1;

  if eof=1 then output;

  keep EurOrders;

run;

proc print data=casuser.eurorders;

run;

Will the rows in the output table be sorted the same way for each execution and why? 

Yes, because only one row will be printed.

Yes, because by default CAS sorts the output table.

No, because each thread inserts a row into the casuser.eurorders table when it ends.

No, because the CAS Controller randomly reads the casuser.eurorders table when processing the proc print.

6. Which SAS Viya component allows users to create and manage machine learning models?

SAS Data Preparation

SAS Studio

SAS Visual Analytics

SAS Model Studio

7. Which SAS Viya procedure is used for data summarization and descriptive statistics?

PROC GLM

PROC MEANS

PROC FREQ

PROC SQL

8. Which function is used to calculate the mean of a variable in SAS Viya?

AVG

MEAN

SUM

MEDIAN

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

PROC SQL

SET statement

MERGE statement

OUTPUT statement

10. Which CAS action is used to calculate the correlation matrix for numeric variables in a CAS table?

cas.correlation

cas.covariance

cas.relationship

cas.association

Page 2 of 8

11. 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;

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

CASMERGE

CASCOMBINE

CASTABLE

CASEJOIN

13. Which variables must be included in the CAS table that stores DATA step code to be executed by the dataStep.runCodeTable action?

PgmName CASEngine

Code TableName

Source Name

DataStepSrc ModelName

14. Which CAS action is used to create a new CAS table based on specified conditions?

FILTER

SELECT

WHERE

SUBSET

15. Which DATA step will NOT run in CAS?

data casuser.class;   input x;   datalines; 1 2 3 ; run;

data casuser.new;   x=1; run;

data casuser.new;   set casuser.class;   x=((height*weight)+10)/(age**2)+round(100.9999); run;

data casuser.new;   array test(*) weight height age (1 2 3);   do i=1 to dim(test);     put test(i)=;   end; run;

16. What is the purpose of the LIBNAME statement in SAS Viya?

Defining a library or a location for SAS datasets

Declaring and initializing variables

Executing SQL queries

Controlling the flow of the program

17. Which PROC CASUTIL step suppresses error messages if the table is not found in-memory?

Option A

Option B

Option C

Option D

18. 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

19. In the following code, complete the PRINT statement to print only rows where column begins with MPG:

proc cas;

simple.summary result=res /

table={name="cars"};

resultTable = res.summary;

print <insert code segment

here>;

run;

resultTable.where(column like 'MPG%')

resultTable.where("column like 'MPG%'")

resultTable / where("column like 'MPG%'")

resultTable / where(column like 'MPG%')

20. Which CAS-enabled procedure is used to import data into a CAS table?

CASLIB

CASIMPORT

CASDATA

CASTABLE

Page 3 of 8

21. Which CAS-enabled procedure is used for regression analysis and modeling?

PROC MEANS

PROC SQL

PROC FREQ

PROC GLM

22. Which PROC CASUTIL step correctly saves a CSV file in the casuser caslib and overwrites any files with the same name?

proc casutil;   save casdata="employees" incaslib="casuser"     outcaslib="casuser" casout="out_employees.csv" replace; quit;

proc casutil;   save casdata="employees" incaslib="casuser"     outcaslib="casuser" casout="out_employees.csv"; quit;

proc casutil;   save type="csv" casdata="employees" incaslib="casuser"     outcaslib="casuser" casout="out_employees"; quit;

proc casutil;   save type="csv" casdata="employees" incaslib="casuser"     outcaslib="casuser" casout="out_employees" replace; quit;

23. Complete the following FedSQL code to convert the character variable markup to a numeric variable.

proc cas;

session mysess;

fedSql.execDirect /

query="create table casuser.cars_fedsql {options replace=true} as

select make, model, mpg_city, mpg_highway, <insert code segment here> as

markup_N

from casuser.cars";

run;

put(markup,'best12.')

inputn(markup,'best12.')

cast(markup,'best12.')

input(markup,'best12.')

24. 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

25. 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;

26. The dataPreprocess.impute action preforms data matrix (variable) imputation.

Which imputation methods can be used?

MIDRANGE, MODE, RANDOM, VALUE

MIDRANGE, MODE, RANDOM, CUSTOM

MODE, RANDOM, VALUE, CUSTOM

MIDRANGE, RANDOM, VALUE, CUSTOM

27. 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.

28. Which CAS action is used to create a new CAS table by concatenating two or more existing CAS tables?

cas.join

cas.concat

cas.combine

cas.merge

29. Which Compute Server system option prevents inadvertently moving large in-memory tables to the Compute Server?

MAXDATA=

CASDATALIMIT=

NOCOMPUTE

MAXOBS=

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

SELECT

FROM

WHERE

GROUP BY

Page 4 of 8

31. Which CAS-enabled procedure is used to apply user-defined formats to variables?

CASUTIL

CASTABULATE

CASFORMAT

CASPROC

32. Which SAS Viya procedure is used for statistical modeling and regression analysis?

PROC GLM

PROC MEANS

PROC FREQ

PROC SQL

33. Which statement about the CASL language is true?

All CAS-enabled procedures are converted to CASL behind the scenes to run in CA

CASL runs actions on both the SAS Compute Server and in CA

Actions in CASL are grouped into PROCs, and optional information is provided with parameters.

CASL code is submitted to the CAS server using PROC CASUTI

34. Which PROC MDSUMMARY step produces results?

proc mdsummary data=casuser.orders; var profit; output out=casuser.sumorders; run;

proc mdsummary data=casuser.orders; var profit; out casuser.sumorders; run;

proc mdsummary data=casuser.orders; var profit / out=casuser.sumorders; run;

proc mdsummary data=casuser.orders; var profit; run;

35. 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

36. Which CAS action is used to validate the integrity of relationships between variables in a CAS table?

cas.integrity

cas.relationship

cas.validate

cas.link

37. How can you view the contents of a CAS table?

Using the CASLIB action

Using the LOAD action

Using the FETCH action

Using the TABLE action

38. Complete the SAS program below to generate a table named cost_cont in the casuser caslib that contains the statistics for each value of continent.

proc mdsummary data=casuser.orders;

var cost;

groupby continent /_______;

run;

39. 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

40. 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 5 of 8

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

cas.summarize

cas.statistics

cas.describe

cas.profile

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

SAS Data Preparation

SAS Cloud Analytic Services (CAS)

SAS Studio

SAS Visual Analytics

43. Which CAS action is used to calculate the sum, minimum, maximum, and mean for numeric variables in a CAS table?

cas.aggregate

cas.statistics

cas.summarize

cas.describe

44. Which operator is used for assignment in SAS Viya?

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

cas.frequency

cas.distribution

cas.histogram

cas.tabulate

46. Which statement is FALSE regarding loading data into CAS?

JSON files can be loaded directly into CA

Excel files can be loaded directly into CA

Data Connectors are required to load DBMS data directly into CA

Both DATA step and PROC COPY can be used to load data into CA

47. Which CAS action is used to calculate the mode(s) of a categorical variable in a CAS table?

cas.modes

cas.frequencies

cas.distribution

cas.tabulate

48. What is the purpose of the BY statement in the DATA step?

To sort the data

To subset the data

To rename variables

To merge datasets

49. 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

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

CASTABLE

CASSELECT

CASCOLUMN

CASWHERE

Page 6 of 8

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

PROC MEANS

PROC SQL

PROC FREQ

PROC GLM

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

caslib listall;

caslib all list;

caslib list;

caslib _all_ list;

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

SUMMARY

AGGREGATE

DESCRIBE

SUMMARIZE

54. The set parameter of the table.update CAS action requires a specific type of value.

Which type is correct?

an array of arrays

a dictionary of arrays

a dictionary of dictionaries

an array of dictionaries

55. Which CASL program correctly adds the Sales caslib to access data in the /data/sales folder?

proc cas; table.addCaslib / name="sales", path="/data/sales"; run;

proc cas; table.addCaslib / name="sales", dataSource={srctype="path"}, path="sales"; run;

proc cas; table.addCaslib / name="/data/sales", dataSource={srctype="path"}; run;

proc cas; table.addCaslib, name="/data/sales", path="/data/sales"; run;

56. What is the purpose of the SET statement in the DATA step?

To define the input data source

To create a new variable

To specify conditional logic

To apply formatting to variables

57. Which statement can execute successfully using PROC FEDSQL?

create table work.age12 as select Name, Height, Weight    from casuser.class    where age=12 ;

select Species, SepalWidth, SepalLength    from casuser.iris    where Species ^= "Setosa" ;

select HouseID, Brand, exp(logPrice) as Price    from casuser.margarin    where calculated Price > 5 ;

create table casuser.incomplete as select AgeAtStart, Height, cholesterol, Chol_Status    from casuser.heart    where cholesterol is null ;

58. In PROC CASUTIL, what does the LOAD FILE= statement do?

It loads files from a file path on the CAS server to a CAS table.

It loads a file from a file location on the Compute Server to the CAS controller file system.

It loads a file from a file path on the Compute Server to a CAS table.

It loads the data from a CAS table to a file on the Compute Server.

59. 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

60. 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

Page 7 of 8

61. Which SAS function is used to concatenate character variables?

LENGTH

CAT

CONCAT

CATS

62. 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

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

CAS server

SAS Studio

SAS Metadata Server

SAS Data Connector

64. Which CASL program segment correctly defines a source block to be run from a subsequent action?

source myCode; "data OutData; set casuser.cars; where ""make = 'Honda'""; run;" endsource;

source myCode; "data OutData; set casuser.cars; where make = 'Honda'; run;" endsource;

source myCode; data OutData; set casuser.cars; where make = 'Honda'; run; endsource;

source myCode; "data OutData;" || "set casuser.cars;" || "where make = 'Honda';" || "run;" endsource;

65. What is the file extension used for SAS Viya programs?

sas

sql

viya

66. Which CAS action is used to perform outlier detection on numeric variables in a CAS table?

cas.detect

cas.identify

cas.outlier

cas.anomaly

67. Which SAS Viya component is responsible for storing and managing user-defined formats?

CAS server

SAS Studio

SAS Metadata Server

SAS Data Connector

68. What is the primary advantage of using CAS language programming in SAS?

Faster data processing

Improved visualization capabilities

Easier data exploration

Advanced statistical modeling techniques

69. Which CAS-enabled procedure is used to perform data partitioning?

CASPARTITION

CASDATA

CASTABULATE

CASPROC

70. Which SAS program will list tables contained in caslib public?

proc casutil; list tables caslib="public"; quit;

proc casutil; list caslib="public"; quit;

proc casutil caslib="public"; contents; quit;

proc casutil incaslib="public"; list tables; quit;

Page 8 of 8

71. Which CAS-enabled procedure is used to perform text analytics?

CASTEXT

CASPROC

CASTAT

CASSENT

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

half = 1/2;

INT32

INT64

DOUBLE

DECIMAL

73. Which programming language is used for SQL programming in SAS CAS?

SAS

SQL

Python

74. Which programming language is used in the DATA step of SAS CAS?

SAS

SQL

Python

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

SORT DESCENDING

PROC SORT

ORDER BY

SORT DSN

76. Which CAS action is used to retrieve a subset of rows and columns from a CAS table?

cas.fetch

cas.sample

cas.filter

cas.select

77. 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

A00-420 SAS Viya Intermediate Programming Exam Dumps

A00-420 SAS Viya Intermediate Programming Exam Dumps

Share this post

Related Posts