A00-270 SAS BI Content Development (Exam 2)

Questions
Reviews

Refer to the exhibit.Why is there a warning icon in this bar-line chart in SAS Web...

Refer to the exhibit.
Why is there a warning icon in this bar-line chart in SAS Web Report Studio?

There are empty cells with no report objects.

There are not enough measure data items.

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

The report has not been saved.
A user saves a Microsoft PowerPoint presentation that has a SAS Stored Process in ...

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?

The output does not display.

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

The output is static.

The output can be refreshed.
When saving a report in SAS Web Report Studio, what is a valid output type?

When saving a report in SAS Web Report Studio, what is a valid output type?

XLS

PDF

DOC

HTML
In which application can you define shared prompt groups?

In which application can you define shared prompt groups?

SAS Management Console

SAS Web Report Studio

SAS BI Dashboard

SAS Information Map Studio
A content developer has created a SAS report in SAS Enterprise Guide and wants it ...

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.

Publish to a report repository.

Export to .srx on the file system.

Open the SAS Enterprise Guide project in SAS Web Report Studio.
A content developer links from a SAS report in SAS Web Report Studio and passes va...

A content developer links from a SAS report in SAS Web Report Studio and passes values to another
report. What must the receiving report have in order to use the passed value?

a prompted filter based on the received value

a data item of the same name as the value being passed

a List or Crosstab Report Object

a section for each possible value to be received
Which statement is true regarding linking to a report with multiple sections in SA...

Which statement is true regarding linking to a report with multiple sections in SAS Web Report Studio?

The report creator can only choose to link to the first section.

The report creator can choose multiple sections to display when creating the report link.

The report creator cannot establish a link to a section that only has a Stored Process object.

The report creator can choose any one section to display when creating the report link.
What is the purpose of setting SAS Web Report Studio capabilities in SAS Managemen...

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

control access to Information Maps

control which application features are available

control member level security

control creation of CSS formats for custom report styles
At 1:00 PM, User A schedules the "Budget" report to run NOW in SAS Web Report Stud...

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?

The distribution task overwrites the schedule options.

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

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

User B needs to set the objects on the report to be independent to prevent overwriting User A's output.
Which item is NOT saved as part of a report template in SAS Web Report Studio?

Which item is NOT saved as part of a report template in SAS Web Report Studio?

Banner Header

Section names

Information Map name

Report Objects used
In SAS Web Report Studio, when distributing a report, what are the email output op...

In SAS Web Report Studio, when distributing a report, what are the email output options? (Choose two.)

SAS report

PDF

HTML

RTF
In which application can you create shared prompts?

In which application can you create shared prompts?

SAS Management Console

SAS Web Report Studio

SAS Enterprise Guide

SAS Information Map Studio
A user wants to see the most current information each time the report is opened in...

A user wants to see the most current information each time the report is opened in SAS Web Report
Studio. How can this be accomplished?

Save the report as data is automatically refreshed.

Save the report as data can be manually refreshed.

Schedule the report and view the results after it is executed.

Select the Refresh Data button when viewing the report.
When you create a link from a SAS report in SAS Web Report Studio, which entity ca...

When you create a link from a SAS report in SAS Web Report Studio, which entity can you directly link to?

a SAS Enterprise Guide project

an information map

a web page

a SAS BI Dashboard display
A SAS report has been created in SAS Enterprise Guide and made available to SAS We...

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?

Only headers and footers can be changed.

Additional report objects can be added.

No changes can be made.

Report objects can be moved or deleted.
Refer to the exhibit.A SAS Information Map has been built with the SAS OLAP Cube t...

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?

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

AverageCostOfProduct, City Based, Product, Month Based

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

AverageCostOfProduct, City Based, Product, Month Based, Quarter Based
Refer to the exhibit.Why is the list report icon (first icon in the object list) g...

Refer to the exhibit.
Why is the list report icon (first icon in the object list) grayed out?

The list report object is only available in the Report Wizard.

Not enough measures are selected.

The list report object cannot be used in the same section as OLAP data.

Not enough hierarchies are selected.
Which language is used to query SAS OLAP Cubes?

Which language is used to query SAS OLAP Cubes?

SQL

O-SQL

OLE DB for OLAP

MDX
The customer wants to build a SAS OLAP Cube from data stored in separate dimension...

The customer wants to build a SAS OLAP Cube from data stored in separate dimension and a fact table.
What type of input would be used to build the customer cube?

Star schema

Information map

Detail table

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

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

SAS Web Report Studio

SAS OLAP Cube Studio

SAS Enterprise Guide

Microsoft Excel

Be the first to review

Take this Quiz

Quiz Info
Feb. 8, 2016, 4:29 a.m.

20 questions

0 completed

23 views

0 takers

SAS INSTITUTE

Business Intelligence

A00-270 SAS BI Content Development (Exam 2) QR code

Ratings

ratings