SAS BI Content Developer Certification Sample Question/Answer

SAS BI Content Developer Certification Sample Question/Answer

Hello Friends , 

Here you can find SAS BI content developer certification sample question, I have added 50 question that will surely help you a lot in your certification.

All The Best

QUESTION NO: 1

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

Answer: A

QUESTION NO: 2

A content developer wants to emphasize the indicator value shown by a dynamic gauge in SAS BI

Dashboard. The content developer wants to display the color of the selected range while the other

ranges remain neutral. How can this be achieved?

A. Change the other colors in the range to be a neutral color.

B. Select the gauge type to be a Dynamic Speedometer.

C. Check the Ghost checkbox on the select a gauge screen.

D. Alter the style to support shadowing.

Answer: C

QUESTION NO: 3

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.

Answer: B

QUESTION NO: 4

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

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.

Answer: B

QUESTION NO: 5

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

Answer: A,C

QUESTION NO: 6

Which data sources can be used to create reports and analysis using SAS Web Report Studio?

(Choose two.)

A. SAS Information Map

B. SAS OLAP cube

C. SAS Stored Process

D. SAS table

Answer: A,C

QUESTION NO: 7

Which statement is true regarding roles?

A. Only groups can be members of roles.

B. Only users can be members of groups or roles.

C. You must use roles to control access to application features.

D. You must use roles to control access to data sources and reporting content.

Answer: C

QUESTION NO: 8

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

A. SAS Add-In for Microsoft Office

B. SAS Information Map Studio

C. SAS Management Console

D. SAS OLAP Cube Studio

Answer: A

QUESTION NO: 9

Where can shared prompts be stored?

A. a SAS Folders location

B. an operating system location on your machine

C. an operating system location on the server machine

D. a SAS Enterprise Guide project

Answer: A

QUESTION NO: 10

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

A. Configuration Manager plug-in

B. Schedule Manager plug-in

C. Foundation Services Manager plug-in

D. Publishing Framework plug-in

Answer: D

QUESTION NO: 11

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?

A. a relational table

B. an OLAP cube

C. an information map

D. an XML file

Answer: A

QUESTION NO: 12

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?

A. HTML

B. PDF

C. SAS report

D. package

Answer: D

QUESTION NO: 13

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 application can be

used to complete all three steps?

A. SAS Management Console

B. SAS Data Integration Studio

C. SAS Information Map Studio

D. SAS Enterprise Guide

Answer: D

QUESTION NO: 14

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

A. initializes the ODS system

B. initiates the prompting for parameters

C. processes the user written SAS code

D. generates the reserve macro variables

Answer: A,D

QUESTION NO: 15

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 process output. Which

reserved macro variable would the developer use as the name of the prompt?

A. _style

B. _odstemplate

C. _template

D. _odsstyle

Answer: D

QUESTION NO: 16

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

B. Country_INDEX

C. Country_NUM

D. Country_NUNIQUE

Answer: A

QUESTION NO: 17

The metadata libname engine is commonly used with stored process to ensure that metadata

security is enforced to control access to the data. Which options do not have a default value and

must be manually coded in the libname statement?

A. PORT = option

AND

PROTOCOL = option

B. REPNAME = option

OR

REPID = option

C. LIBRARY = option

OR

LIBID = option

D. USERID = option

AND

PASSWORD = option

Answer: C

QUESTION NO: 18

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

Answer: C

QUESTION NO: 19

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

between data sources?

A. Resources pane

B. Options window

C. Properties pane

D. Design tab

Answer: B

QUESTION NO: 20

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.

Answer: B

QUESTION NO: 21

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?

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

B. Apply theDATEPART() 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.

Answer: B

QUESTION NO: 22

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

B. Assign the Companyfilter as a General prefilter.

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

D. Create an identity-driven filter based onSAS.IdentityGroups.

Answer: C

QUESTION NO: 23

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

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

Answer: D

QUESTION NO: 24

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?

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 generalprefilter in SAS Information Map Studio.

D. Select the "Hide from user" option on the filter in SAS Information Map Studio.

Answer: D

QUESTION NO: 25

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 the

SASHELP.CLASS table be added as a required table?

A. It assures that theprefilter will always be applied.

B. It forces the user to select at least one data item from the required table.

C. It will improve performance.

D. Required table data items cannot be removed from the Information Map Content pane.

Answer: A

QUESTION NO: 26

The authenticated id of a user is stored in the form USERID@DOMAIN. In SAS Information Map

Studio, which identity-driven filter should be used to capture the correct userid?

A. SAS.UseridDomain

B. SAS.PersonName

C. SAS.Domain

D. SAS.Userid

Answer: D

QUESTION NO: 27

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 Delivery

Portal. Which Portal Content type can the content developer use to allow a user access to the

published web report?

A. SAS Information Map

B. Package

C. Publication channel

D. Syndication channel

Answer: C

QUESTION NO: 28

Refer to the exhibit.

Which type of content is Certification Exam.srx?

A. SAS report

B. stored process

C. SAS package

D. data exploration

Answer: A

QUESTION NO: 29

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

Answer: C

QUESTION NO: 30

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

When the co-worker opens the PowerPoint presentation, what happens to the stored process

output?

A. The output does not display.

B. The output is static.

C. The output can be refreshed.

D. A prompt appears asking if the co-worker wants to refresh the stored process.

Answer: C

QUESTION NO: 31

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

A. XLS

B. DOC

C. HTML

D. PDF

Answer: D

QUESTION NO: 32

In which application can you define shared prompt groups?

A. SAS Management Console

B. SAS BI Dashboard

C. SAS Information Map Studio

D. SAS Web Report Studio

Answer: A

QUESTION NO: 33

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?

A. Publish to a publication channel.

B. Export to .srx on the file system.

C. Open the SAS Enterprise Guide project in SAS Web Report Studio.

D. Publish to a report repository.

Answer: D

QUESTION NO: 34

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?

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

Answer: A

QUESTION NO: 35

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

Studio?

A. The report creator can only choose to link to the first section.

B. The report creator cannot establish a link to a section that only has a Stored Process object.

C. The report creator can choose any one section to display when creating the report link.

D. The report creator can choose multiple sections to display when creating the report link.

Answer: C

QUESTION NO: 36

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

Answer: D

QUESTION NO: 37

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.

Answer: D

QUESTION NO: 38

Which item is NOT saved as part of a report template in SAS Web Report Studio?

A. Banner Header

B. Information Map name

C. Report Objects used

D. Section names

Answer: B

QUESTION NO: 39

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

Answer: B,D

QUESTION NO: 40

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

Answer: A

QUESTION NO: 41

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?

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.

Answer: A

QUESTION NO: 42

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

link to?

A. a SAS Enterprise Guide project

B. a web page

C. a SAS BI Dashboard display

D. an information map

Answer: B

QUESTION NO: 43

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?

A. Only headers and footers can be changed.

B. No changes can be made.

C. Report objects can be moved or deleted.

D. Additional report objects can be added.

Answer: B

QUESTION NO: 44

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

A. Alerts Portlet

B. SAS BI Dashboard Portlet

C. Stored Process Alerts Portlet

D. Email

Answer: A,D

QUESTION NO: 45

A content developer has created an interactive dashboard. In the SAS Information Delivery Portal,

only a message is seen instead of a dashboard indicator. What could be the reason?

A. Adobe Reader is not installed on the machine.

B. Adobe Flash-Plugin is not installed on the browser.

C. The SAS Interactive plug-in is not installed on the browser.

D. Java is not installed on the machine.

Answer: B

QUESTION NO: 46

Which language is used to query SAS OLAP Cubes?

A. SQL

B. OLE DB for OLAP

C. MDX

D. O-SQL

Answer: C

QUESTION NO: 47

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?

A. Star schema

B. Detail table

C. Fully summarized table

D. Information map

Answer: A

QUESTION NO: 48

Which application requires a SAS Information Map to access a SAS OLAP cube?

A. SAS Web Report Studio

B. SAS Enterprise Guide

C. Microsoft Excel

D. SAS OLAP Cube Studio

Answer: A

QUESTION NO: 49

Which capabilities are available when creating a SAS Information Map from a SAS OLAP Cube?

(Choose two.)

A. associating a SAS Stored process with an information map that uses an OLAP Cube as a data

source

B. simple filter creation

C. creating calculated members

D. joining multiple cubes within one information map

Answer: B,C

QUESTION NO: 50

The required components of a SAS BI Dashboard are:

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

Answer: A

SAS Interview Question (Advance Level)