Online Access Free A00-415 Practice Test

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?

• A.No, because the CAS Controller randomly reads the casuser.eurorders table when processing the proc print.
• B.Yes, because by default CAS sorts the output table.
• C.Yes, because only one row will be printed.
• D.No, because each thread inserts a row into the casuser.eurorders table when it ends.

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

• A.PROC SGPLOT
• B.PROC FREQ
• C.PROC MEANS
• D.PROC SQL

You want to use the MEANS procedure to summarize data using the CAS server.
Which statement is true?

• A.Statistics that are supported by PROC MEANS are also supported on the CAS server.
• 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.All PROC MEANS statements are supported for CAS processing.

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

• A.Using the OPTIONS statement in PROC FORMAT
• B.Using the DEFINE statement in PROC SQL
• C.Using the FORMAT procedure in SAS Studio
• D.Using the FORMAT statement in the DATA step

Which statement is true for the table.copyTable action?

• A.The casout= parameter is required, but the table= parameter is not required.
• B.The table= parameter allows you to create calculated columns.
• C.Both the table= and casout= parameters are required to use the copyTable action.
• D.The table= parameter specifies the name of the table that you want to replace.