New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: best70

Note! SAS Institute has retired the A00-270 Exam Contact us through Live Chat or email us for more information.

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

Questions 4

What is the significance of the %STPBEGIN statement? (Choose two.)

Options:

A.

Initializes the ODS system

B.

Initiates the prompting for parameters

C.

Processes the user written SAS code

D.

Generates the reserve macro variables

Buy Now
Questions 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.

Buy Now
Questions 6

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

Buy Now
Questions 7

Refer to the exhibit.

When attempting to create a stored process from the entire SAS Enterprise Guide project (Process Flow) you receive a warning message window (shown in the exhibit).

The warning message is a result of the project containing:

Options:

A.

a data source

B.

multiple tasks

C.

a code node

D.

a stored process

Buy Now
Questions 8

Refer to the exhibit.

A user is running a stored process from a SAS Web Report Studio report. The stored process has a cascading prompt requesting the user to select Country then Department. The user attempts to select a value but the drop down for Country is empty. Why are the values for the prompt missing?

Options:

A.

The user does not have permission to the prompt.

B.

The user does not have permission to the prompt source data.

C.

The user does not have permission to the stored process.

D.

The user does not have permission to the Stored Process Server.

Buy Now
Questions 9

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

Buy Now
Questions 10

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?

Options:

A.

Star schema

B.

Detail table

C.

Fully summarized table

D.

Information map

Buy Now
Questions 11

In SAS Information Map Studio, there is a date/time data item called MYDATE based on a physical column that displays as 24Mar2010:13:50:00. You are creating a prompt and don't want the time included. How can this be accomplished?

Options:

A.

Apply a DATE7. format to the data item before building the prompt.

B.

Apply the DATEPART() SAS function on the filter.

C.

Apply a DATE7. format on the filter.

D.

In the properties for MYDATE, change the type from Timestamp to Date.

Buy Now
Questions 12

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

Buy Now
Questions 13

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

Buy Now
Questions 14

A stored process will be used to provide a dynamic data for an information map. The stored process must be defined to execute on the:

Options:

A.

Workspace server

B.

Content server

C.

Information map server

D.

Stored process server

Buy Now
Questions 15

Refer to the exhibit:

What is causing the error message from the stored process created from a SAS program, given the log display in the exhibit?

Options:

A.

There is no libref OSDM registered in the metadata

B.

The Libname statement is not compatible with the VALIDVARNAMR option

C.

There is no library named Orion Reporting registered in the metadata

D.

The stored process is not registered to the Orion reporting Library in the metadata

Buy Now
Questions 16

When you register a stored process in the metadata, you specify the type of output the stored process can produce. What is a valid value for the output options in the metadata?

Options:

A.

HTML

B.

PDF

C.

SAS report

D.

package

Buy Now
Exam Code: A00-270
Exam Name: SAS BI Content Developmentfor SAS 9
Last Update: Dec 22, 2024
Questions: 107