SAS BI Content Developmentfor SAS 9 v7.0 (A00-270)

Page:    1 / 8   
Total 107 questions

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.


Answer : B

Refer to the exhibit and note the error.
The data model for this SAS BI Dashboard has been built using a SAS Information Map.
What is the reason for the error?

  • A. The SAS Information Map used as a data source does not have a measure defined.
  • B. The content developer does not have the ReadMetadata permission on the SAS Information Map.
  • C. The SAS Information Map was built using an OLAP Cube.
  • D. The gauge type for the indicator is not correct and needs to be changed.


Answer : A

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

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

  • A. Personal Alert
  • B. Dashboard Alert
  • C. Indicator Alert
  • D. Data Alert


Answer : C

The WebDAV Content Portlet may display which one of the following?

  • A. OLAP cubes
  • B. Information maps
  • C. Tables
  • D. HTML files


Answer : D

Explanation:
A WebDAV content portlet displays the contents of a specified HTML fragment that is stored in a WebDAV repository. You can create your own WebDAV content portlets to display HTML fragments that you specify.
An HTML fragment is an HTML file that does not include opening and closing HTML tags,
HEAD tags, or BODY tags. The fragment can be displayed successfully in the cell of an
HTML table.
Reference:http://support.sas.com/documentation/cdl/en/idp/60049/HTML/default/viewer.ht m#p1qfvwfpv4svumn14eir58j80clx.htm

Auser is working in Microsoft Excel with the SAS Add-in. How can the user refresh all of their SAS content at the same time?

  • A. Use the Reports dialog
  • B. Reconnect to the metadata server
  • C. Select the entire worksheet and click refresh
  • D. Use the Manage Content dialog


Answer : C

Reference:http://support.sas.com/resources/papers/proceedings14/1403-2014.pdf

Refer to the exhibit.
Which technique was used to produce the separate pie charts?

  • A. Pie Subgroup from the Assign Data Window
  • B. Multiple Pies from the Properties Window
  • C. Grouped Pies from the Properties Window
  • D. Horizontal Series from the Assign Data Window


Answer : B

Reference:http://robslink.com/SAS/book1/Chapter_04_Pies.pdf(page 10)

While using the SAS add-in Excel, a user wants to update their prompted stored process results with new prompt values. What should the use do?

  • A. Reconnect tothemetadata server
  • B. Reopen the workbook
  • C. Use the modify button
  • D. Use the refresh button


Answer : D

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

  • A. Control member level security
  • B. Control which application features are available
  • C. Control who can log on to SAS Web Report Studio
  • D. Control creation of CSS formats for custom report styles


Answer : A

Which structure is not permitted in a SAS OLAP Cube design?

  • A. A dimension with one hierarchy
  • B. A dimension with two or more hierarchies that share the same level
  • C. Two or more dimensions that have unique counts
  • D. Two or more dimensions that are a TIME type dimensions


Answer : B

Whichstatement is true about a cube with a drill through data source?

  • A. The drill through data source remains in sync when performing an in-place update
  • B. The drill through data source is updated by rerunning the PROC OLAP code
  • C. The drill through data source can only be updated if flagged in the metadata
  • D. The drill through data source is updated using a separate process


Answer : B

Which item in a cube becomes a category data item in an information map?

  • A. Column
  • B. Hierarchy
  • C. Dimension
  • D. Level


Answer : B

An OLAP Cube hierarchy is definedas:

  • A. An organized set of categories, known as dimensions, that describes the data in a source table
  • B. An organized set of NWAY crossings
  • C. An organized set of numeric values that have been pre-aggregated
  • D. An organized set of categories, known as levels, that describes the data ina source table


Answer : A

A cube designer is creating a cube and has established the following dimension structure:
The cube designer would like to add the customer name and have it associated with the customer ID.
Which action should the cube designer take?

  • A. Add a level attribute to the Customer_ID level
  • B. Create a new hierarchy that contains Customer_Name instead of Customer_ID as a level
  • C. Add a member property to the Customer_ID level
  • D. Add Customer_NAME as a new level, placing if after Customer_ID in the hierarchy


Answer : D

A SAS Information Map is based on multiple relational tables.Which statement is true regarding the relationship?

  • A. The default join is an inner join
  • B. A relationship can be created only if column names in the data sources match
  • C. A relationship can be created even if the joining columns are different types
  • D. The default join created is a full outer join


Answer : B

Page:    1 / 8   
Total 107 questions