Independence Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

SAS Institute A00-270 SAS BI Content Developmentfor SAS 9 Exam Practice Test

Demo: 16 questions
Total 107 questions

SAS BI Content Developmentfor SAS 9 Questions and Answers

Question 1

Which statement is true about SAS BI Dashboard?

Options:

A.

All indicator display types can link to other content

B.

All indicator display types support the use of ranges

C.

All indicator display types automatically aggregate data

D.

All indicator display types provide Display Settings properties

Question 2

Which structure is not permitted in a SAS OLAP Cube design?

Options:

A.

A dimension with one hierarchy

B.

A dimension with two or more hierarchies that share the same level

C.

Two or more dimensions that have unique counts

D.

Two or more dimensions that are a TIME type dimensions

Question 3

What is the purpose of setting SAS Web Report Studio capabilities in SAS Management Console?

Options:

A.

control access to Information Maps

B.

control member level security

C.

control creation of CSS formats for custom report styles

D.

control which application features are available

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?

Options:

A.

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

B.

SAS Web Report Studio only supports these aggregations.

C.

These are the only aggregations supported for currency data items.

D.

The information map creator has limited the available aggregations.

Question 5

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?

Options:

A.

Set Metadata permissions on the filter.

B.

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

C.

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

D.

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

Question 6

What cannot be used to create reports and analysis using SAS Web Report Studio?

Options:

A.

SAS BI Dashboard

B.

SAS Stored Process

C.

SAS table

D.

SAS OLAP cube

Question 7

Which item in a cube becomes a category data item in an information map?

Options:

A.

Column

B.

Hierarchy

C.

Dimension

D.

Level

Question 8

Refer to the exhibit.

Which technique was used to produce the separate pie charts?

Options:

A.

Pie Subgroup from the Assign Data Window

B.

Multiple Pies from the Properties Window

C.

Grouped Pies from the Properties Window

D.

Horizontal Series from the Assign Data Window

Question 9

Refer to the exhibit.

Which type of content is Certification Exam.srx?

Options:

A.

SAS report

B.

stored process

C.

SAS package

D.

data exploration

Question 10

A stored process is created from all of the tasks in a SAS Create New Stored Process Wizard?

Options:

A.

The code is included from the metadata

B.

The code is included from the process flow

C.

The code is referenced from an external file

D.

The code is written manually

Question 11

A user is working in Microsoft Excel with the SAS Add-in. How can the user refresh all of their SAS content at the same time?

Options:

A.

Use the Reports dialog

B.

Reconnect to the metadata server

C.

Select the entire worksheet and click refresh

D.

Use the Manage Content dialog

Question 12

Which item is NOT required for a SAS BI Dashboard Custom Graph indicator?

Options:

A.

Indicator data object

B.

Display type

C.

Indicator name

D.

SAS folders storage location

Question 13

Which statement is true regarding the SAS My Folder metadata location?

Options:

A.

The My Folder location is a valid place to share content.

B.

Every user with a SAS metadata identity has a My Folder location.

C.

The My Folder location is a temporary work location.

D.

The My Folder location is only available to the user it belongs to.

Question 14

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?

Options:

A.

SAS Management Console

B.

SAS Data Integration Studio

C.

SAS Information Map Studio

D.

SAS Enterprise Guide

Question 15

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

Options:

A.

SAS Add-In for Microsoft Office

B.

SAS Information Map Studio

C.

SAS Management Console

D.

SAS OLAP Cube Studio

Question 16

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

Options:

A.

An OLAP Cube

B.

A SAS Stored Process

C.

An Excel worksheet

D.

A SAS information Map

Demo: 16 questions
Total 107 questions