- All Exams Instant Download
Which Compute Server system option prevents inadvertently moving large in-memory tables to the Compute Server?
Which Compute Server system option prevents inadvertently moving large in-memory tables to the Compute Server?A . MAXDATA=B . CASDATALIMIT=C . NOCOMPUTED . MAXOBS=View AnswerAnswer: B
When specified on the PROC SUMMARY statement, which statistic causes processing to occur on the Compute Server?
When specified on the PROC SUMMARY statement, which statistic causes processing to occur on the Compute Server?A . MINB . MEANC . SKEWD . STDView AnswerAnswer: C
Which statement correctly creates a global caslib called mycas that is connected to the /workshop/data location?
Which statement correctly creates a global caslib called mycas that is connected to the /workshop/data location?A . caslib mycas path="/workshop/data" global;B . caslib path="/workshop/data" mycas global;C . caslib path="/workshop/data" mycas promote;D . caslib mycas path="/workshop/data" promote;View AnswerAnswer: A
Which statement is FALSE regarding loading data into CAS?
Which statement is FALSE regarding loading data into CAS?A . JSON files can be loaded directly into CAS.B . Excel files can be loaded directly into CAS.C . Data Connectors are required to load DBMS data directly into CAS.D . Both DATA step and PROC COPY can be used to...
In the space below, add 1 character to complete the syntax.
In the space below, add 1 character to complete the syntax. proc cas; table.tableDetails Answer aslib="casuser", name=employees"; quit;View AnswerAnswer: /
Which CASL program segment correctly defines a source block to be run from a subsequent action?
Which CASL program segment correctly defines a source block to be run from a subsequent action?A . source myCode; "data OutData; set casuser.cars; where ""make = 'Honda'""; run;" endsource;B . source myCode; "data OutData; set casuser.cars; where make = 'Honda'; run;" endsource;C . source myCode; data OutData; set casuser.cars; where make = 'Honda'; run; endsource;D . source myCode; "data OutData;" || "set casuser.cars;" || "where make = 'Honda';" || "run;" endsource;View AnswerAnswer:...
Which SQL clause is used to calculate summary statistics for variables in a CAS table?
Which SQL clause is used to calculate summary statistics for variables in a CAS table?A . SELECTB . FROMC . GROUP BYD . HAVINGView AnswerAnswer: C
Which type is correct?
The set parameter of the table.update CAS action requires a specific type of value. Which type is correct?A . an array of arraysB . a dictionary of arraysC . a dictionary of dictionariesD . an array of dictionariesView AnswerAnswer: D
What is the most efficient way to achieve this?
You want to generate totals and averages by year for a very large Teradata table using SAS Viya programming methods. What is the most efficient way to achieve this?A . Load the table into CAS memory and use a CAS procedure to summarize it.B . Summarize the data using a...
Which CAS action is used to generate a summary report of missing values in a CAS table?
Which CAS action is used to generate a summary report of missing values in a CAS table?A . cas.missingB . cas.validateC . cas.summaryD . cas.checkView AnswerAnswer: A
