A00-270 Online Practice Questions and Answers

Which statement is true regarding the SAS My Folder metadata location?

A. The My Folder location is a valid place to share content.

B. Every user with a SAS metadata identity has a My Folder location.

C. The My Folder location is a temporary work location.

D. The My Folder location is only available to the user it belongs to.

When you register a stored process in the metadata, you specify the type of output the stored process can produce. What is a valid value for the output options in the metadata?

A. HTML

B. PDF

C. SAS report

D. package

A stored process link is available from a Collection Portlet in the SAS Information Delivery Portal. A content developer wants to allow the user to select a style for stored process output. Which reserved macro variable would the developer use as the name of the prompt?

A. _style

B. _odstemplate

C. _template

D. _odsstyle

The metadata libname engine is commonly used with stored process to ensure that metadata security is enforced to control access to the data. Which options do not have a default value and must be manually coded in the libname statement?

A. PORT = option AND PROTOCOL = option

B. REPNAME = option OR REPID = option

C. LIBRARY = option OR LIBID = option

D. USERID = option AND PASSWORD = option

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.

When saving a report in SAS Web Report Studio, what is a valid output type?

A. XLS

B. DOC

C. HTML

D. PDF

Which language is used to query SAS OLAP Cubes?

A. SQL

B. OLE DB for OLAP

C. MDX

D. O-SQL

Refer to the exhibit.

What data attributes can you specify for the data model to identify each gauge in the SAS BI Dashboard?

A. Label

B. Property Alias

C. Category Label

D. Format

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

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