Online Access Free A00-420 Exam Questions

When creating SAS graphs on extremely large CAS tables, the best practice is to:

• A.Summarize the data in CAS and work with the output on the Compute Server.
• B.Use the SGPLOT procedure on the CAS table.
• C.Enable multi-threading on the CAS server.
• D.Execute graph actions on the CAS tables.

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

• A.To visualize data in graphical format
• B.To perform data cleaning and transformation
• C.To manage and organize SAS files and folders
• D.To write and execute SAS programs

Which PROC TRANSPOSE step will execute entirely in CAS?

• A.proc transpose data=casuser.table out=casuser.table_transposed;
  id group;
  run;
• B.proc transpose data=work.table out=casuser.table_transposed;
  id group;
  run;
• C.proc transpose data=casuser.table out=work.table_transposed;
  id group;
  run;
• D.proc transpose data=work.table out=work.table_transposed;
  id group;
  run;

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

• A.To sort the result set
• B.To group rows based on common values
• C.To filter rows based on conditions
• D.To define the output columns

What data types does FedSQL support in CAS?

• A.INT64, CHAR(n), DOUBLE, INT32, VARBINARY, VARCHAR(n)
• B.BIGINT, CHAR(n), DATE, DOUBLE, DECIMAL, VARBINARY
• C.INT64, CHAR(n), DOUBLE, INT32, VARCHAR(n), FLOAT
• D.CHAR(n), DOUBLE, VARCHAR(n), TIMESTAMP, DATE, TIME