SAS Institute SAS Institute Certifications A00-270 Questions & Answers

• Question 71:

  Refer to the exhibit.

  

  Why is there a warning icon in this bar-line chart in SAS Web Report Studio?

  A. There are empty cells with no report objects.

  B. The properties of the bar line chart have not been set.

  C. The report has not been saved.

  D. There are not enough measure data items.

  Correct Answer: D

• Question 72:

  A SAS task is performed in Microsoft Excel against 2 million rows of data in a table that is registered to the metadata sever. What is the maximum number of rows that can be processed?

  A. 500

  B. 65536

  C. 2 million

  D. Excel's limitation based on the version of Excel

  Correct Answer: C

• Question 73:

  Refer to the exhibit.

  

  Which type of content is Certification Exam.srx?

  A. SAS report

  B. stored process

  C. SAS package

  D. data exploration

  Correct Answer: A

• Question 74:

  A content developer has published a web report from SAS Web Report Studio. The content developer wants the users to be able to access the web report from the SAS Information Delivery Portal.

  Which Portal Content type can the content developer use to allow a user access to the published web report?

  A. SAS Information Map

  B. Package

  C. Publication channel

  D. Syndication channel

  Correct Answer: C

• Question 75:

  The authenticated id of a user is stored in the form USERID@DOMAIN. In SAS Information Map Studio, which identity-driven filter should be used to capture the correct userid?

  A. SAS.UseridDomain

  B. SAS.PersonName

  C. SAS.Domain

  D. SAS.Userid

  Correct Answer: D

• Question 76:

  A content developer created a filter in SAS Information Map Studio and wants to prevent anyone from selecting the filter in SAS Web Report Studio. How can this be accomplished?

  A. Set Metadata permissions on the filter.

  B. Deny the "View Filters" capability on a SAS Web Report Studio role.

  C. Add the filter as a general prefilter in SAS Information Map Studio.

  D. Select the "Hide from user" option on the filter in SAS Information Map Studio.

  Correct Answer: D

• Question 77:

  An information map has been built from the SASHELP.CLASS and SASHELP.STUDENT tables. A general prefilter had been applied to a data item from the SASHELP.CLASS table. Why should the SASHELP.CLASS table be added as a required table?

  A. It assures that the prefilter will always be applied.

  B. It forces the user to select at least one data item from the required table.

  C. It will improve performance.

  D. Required table data items cannot be removed from the Information Map Content pane.

  Correct Answer: A

• Question 78:

  Which of the following is FALSE regarding the Information Maps LIBNAME Engine?

  A. The engine provides read-only access to the data presented by the information map.

  B. The engine is associated with a collection of information maps instead of a physical storage location.

  C. SASIOIME is an alias for the INFOMAPS engine name used in the libname statement.

  D. The engine provides the ability to modify the information map and the underlying data.

  Correct Answer: D

• Question 79:

  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.

  Correct Answer: C

• Question 80:

  In SAS Information Map Studio, there is a date/time data item called MYDATE based on a physical column that displays as 24Mar2010:13:50:00. You are creating a prompt and don't want the time included. How can this be accomplished?

  A. Apply a DATE7. format to the data item before building the prompt.

  B. Apply the DATEPART() SAS function on the filter.

  C. Apply a DATE7. format on the filter.

  D. In the properties for MYDATE, change the type from Timestamp to Date.

  Correct Answer: B