Note! Following A00-270 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

A00-270 Exam Dumps - SAS BI Content Developmentfor SAS 9

Go to page:

Question # 4

Refer to Exhibit:

A SAS Web Report Studio user is changing the summarization option for Annual Salary and the only aggregations allowed are Minimum and Maximum. Why is the list limited to only these two choices?

The user is assigned to a role that only allows these aggregations.

SAS Web Report Studio only supports these aggregations.

These are the only aggregations supported for currency data items.

The information map creator has limited the available aggregations.

Full Access

Question # 5

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

The default join is an inner join

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

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

The default join created is a full outer join

Full Access

Question # 6

A content developer has created a SAS report in SAS Enterprise Guide and wants it to be viewed in SAS Web Report Studio. How can this be accomplished?

Publish to a publication channel.

Export to .srx on the file system.

Open the SAS Enterprise Guide project in SAS Web Report Studio.

Publish to a report repository.

Full Access

Question # 7

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?

Only the stored process code

Only the SQL code generated by the information map

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

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

Full Access

Question # 8

A content developer created a filter in SAS Information Map Studio and wants to prevent anyone from selecting the filter in SAS Web Report Studio. How can this be accomplished?

Set Metadata permissions on the filter.

Deny the "View Filters" capability on a SAS Web Report Studio role.

Add the filter as a general prefilter in SAS Information Map Studio.

Select the "Hide from user" option on the filter in SAS Information Map Studio.

Full Access

Go to page: