A00-270 Online Practice Questions and Answers

When a SAS Web Report Studio report is built, the default behavior is to produce an aggregated report with measures summed. Average is a more appropriate aggregation for an age data item. In the information map, how can the aggregation be changed to average the measures?

A. Change the default aggregation function to MEAN on the Properties of the data item.

B. After the default aggregation is set, it cannot be changed in the information map.

C. Change the measure's classification to MEAN.

D. Change the format of the data item to AVERAGEw.d.

A stored process will be used to provide a dynamic data source for an information map. Which type of code is executed to query data from the information map?

A. Only the stored process code

B. Only the SQL code generated by the information map

C. First the stored process code followed by the SQL code generated by the information map

D. First the SQL code generated by the information map followed by the stored process code

At 1:00 PM, User A schedules the "Budget" report to run NOW in SAS Web Report Studio. At 2:00 PM,

User B attempts to distribute by email the same "Budget" report to run NOW.

Which statement is true?

A. The distribution task overwrites the schedule options.

B. User B's distribution task emails the results of User A's schedule without having to rerun the report.

C. User B needs to set the objects on the report to be independent to prevent overwriting User A's output.

D. User A and User B's actions do not affect one another.

Which application requires a SAS Information Map to access a SAS OLAP cube?

A. SAS Web Report Studio

B. SAS Enterprise Guide

C. Microsoft Excel

D. SAS OLAP Cube Studio

The required components of a SAS BI Dashboard are:

A. Data Model, Range, Indicator, and Dashboard

B. Data Model, OLAP Cube, Indicator, and Dashboard

C. Information Map, Indicator, Range, and Dashboard

D. Data Model, Stored Process, Indicator, Range, and Dashboard

Refer to the exhibit and note the error.

The data model for this SAS BI Dashboard has been built using a SAS Information Map. What is the reason for the error?

A. The SAS Information Map used as a data source does not have a measure defined.

B. The content developer does not have the ReadMetadata permission on the SAS Information Map.

C. The SAS Information Map was built using an OLAP Cube.

D. The gauge type for the indicator is not correct and needs to be changed.

Refer to the exhibit.

Which type of alert is being configured for the SAS BI Dashboard?

A. Personal Alert

B. Dashboard Alert

C. Indicator Alert

D. Data Alert

What can be used as a data source for a SAS BI Dashboard indicator data object? (Choose two)

A. An OLAP Cube

B. A SAS Stored Process

C. An Excel worksheet

D. A SAS information Map

Which item is NOT requiredfor a SASBIDashboard Custom Graph indicator?

A. Indicator data object

B. Display type

C. Indicator name

D. SAS folders storage location

Which client application can be used to register stored process metadata and run the stored process?

A. SAS Enterprise Guide

B. SAS Management Console

C. SAS Information Map Studio

D. SAS Add-In for Microsoft Office