SASInstitute SAS Institute Systems Certification A00-270 Questions & Answers

• Question 31:

  In SAS information MAP Studio, where can you set the initial Creation Rule for relationship between data sources by default?

  A. Resource pane

  B. Design tab

  C. Properties pane

  D. Options window

  Correct Answer: D

• Question 32:

  In SAS Information Map Studio, how are cascading prompts created?

  A. Create a compound filter with prompts and establishdependencies between prompts

  B. Use the cascading prompt wizard located on the tools menu

  C. Create individual filters and link them together on the relationships tab

  D. Create individual prompted filters and establish dependences betweenfiltersoption

  Correct Answer: D

• Question 33:

  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

  Correct Answer: B

• Question 34:

  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

  Correct Answer: D

• Question 35:

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

  A. Column

  B. Hierarchy

  C. Dimension

  D. Level

  Correct Answer: B

• Question 36:

  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

  Correct Answer: A

• Question 37:

  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

  Correct Answer: B

• Question 38:

  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

  Correct Answer: B

• Question 39:

  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

  Correct Answer: A

• Question 40:

  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

  Correct Answer: D