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

Hot Vendors
  1. Home
  2. SAS Institute
  3. BI Content Developer
  4. A00-270
  5. SAS BI Content Developmentfor SAS 9 Questions and Answers
Note! The A00-270 Exam is no longer available.

A00-270 SAS BI Content Developmentfor SAS 9 Questions and Answers

Questions 4

In a stored process, a multiple value prompt selection named Country is used. Which macro variable can a developer use in SAS code to determine how many values the user selected?

Options:

A.

Country_COUNT

B.

Country_INDEX

C.

Country_NUM

D.

Country_NUNIQUE

Buy Now
Questions 5

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

Buy Now
Questions 6

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?

Options:

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.

Buy Now
Questions 7

The required components of a SAS BI Dashboard are:

Options:

A.

Data Model, Range, Indicator, and Dashboard

B.

Data Model, OLAP Cube, Indicator, and Dashboard

C.

Information Map, Indicator, Range, and Dashboard

D.

Data Model, Stored Process, Indicator, Range, and Dashboard

Buy Now
Questions 8

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?

Options:

A.

Only the stored process code

B.

Only the SQL code generated by the information map

C.

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

D.

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

Buy Now
Questions 9

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.

Buy Now
Questions 10

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

Buy Now
Questions 11

Which application can NOT import and use shared dynamic prompts?

Options:

A.

SAS Enterprise Guide

B.

SAS Information Map Studio

C.

SAS Web Report Studio

D.

SAS Management Console

Buy Now
Questions 12

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?

Options:

A.

a prompted filter based on the received value

B.

a List or Crosstab Report Object

C.

a section for each possible value to be received

D.

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

Buy Now
Questions 13

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?

Options:

A.

Save the report as data is automatically refreshed.

B.

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

C.

Select the Refresh Data button when viewing the report.

D.

Save the report as data can be manually refreshed.

Buy Now
Questions 14

A SAS Information Map is based on multiple relational tables.

Which statement is true regarding joins between them?

Options:

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.

Buy Now
Questions 15

Where can shared prompts be stored?

Options:

A.

ASAS Folders location

B.

An operating system location on your machine

C.

An operating system location on the server machine

D.

ASAS Enterprise Guide project

Buy Now
Questions 16

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

Options:

A.

The default join is an inner join

B.

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

C.

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

D.

The default join created is a full outer join

Buy Now
Exam Code: A00-270
Exam Name: SAS BI Content Developmentfor SAS 9
Last Update: Nov 27, 2023
Questions: 107
dumpsmate guaranteed to pass
24/7 Customer Support

DumpsMate's team of experts is always available to respond your queries on exam preparation. Get professional answers on any topic of the certification syllabus. Our experts will thoroughly satisfy you.

Site Secure

mcafee secure

TESTED 01 May 2024