A00-415 SAS Viya Fundamentals of Programming Exam Dumps

dumps2024-11-30T10:02:03+08:00

A00-415 exam is one for SAS Certified Associate: Programming Fundamentals Using SAS Viya certification. If you decide to get this certification, the following A00-415 exam information is useful in your preparation. There are 50-55 multiple choice and short-answer questions in real A00-415 exam, and you have 95 minutes to finish the test. The required passing score for A00-415 exam is 68%. The certification is valid for 5 years. We provide the latest SAS Viya Fundamentals of Programming A00-415 exam dumps, which are the best material for you to study. Free SAS Viya Fundamentals of Programming A00-415 exam dumps are available below.

Page 1 of 8

1. Which CAS action is used to load data from an external file into a CAS table?

cas.load

cas.fetch

cas.upload

cas.import

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

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

SORT DESCENDING

PROC SORT

ORDER BY

SORT DSN

4. Given the following SAS program?

caslib _all_ assign;

proc sgplot data=casuser.cars;

vbar Make;

run;

What will the program do?

Produce an error because the SGPLOT procedure cannot access the CAS table.

Execute the SGPLOT procedure on the CAS server.

Summarize the results in CAS and process the summarized results on the Compute Server.

Transfer the data to the Compute Server and then execute the SGPLOT procedure.

5. Which statement is true for the table.copyTable action?

Both the table= and casout= parameters are required to use the copyTable action.

The table= parameter specifies the name of the table that you want to replace.

The table= parameter allows you to create calculated columns.

The casout= parameter is required, but the table= parameter is not required.

6. Which CAS action is used to delete a CASLIB?

CASLIB

DROP TABLE

EXPORT

ALTER TABLE

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

Python

Java

SAS

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

9. Which PROC CASUTIL statement successfully applies the regnm format to the Region column of the sales table in the public caslib?

altertable caslib="public" casdata="sales" columns={name="Region" format="regnm."};

altertable incaslib="public" table="sales" columns={{name="Region" format="regnm."}};

altertable incaslib="public" casdata="sales" columns={{name="Region" format="regnm."}};

altertable caslib="public" table="sales" columns={name="Region" format="regnm."};

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

DELETE

DROP TABLE

EXPORT

ALTER TABLE

Page 2 of 8

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

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

13. Which statement about CASL is true?

CASL is a replacement for the DATA Step.

CASL allows you to run any CAS action.

CASL is an open source language.

CASL is a replacement for SQ

14. Which CAS action is used to delete a CAS table from memory?

cas.delete

cas.remove

cas.drop

cas.discard

15. Which CAS statement is used to load data from an external file into a CAS table?

CASLIB

CASTABLE

CASIMPORT

CASDATA

16. How can you define a user-defined format in SAS?

Using the FORMAT statement in the DATA step

Using the DEFINE statement in PROC SQL

Using the OPTIONS statement in PROC FORMAT

Using the FORMAT procedure in SAS Studio

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

SAS Data Preparation

SAS Studio

SAS Visual Analytics

SAS Model Studio

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

PROC MEANS

PROC SQL

PROC FREQ

PROC FORMAT

19. Given the following SAS program:

proc mdsummary data=casuser.orders;

var RetailPrice;

output out=casuser.orders_sum;

run;

Which CAS action produces the same result as the code above without ERROR if you run it twice?

proc cas; simple.summary / table={name="orders", caslib="casuser"}, input={"RetailPrice"}, casOut={name='orders_sum'}; quit;

proc cas; simple.mdsummary / table={name="orders", caslib="casuser"}, input={"RetailPrice"}, casOut={name='orders_sum', replace=true}; quit;

proc cas; simple.summary / table={name="orders", caslib="casuser"}, input={"RetailPrice"}, casOut={name='orders_sum', replace=true}; quit;

proc cas; md.summary / table={name="orders", caslib="casuser"}, input={"RetailPrice"}, casOut={name='orders_sum'}; quit;

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

Page 3 of 8

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

MAXDATA=

CASDATALIMIT=

NOCOMPUTE

MAXOBS=

22. What does CAS stand for in CAS language programming?

Centralized Analytical System

Cloud Analytic Services

Clustered Analytical Server

Computerized Analytical Software

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

CASTATS

CASMEANS

CASUTIL

CASDESCRIBE

24. What is the main purpose of the DATA step in SAS Viya?

Creating plots and graphs

Importing and exporting data

Performing statistical analysis

Transforming and manipulating data

25. Given the following array: x={"May", "August", "September"};

What is the correct reference to the element containing the value May?

x[0]

x[1]

x.get(0)

x.get(1)

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

27. Which procedure can run in CAS?

PROC SQL

PROC GCHART

PROC SGRENDER

PROC MEANS

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

29. Which CAS action is used to calculate the frequency and percentage of values for categorical variables in a CAS table?

cas.frequencies

cas.counts

cas.histogram

cas.summary

30. 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};

Page 4 of 8

31. Which DATA step function is supported in CAS?

SYMGET

CATX

FILEREF

RANUNI

32. Which code can be used to load a SAS data set, sashelp.cars, into caslib public?

proc casutil; load data=sashelp.cars caslib=public; quit;

proc casutil; load data=sashelp.cars outcaslib="public"; quit;

libname public cas sessref=public; data public.cars; set sashelp.cars; run;

data public.cars / sessref=casuser; set sashelp.cars; run;

33. What is the purpose of the VALUE statement in PROC FORMAT?

To define the range of values for a format

To specify the format name and type

To define the appearance of formatted values

To assign a format to a variable

34. Which DATA step feature is NOT supported in CAS?

DO Loops

GIT functions

Arrays

IF-THEN/ELSE statements

35. Which CAS-enabled procedure is used to perform market basket analysis?

CASMINER

CASPROC

CASASSOC

CASSTAT

36. Which CASL program correctly runs two DATA step programs that are stored in separate source blocks named Program1 and Program2?

proc cas; dataStep.RunCode / code=("Program1", "Program2"); quit;

proc cas; dataStep.RunCode / code=Program1; dataStep.RunCode / code=Program2; quit;

proc cas; dataStep.RunCode / code=source(Program1, Program2); quit;

37. Which SQL clause is used to calculate summary statistics for variables in a CAS table?

SELECT

FROM

GROUP BY

HAVING

38. Which CAS action is used to perform a join operation between two CAS tables based on a common key variable?

cas.merge

cas.join

cas.link

cas.combine

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

SAS

SQL

Python

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

cas.summarize

cas.statistics

cas.describe

cas.profile

Page 5 of 8

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

PROC MEANS

PROC SQL

PROC FREQ

PROC GLM

42. Which statement will display column name, type, label and format information for the clientes table in the casuser caslib?

table.tableInfo / table={caslib="casuser", name="clientes"};

table.columnInfo / table={caslib="casuser", name="clientes"};

table.tableInfo / caslib="casuser", name="clientes";

table.columnInfo / caslib="casuser", name="clientes";

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

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

LENGTH

CAT

CONCAT

CATS

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

46. What is the purpose of the GROUP BY clause in SQL programming?

To sort the result set

To filter rows based on conditions

To define the output columns

To group rows based on common values

47. 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?

options msglevel=n; data casuser.class2(where=(Age>15));    set casuser.class; run;

options msglevel=verbose; data casuser.class2(where=(Age>15));    set casuser.class; run;

options msglevel=i; data casuser.class2(where=(Age>15));    set casuser.class; run;

data casuser.class2(where=(Age>15));    set casuser.class; run;

48. Which CAS action is used to execute a DATA step program in SAS CAS?

DATA

RUN

SUBMIT

EXECUTE

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

50. Which of the following statements about the CAS server is true?

CAS data is AES256 encrypted by default.

CAS can execute R programs.

CAS integrates with many open source languages.

CAS natively runs base SAS programs.

Page 6 of 8

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

52. Which CAS-enabled procedure is used for data exploration and visualization?

PROC MEANS

PROC SQL

PROC FREQ

PROC SGPLOT

53. What is the primary programming language used in SAS Viya?

SAS

Python

Java

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

SAS Data Preparation

SAS Cloud Analytic Services (CAS)

SAS Studio

SAS Visual Analytics

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

SELECT

FROM

WHERE

GROUP BY

56. Which CAS action is used to calculate summary statistics for variables in a CAS table?

cas.describe

cas.stats

cas.summary

cas.aggregate

57. What is CAS in SAS Viya?

A programming language

A data management tool

A distributed computing environment

A data visualization tool

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

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

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

Page 7 of 8

61. Which CAS action is used to calculate the standard deviation, variance, and range for numeric variables in a CAS table?

cas.stddev

cas.variance

cas.range

cas.statistics

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

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

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

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

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

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

AVG

MEAN

SUM

MEDIAN

64. Assume all caslib names follow libref naming conventions.

Which code assigns librefs of the same name to each caslib?

caslib _all_ assign;

caslib assign _all_;

caslib libref assign;

caslib assign libref;

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

PROC MEANS

PROC SQL

PROC FREQ

PROC GLM

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

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

68. Which program will display ODS output?

proc cas; print casuser.class; quit;

proc cas; simple.summary / table={caslib="casuser" name="class"}; quit;

proc mdsummary data=casuser.class; var height; output out=casuser.result; run;

proc cas; table.fetch result=r / table={caslib="casuser" name="class"}; quit;

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

DROP

ALTER TABLE

COMPUTE

FORMAT

70. Which CAS-enabled procedure is used to perform clustering analysis on CAS tables?

CASSTAT

CASCLUSTER

CASKMEANS

CASPROC

Page 8 of 8

71. Which CAS action is used to append rows to an existing CAS table?

APPEND

LOAD

EXPORT

ALTER TABLE

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

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

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

75. Given the following program:

data casuser.noInput / sessref=casauto;

   x=1;

run;

Which statement is true?

The DATA step runs on the SAS Compute Server.

The DATA step runs in CA

The DATA step runs on the SAS Workspace Server.

The DATA step produces an error.

76. Which programming language is primarily used in CAS?

Python

Java

SAS

77. Which CAS action is used to filter rows in a CAS table based on specified conditions?

cas.select

cas.filter

cas.where

cas.subset

A00-415 SAS Viya Fundamentals of Programming Exam Dumps

A00-415 SAS Viya Fundamentals of Programming Exam Dumps

Share this post

Leave a Reply Cancel reply

Related Posts