A00-270 Exam Questions

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

A SAS Information Map is based on multiple relational tables. Which statement is true regarding joins between them?

The authenticated id of a user is stored in the form USERIDDOMAIN. In SAS Information Map Studio, which identity-driven filter should be used to capture the correct userid?

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?

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?

Which SAS Management Console plug-in is used to define metadata for channels?

The required components of a SAS BI Dashboard are:

Which one of the following statements is true regarding the name of a SAS array?

Which one of the following is true of the SUM statement in a SAS DATA step program?

Which language is used to query SAS CLAP Cubes?

Refer to the Exhibit. A SAS Information Map has been built with the SAS CLAP Cube that has been structured as shown in the exhibit. You want to generate a SAS Web Report Studio rep...

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

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

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

To implement a stored process, the content developer must write the programming code, register the stored process in the metadata and test the stored process. Which client applicat...

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?

Which delivery methods are valid for alerts in a SAS BI Dashboard? (Choose two.)

Which statement is true regarding roles?

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 proces...

Refer to the Exhibit. The exhibit shows the SAS Folders structure in SAS Management Console. Folders that contain which type of content are displayed in the SAS BI Dashboard applic...

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?

In the default configuration, which application does not prompt for user credentials?

Refer to Exhibit: A SAS Web Report Studio user is changing the summarization option for Annual Salary and the only aggregations allowed are Minimum and Maximum. Why is the list lim...

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 dat...

Refer to the exhibit. Which type of content is Certification Exam.srx?

An information map has been built from the SASHELP.CLASS and SASHELP.STUDENT tables. A general prefilter had been applied to a data item from the SASHELP.CLASS table. Why should th...

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?

Refer to the exhibit. Which type of alert is being configured for the SAS BI Dashboard?

Which data sources can be used to create reports and analysis using SAS Web Report Studio? (Choose two.)

Refer to the exhibit. A user is creating a Custom Filter in SAS Web Report Studio. The Get Values button is grayed out and there is a message saying that the data item does not all...

A content developer has published a web report from SAS Web Report Studio. The content developer wants the users to be able to access the web report from the SAS Information Delive...

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

A stored process will be used to provide a dynamic data source for an information map. Which type of data source must the stored process use?

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

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 exhi...

Where can shared prompts be stored?

In which application can you create shared prompts?

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...

A stored process link is available from a Collection Portlet in the SAS Information Delivery Portal. A content developer wants to allow the user to select a style for stored proces...

In SAS Information Map Studio, there is a date/time data item called MYDATE based on a physical column that displays as 24Mar201 0:1 3:50:00. You are creating a prompt and don't wa...

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

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?

In SAS Information Map Studio, where can you set the Initial Creation Rule for relationships between data sources?

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

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 colo...

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...

Refer to the Exhibit. What data attributes can you specify for the data model to identify each gauge in the SAS BI Dashboard?

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...

Which statement is true regarding the SAS My Folder metadata location?

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...