SAS Business Intelligence Quiz

Posted on: | By: – Comments Off

SAS Business Intelligence Beginner Quiz

 



1) When can you add a stored process as a data source to an information map?

  1. anytime
  2. when at least one table is selected as a data source
  3. when at least one OLAP cube is selected as a data source
  4. once an application server has been selected

Answer : B

 
 
2) A SAS.IdentityGroups filter has been created in SAS Information Map Studio. There is a data item called “Group” that contains different metadata groups.
If the “Group” filter is applied to the map, how will it affect the data?
 

  1. All rows will be returned for any group that the user is a member of.
  2. Only rows that belong to the first group are returned.
  3. All rows will be returned for PUBLIC group only.
  4. All rows matching the group identity login are returne

Answer : A

 
 
3) A SAS data set is used as a data source for a SAS BI Dashboard data model.
Which type of code do you write to query the data?
 

  1. DATA Step
  2. PROC SQL
  3. SQL/JDBC query
  4. MDX

Answer : C

 
 
4) In a stored process, when using a range prompt named DateRange, which macro variables would you use in your SAS code?

  1. DateRange_START and DateRange_FINISH
  2. DateRange_BEGIN and DateRange_END
  3. DateRange_MIN and DateRange_MAX
  4. DateRange0 and DateRange1

Answer : C

 
 
5) A content developer would like to create a group of cascading prompts to use in multiple reports without recreating the prompts for each report.
What features of the prompt framework must the developer use?
 

  1. Cannot create shared cascading prompts for use in multiple reports.
  2. Dynamic Prompts and Shared Prompts
  3. Cascading Prompts and Standard Groups
  4. Cascading Prompts, Standard Groups, and Shared Prompts

Answer : D

 
 
6) A SAS Information Map with a SAS OLAP Cube as a data source can be built from which of the following?

  1. multiple SAS OLAP Cubes
  2. a SAS OLAP Cube and a stored process
  3. one table joined with one SAS OLAP Cube
  4. one SAS OLAP Cube only

Answer : D

 
 
7) 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  elected range while the other ranges remain neutral. How can this be achieved?

  1. Change the other colors in the range to be a neutral color.
  2. Select the gauge type to be a Dynamic Speedometer.
  3. Check the Ghost checkbox on the select a gauge screen.
  4. Alter the style to support shadowing.

Answer : C

 
 
8) 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 limited to only these two choices.

  1. The user is assigned to a role that only allows these aggregations.
  2. SAS Web Report Studio only supports these aggregations.
  3. These are the only aggregations supported for currency data items.
  4. The information map creator has limited the available aggregations.

Answer : D

 
 
9) 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 allow available values to be displayed.Which change would need to be made to the information map to

  1. Create a prompting Filter in the information map that only allows the user to type a value.
  2. Alter the value generation method of the data item to either select from a static or a dynamic list.
  3. Change the item type from a measure to a category.
  4. Values cannot be displayed for this type of data.

Answer : B

 
 
10) 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?

  1. Select Flip Horizontal on the gauge properties.
  2. Ensure the dashboard and indicator are the correct width to display three gauges.
  3. Reduce the display size of the gauge sufficiently to allow all three to fit.
  4. Change to a gauge type that supports horizontal display of multiple gauges.

Answer : B




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

  1. SAS Information Map
  2. SAS OLAP cube
  3. SAS Dataset
  4. SAS table

Answer : A

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

  1. SAS Add-In for Microsoft Office
  2. SAS Information Map Studio
  3. SAS Management Console
  4. SAS OLAP Cube Studio

Answer : A

 
 
13) Where can shared prompts be stored?

  1. a SAS Folders location
  2. an operating system location on your machine
  3. an operating system location on the server machine
  4. a SAS Enterprise Guide project

Answer : A

 
 
14) 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?

  1. a relational table
  2. an OLAP cube
  3. an information map
  4. an XML file

Answer : A

 
 
15) 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?

  1. SAS Management Console
  2. SAS Data Integration Studio
  3. SAS Information Map Studio
  4. SAS Enterprise Guide

Answer : D

 
 
16) The profile reports generated in dfPower Profile jobs are viewed:

  1. in dfPower Profile (Viewer)
  2. in the Reports tab of dfPower Profile (Configurator)
  3. in any HTML viewer
  4. in any text viewer

Answer : A

 
 
17) Which definition cannot be imported using a SAS Metadata Bridge?

  1. Server definition
  2. Library definition
  3. Table definition
  4. Column Definition

Answer : A

 
 
18) 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?

  1. a prompted filter based on the received value
  2. a List or Crosstab Report Object
  3. a section for each possible value to be received
  4. a data item of the same name as the value being passed

Answer : A

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

  1. The report creator can only choose to link to the first section.
  2. The report creator cannot establish a link to a section that only has a Stored Process object.
  3. The report creator can choose any one section to display when creating the report link.
  4. The report creator can choose multiple sections to display when creating the report link.

Answer : C

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

  1. control access to Information Maps
  2. control member level security
  3. control creation of CSS formats for custom report styles
  4. control which application features are available

Answer : D




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

  1. Banner Header
  2. Information Map name
  3. Report Objects used
  4. Section names

Answer : B

 
 
22) In SAS Web Report Studio, when distributing a report, what are the email output options?

  1. SAS report
  2. HTML
  3. RTF
  4. TXT

Answer : B

 
 
23) In which application can you create shared prompts?

  1. SAS DI STUDIO
  2. SAS Enterprise Guide
  3. SAS Information Map Studio
  4. SAS Web Report Studio

Answer : A

 
 
24) 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?

  1. Save the report as data is automatically refreshed.
  2. Schedule the report and view the results after it is executed.
  3. Select the Refresh Data button when viewing the report.
  4. Save the report as data can be manually refreshe

Answer : A

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

  1. a SAS Enterprise Guide project
  2. a web page
  3. a SAS BI Dashboard display
  4. an information map

Answer : B

 
 
26) 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?

  1. Only headers and footers can be changed.
  2. No changes can be made.
  3. Report objects can be moved or deleted.
  4. Additional report objects can be adde

Answer : B

 
 
27) Which language is used to query SAS OLAP Cubes?

  1. SQL
  2. OLE DB for OLAP
  3. MDX
  4. O-SQL

Answer : C

 
 
28) 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?

  1. Star schema
  2. Detail table
  3. Fully summarized table
  4. Information map

Answer : A

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

  1. SAS Web Report Studio
  2. SAS Enterprise Guide
  3. Microsoft Excel
  4. SAS OLAP Cube Studio

Answer : A

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

  1. associating a SAS Stored process with an information map that uses an OLAP Cube as a data source
  2. simple filter creation
  3. create shared prompts
  4. joining multiple cubes within one information map

Answer : B




 
31) 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?

  1. Adobe Reader is not installed on the machine.
  2. Adobe Flash-Plugin is not installed on the browser.
  3. The SAS Interactive plug-in is not installed on the browser.
  4. Java is not installed on the machine.

Answer : B

 
 
32) SAS Information delivery portal connects to which server?

  1. Object spawner
  2. Web server
  3. Workspace Server
  4. Stored process server

Answer : B

 
 
33) Identify the capability which can not perform in SAS WRS

  1. scheduling reports
  2. distributing reports
  3. adding and editing recipient lists
  4. Create stored process

Answer : D

 
 
34) Identify the capability which can not perform in SAS WRS

  1. scheduling reports
  2. Create shared prompts
  3. adding and editing recipient lists
  4. printing reports

Answer : B

 
 
35) Identify the capability which can not perform in SAS WRS

  1. Read Oracle table
  2. exporting reports
  3. adding and editing recipient lists
  4. printing reports

Answer : A

 
 
36) 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 t

  1. The user does not have permission to the prompt.
  2. The user does not have permission to the prompt source data.
  3. The user does not have permission to the stored process.
  4. The user does not have permission to the Stored Process Server.

Answer : B

 
 
37) A content developer is creating a stored process using the New SAS Stored Process Wizard in SAS Enterprise Guide. Which information is contained in the location field?

  1. the location of the data source used by the stored process
  2. the location of the SAS code for the stored process
  3. the location of the metadata for the stored process
  4. the location of the output produced by the stored process

Answer : C

 
 
38) 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?

  1. HTML
  2. PDF
  3. SAS report
  4. package

Answer : D

 
 
39) 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?

  1. The distribution task overwrites the schedule options.
  2. User B’s distribution task emails the results of User A’s schedule without having to rerun the
  3. User B needs to set the objects on the report to be independent to prevent overwriting User A’s output.
  4. User A and User B’s actions do not affect one another.

Answer : D

 
 
40) The required components of a SAS BI Dashboard are:

  1. Data Model, Range, Indicator, and Dashboard
  2. Data Model, OLAP Cube, Indicator, and Dashboard
  3. Information Map, Indicator, Range, and Dashboard
  4. Data Model, Stored Process, Indicator, Range, and Dashboard

Answer : A




 
41) Which delivery methods are valid for alerts in a SAS BI Dashboard? (

  1. Alerts Portlet
  2. SAS BI Dashboard Portlet
  3. Stored Process Alerts Portlet
  4. HTML

Answer : A

 
 
42) How to link OLAP Cube to SAS Information delivery portal

  1. Via SAS EG
  2. Via SAS Infomap
  3. Via SAS E-miner
  4. Via Stored process

Answer : B

 
 
43) &_metaperson resolves to

  1. Client Id
  2. root Id
  3. Admin Id
  4. Job Id

Answer : A

 
 
44) Reserved macro variable “_METAFOLDER” used by

  1. %STPBEGIN
  2. %STPEND
  3. Web Clients Stored Process Server
  4. All

Answer : D

 
 
45) Reserved macro variable “_METAPERSON” used by

  1. %STPBEGIN
  2. %STPEND
  3. Web Clients Stored Process Server
  4. All

Answer : D

 
 
46) Reserved macro variable “_METAUSER” used by

  1. %STPBEGIN
  2. %STPEND
  3. Web Clients Stored ProcessnServer
  4. All

Answer : D

 
 
47) Reserved macro variable “_NAMEVALUE” used by

  1. %STPBEGIN
  2. %STPEND
  3. Web Clients Stored Process Server
  4. All

Answer : A

 
 
48) What is default data assignment for Graph Type “bar charts and progressive
bar charts” Default First Meausre ?
 

  1. bar height
  2. line height
  3. segment size
  4. horizontal axis

Answer : A

 
 
49) What is default data assignment for Graph Type “bar-line
charts” Default First Meausre ?
 

  1. bar height
  2. line height
  3. segment size
  4. horizontal axis

Answer : A




 
50) What is default data assignment for Graph Type “line graphs” Default First Meausre ?
 

  1. bar height
  2. line height
  3. segment size
  4. horizontal axis

Answer : B

 
 
51) What is default data assignment for Graph Type “pie charts” Default First Meausre ?
 

  1. bar height
  2. line height
  3. segment size
  4. horizontal axis

Answer : C

 
 
52) What is default data assignment for Graph Type “scatter plots ” Default First Meausre ?
 

  1. bar height
  2. line height
  3. segment size
  4. horizontal axis

Answer : D

 
 
53) What is default data assignment for Graph Type “tile charts ” Default First Meausre ?
 

  1. bar height
  2. size
  3. segment size
  4. horizontal axis

Answer : B

 
 
54) What is default data assignment for Graph Type “bar charts and progressive
bar charts” Default Second Meausre ?
 

  1. bar height
  2. line height
  3. hidden
  4. horizontal axis

Answer : C

 
 
55) Reserved macro variable “_HTACPT” used by

  1. %STPBEGIN
  2. %STPEND
  3. Web Clients Stored Process Server
  4. All

Answer : B

 
 
56) Reserved macro variable “_HTCOOK” used by

  1. %STPBEGIN
  2. %STPEND
  3. Web Clients Stored Process Server
  4. All

Answer : B

 
 
57) Reserved macro variable “_HTREFER” used by

  1. %STPBEGIN
  2. %STPEND
  3. Web Clients Stored Process Server
  4. All

Answer : B

 
 
58) Reserved macro variable “HTTP_USER” used by

  1. %STPBEGIN
  2. %STPEND
  3. Web Clients Stored Process Server
  4. All

Answer : A

 
 
59) Reserved macro variable “_HTUA” used by

  1. %STPBEGIN
  2. %STPEND
  3. Web Clients Stored Process Server
  4. All

Answer : B

 
 
60) Reserved macro variable “_NAMESPACES” used by

  1. %STPBEGIN
  2. %STPEND
  3. Web Clients Stored Process Server
  4. All

Answer : A




 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz