Labour Day Special - 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sdisc65

Note! A00-270 has been withdrawn.

A00-270 Practice Exam Questions with Answers SAS BI Content Developmentfor SAS 9 Certification

Question # 6

A dashboard shows a horizontal row of three static Traffic Light gauges. Each Traffic Light gauge is positioned vertically instead of horizontally.

What should be done to position each gauge horizontally?

A.

Select Flip Horizontal on the gauge properties.

B.

Ensure the dashboard and indicator are the correct width to display three gauges.

C.

Reduce the display size of the gauge sufficiently to allow all three to fit.

D.

Change to a gauge type that supports horizontal display of multiple gauges.

Full Access
Question # 7

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.

Full Access
Question # 8

Refer to the exhibit.

A00-270 question answer

A00-270 question answer

An identity filter based on SAS identityGroups is applied to the Mydata.Class table.

How many rows will be returned when UserA uses the map to see a detail listing?

A.

3

B.

2

C.

4

D.

6

Full Access
Question # 9

Refer to the exhibit and note the error.

A00-270 question answer

The data model for this SAS BI Dashboard has been built using a SAS Information Map.

What is the reason for the error?

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.

Full Access
Question # 10

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

A.

XLS

B.

DOC

C.

HTML

D.

PDF

Full Access
Question # 11

When using SAS Web Report Studio, which data item property needs to be set so that the data item is always automatically included when you open the Information Map directly?

A.

Default Query

B.

Mandatory Query

C.

Automatic Query

D.

Enforced Queue

Full Access
Question # 12

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

A.

SAS BI Dashboard

B.

SAS Stored Process

C.

SAS table

D.

SAS OLAP cube

Full Access
Question # 13

In which application can you create shared prompts?

A.

SAS Management Console

B.

SAS Enterprise Guide

C.

SAS Information Map Studio

D.

SAS Web Report Studio

Full Access
Question # 14

A SAS Information Map is based on multiple relational tables.

Which statement is true regarding joins between them?

A.

The default join created is a full outer join.

B.

The default join is an inner join.

C.

A Cartesian product is created by default.

D.

Join conditions once created cannot be modified in an information map.

Full Access
Question # 15

Which SAS code statement is defined by the Library metadata object?

A.

The LIBNAME statement

B.

The FILENAME statement

C.

The PROC METALIB statement

D.

The OPTIONS statement

Full Access
Question # 16

When a SAS Web Report Studio report is built, the default behavior is to produce an aggregated report with measures summed. Average is a more appropriate aggregation for an age data item. In the information map, how can the aggregation be changed to average the measures?

A.

Change the default aggregation function to MEAN on the Properties of the data item.

B.

After the default aggregation is set, it cannot be changed in the information map.

C.

Change the measure's classification to MEAN.

D.

Change the format of the data item to AVERAGEw.d.

Full Access