A00-270 Online Practice Questions and Answers

Which SAS applications can be used to create data sources for reporting and analysis using the SAS platform applications? (Choose two.)

A. SAS Enterprise Guide

B. SAS Information Delivery Portal

C. SAS Information Map Studio

D. SAS Web Report Studio

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?

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.

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?

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

In SAS Information Map Studio, a map requirement is to create a filter where Company = "SAS". This Company filter should ONLY be applied if the user is in the MARKETING group. How can this be accomplished if the map is available to the entire company?

A. Create an identity-driven filter based on SAS.IdentityGroupName.

B. Assign the Company filter as a General prefilter.

C. Create an authorization-based prefilter by adding the Company filter to the MARKETING group.

D. Create an identity-driven filter based on SAS.IdentityGroups.

Which of the following is FALSE regarding the Information Maps LIBNAME Engine?

A. The engine provides read-only access to the data presented by the information map.

B. The engine is associated with a collection of information maps instead of a physical storage location.

C. SASIOIME is an alias for the INFOMAPS engine name used in the libname statement.

D. The engine provides the ability to modify the information map and the underlying data.

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?

A. 500

B. 65536

C. 2 million

D. Excel's limitation based on the version of Excel

Refer to the exhibit.

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

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.

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

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

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

A. SAS report

B. HTML

C. RTF

D. PDF

Refer to the exhibit.

The SAS BI Dashboard uses a Dynamic Traffic Light gauge type, but the colors shown in the indicator don't change.

Which action will cause the indicator's color to change?

A. Modify the Indicator gauge type.

B. Modify the Color properties for the range according to the Code Intervals.

C. Modify the Code Interval for the range according to the data range.

D. Modify the Interval for the range according to the data values.