SASInstitute SAS Institute Systems Certification A00-270 Questions & Answers

• Question 11:

  Given the Following Stored Process code.

  

  The following result is expected:

  

  The above stored process code is not returning the expected result. Which action should be taken to correct this?

  A. Remove the % stpbegin and % stpend from the code

  B. Remove the file _webout statement from the code

  C. Select Package option from the metadata

  D. Deselect the Stream option from the metadata

  Correct Answer: C

• Question 12:

  A content developer would like to create a cascade prompt in a stored process which allows the user to select Continent Country then City.

  When creating this cascading prompt, what must the developer define for the City prompt?

  A. A dependency on the Continent prompt only

  B. A dependency for the Continent prompt the Country prompt and the City prompt

  C. A dependency for the Continentprompt andthe Country prompt

  D. A dependency on the Country prompt only

  Correct Answer: D

• Question 13:

  Which application supports role-based capabilities?

  A. SAS Management Console

  B. SAS Information Map Studio

  C. SAS OLAP Cube Studio

  D. SAS Data Integration Studio

  Correct Answer: A

• Question 14:

  A user has limited access to tasks when using the SAS Add-in for Microsoft as shown below.

  

  How does the SAS platform administrator control which tasks the user sees within the SAS add-in?

  A. By setting access permissions

  B. Customizing the tasks during the installation process

  C. Modifying a configuration option in the Microsoft applications

  D. Through the use of metadata roles

  Correct Answer: A

• Question 15:

  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

  Correct Answer: B

• Question 16:

  Which combination of data sources is valid in aninformation map?

  A. One table and one cube

  B. One cube and one stored process

  C. One cube combined with a second cube

  D. One table and one stored process

  Correct Answer: A

• Question 17:

  What cannot be used to create reports and analysis using SAS Web Report Studio?

  A. SAS BI Dashboard

  B. SAS Stored Process

  C. SAS table

  D. SAS OLAP cube

  Correct Answer: D

• Question 18:

  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.

  Correct Answer: D

• Question 19:

  Which SAS BI Dashboard indicator display type does not require a locator Data Object?

  A. Dynamic Text

  B. Dynamic Prompts

  C. Spark Table

  D. Custom Graph

  Correct Answer: C

• Question 20:

  Which item is NOT requiredfor a SASBIDashboard Custom Graph indicator?

  A. Indicator data object

  B. Display type

  C. Indicator name

  D. SAS folders storage location

  Correct Answer: A