Labour Day Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Certensure Logo
  1. Home
  2. SAS Institute
  3. BI Content Developer
  4. A00-270 - SAS BI Content Developmentfor SAS 9

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

Demo: 16 questions
Total 107 questions
Get A00-270 Full Access Download A00-270 PDF

SAS BI Content Developmentfor SAS 9 Questions and Answers

Question 1

When a Stored process is created from a SAS Enterprise Guide process flow, where are prompt dependences defined?

Options:

A.

In the SAS program code

B.

In the Create a New Stored Process wizard

C.

In a Query Builder task

D.

In the Prompt Manager

Question 2

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?

Options:

A.

Publish to a publication channel.

B.

Export to .srx on the file system.

C.

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

D.

Publish to a report repository.

Question 3

Which SAS BI Dashboard indicator display type does not require a locator Data Object?

Options:

A.

Dynamic Text

B.

Dynamic Prompts

C.

Spark Table

D.

Custom Graph

Question 4

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 5

Refer to the exhibit.

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

Options:

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.

Question 6

A cube designer is creating a cube and has established the following dimension structure:

The cube designer would like to add the customer name and have it associated with the customer ID.

Which action should the cube designer take?

Options:

A.

Add a level attribute to the Customer_ID level

B.

Create a new hierarchy that contains Customer_Name instead of Customer_ID as a level

C.

Add a member property to the Customer_ID level

D.

Add Customer_NAME as a new level, placing if after Customer_ID in the hierarchy

Question 7

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?

Options:

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.

Question 8

Which capabilities are available when creating a SAS Information Map from a SAS OLAP Cube? (Choose two.)

Options:

A.

Associating a SAS Stored process with an information map that uses an OLAP Cube as a data source

B.

Simple filter creation

C.

Creating calculated members

D.

Joining multiple cubes within one information map

Question 9

Which statement is true about a cube with a drill through data source?

Options:

A.

The drill through data source remains in sync when performing an in-place update

B.

The drill through data source is updated by rerunning the PROC OLAP code

C.

The drill through data source can only be updated if flagged in the metadata

D.

The drill through data source is updated using a separate process

Question 10

Refer to the exhibit.

A SAS Information Map has been built with the SAS OLAP Cube that has been structured as shown in the exhibit.

You want to generate a SAS Web Report Studio report using the information map that contains the cube data.

Which selection is valid?

Options:

A.

AverageCostOfProduct, City Based, Zipcode Based, Product, Month Based, Quarter Based

B.

AverageCostOfProduct, City Based, Zipcode Based, Product, Month Based

C.

AverageCostOfProduct, City Based, Product, Month Based, Quarter Based

D.

AverageCostOfProduct, City Based, Product, Month Based

Question 11

A SAS task is performed in Microsoft Excel against 2 million rows of data in a table that is registered to the metadata sever. What is the maximum number of rows that can be processed?

Options:

A.

500

B.

65536

C.

2 million

D.

Excel's limitation based on the version of Excel

Question 12

A user saves a Microsoft PowerPoint presentation that has a SAS Stored Process in it. The user then emails the presentation to a co-worker who also has the SAS Add-In for Microsoft Office. When the co-worker opens the PowerPoint presentation, what happens to the stored process output?

Options:

A.

The output does not display.

B.

The output is static.

C.

The output can be refreshed.

D.

A prompt appears asking if the co-worker wants to refresh the stored process.

Question 13

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

Options:

A.

SAS Web Report Studio

B.

SAS Enterprise Guide

C.

Microsoft Excel

D.

SAS OLAP Cube Studio

Question 14

A SAS report has been created in SAS Enterprise Guide and made available to SAS Web Report Studio. Which alterations can be made to the report in SAS Web Report Studio?

Options:

A.

Only headers and footers can be changed.

B.

No changes can be made.

C.

Report objects can be moved or deleted.

D.

Additional report objects can be added.

Question 15

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

Options:

A.

Control member level security

B.

Control which application features are available

C.

Control who can log on to SAS Web Report Studio

D.

Control creation of CSS formats for custom report styles

Question 16

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

Load More A00-270 Questions
Demo: 16 questions
Total 107 questions
Get A00-270 Full Access Download A00-270 PDF