SAS Institute A00-270 Online Practice Questions and Exam Preparation

SAS Institute A00-270 Online Questions & Answers

• Question 1:

  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 on SAS.IdentityGroupName.
  B. Assign the Company filter as a General prefilter.
  C. Create an authorization-based prefilter by adding the Company filter to the MARKETING group.
  D. Create an identity-driven filter based on SAS.IdentityGroups.
  C. Create an authorization-based prefilter by adding the Company filter to the MARKETING group.

• Question 2:

  Which statement is true about SAS BIDashboard?

  A. All indicator display types can link to other content
  B. All indicator display types support the use of ranges
  C. All indicator display types automatically aggregate data
  D. All indicator display types provide Display Settings properties
  B. All indicator display types support the use of ranges

• Question 3:

  Which statement is FALSE regarding SAS metadatapermissions?

  A. To see an object in a folder, you need the ReadMetadata permission for the object
  B. To delete an object in a folder, you need the ReadMetadata and WriteMetadata permissions for me object.
  C. To edit an object in a folder, you need the ReadMetadata and WriteMetadata permission for the object.
  D. To save an Object to a folder, you need the ReadMetadata and WriteMetadata permission for me folder.
  D. To save an Object to a folder, you need the ReadMetadata and WriteMetadata permission for me folder.

• Question 4:

  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
  A. Star schema

• Question 5:

  Refer to the exhibit.

  

  Which type of content is Certification Exam.srx?

  A. SAS report
  B. stored process
  C. SAS package
  D. data exploration
  A. SAS report

• Question 6:

  Which tables can be a source table for an information map?

  A. Tables in the default authentication domain
  B. Tables registered in metadata
  C. Tables on the server where the cube is created
  D. Tables on the server where the workspace server executes
  B. Tables registered in metadata

• Question 7:

  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
  D. Use the refresh button

• Question 8:

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

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

• Question 9:

  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
  B. HTML
  D. PDF

• Question 10:

  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
  B. The drill through data source is updated by rerunning the PROC OLAP code