A00-270 Online Practice Questions and Answers

In the default configuration, which application does not prompt for user credentials?

A. SAS Add-In for Microsoft Office

B. SAS Information Map Studio

C. SAS Management Console

D. SAS OLAP Cube Studio

To implement a stored process, the content developer must write the programming code, register the stored process in the metadata and test the stored process. Which client application can be used to complete all three steps?

A. SAS Management Console

B. SAS Data Integration Studio

C. SAS Information Map Studio

D. SAS Enterprise Guide

In SAS Information Map Studio, where can you set the Initial Creation Rule for relationships between data sources?

A. Resources pane

B. Options window

C. Properties pane

D. Design tab

In SAS Information Map Studio, there is a date/time data item called MYDATE based on a physical column that displays as 24Mar2010:13:50:00. You are creating a prompt and don't want the time included. How can this be accomplished?

A. Apply a DATE7. format to the data item before building the prompt.

B. Apply the DATEPART() SAS function on the filter.

C. Apply a DATE7. format on the filter.

D. In the properties for MYDATE, change the type from Timestamp to Date.

Refer to the exhibit.

Why is there a warning icon in this bar-line chart in SAS Web Report Studio?

A. There are empty cells with no report objects.

B. The properties of the bar line chart have not been set.

C. The report has not been saved.

D. There are not enough measure data items.

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 item in a cube becomes a category data item in an information map?

A. Column

B. Hierarchy

C. Dimension

D. Level

A SAS Information Map is based on multiple relational tables.Which statement is true regarding the relationship?

A. The default join is an inner join

B. A relationship can be created only if column names in the data sources match

C. A relationship can be created even if the joining columns are different types

D. The default join created is a full outer join

Which component can be added to a Dashboard Object in a SAS BI Dashboard?

A. Static Label

B. Range

C. Dashboard

D. Dynamic Label

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