SAS Institute SAS Institute Certifications A00-270 Questions & Answers

• Question 51:

  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

  Correct Answer: BC

• Question 52:

  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

  Correct Answer: A

• Question 53:

  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

  Correct Answer: A

• Question 54:

  Which language is used to query SAS OLAP Cubes?

  A. SQL

  B. OLE DB for OLAP

  C. MDX

  D. O-SQL

  Correct Answer: C

• Question 55:

  Refer to the exhibit.

  

  Why is the list report icon (first icon in the object list) grayed out?

  A. The list report object is only available in the Report Wizard.

  B. The list report object cannot be used in the same section as OLAP data.

  C. Not enough hierarchies are selected.

  D. Not enough measures are selected.

  Correct Answer: B

• Question 56:

  Refer to the exhibit.

  

  A SAS Information Map has been built with the SAS OLAP Cube that has been structured as shown in the exhibit.

  You want to generate a SAS Web Report Studio report using the information map that contains the cube data.

  Which selection is valid?

  A. AverageCostOfProduct, City Based, Zipcode Based, Product, Month Based, Quarter Based

  B. AverageCostOfProduct, City Based, Zipcode Based, Product, Month Based

  C. AverageCostOfProduct, City Based, Product, Month Based, Quarter Based

  D. AverageCostOfProduct, City Based, Product, Month Based

  Correct Answer: D

• Question 57:

  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.

  Correct Answer: B

• Question 58:

  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

  Correct Answer: B

• Question 59:

  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.

  Correct Answer: A

• Question 60:

  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

  Correct Answer: BD