Free SASInstitute A00-270 Exam Dumps Questions & Answers

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.  USERID = option AND PASSWORD = option
• C.  REPNAME = option OR REPID = option
• D.  LIBRARY = option OR LIBID = option

A stored process will be used to provide a dynamic data source for an information map. Which type of code is executed to query data from the information map?

• A.  only the stored process code
• B.  first the SQL code generated by the information map followed by the stored process code
• C.  only the SQL code generated by the information map
• D.  first the stored process code followed by the SQL code generated by the information map

Refer to the exhibit.

A content developer is creating a stored process using the New SAS Stored Process
Wizard in SAS Enterprise Guide. Which information is contained in the location field?

• A.  the location of the output produced by the stored process
• B.  the location of the SAS code for the stored process
• C.  the location of the metadata for the stored process
• D.  the location of the data source used by the stored process

Refer to the exhibit.

What is causing the error message from the stored process created from a SAS program, given the log displayed in the exhibit?

• A.  There is no library named Orion Reporting Library registered in the metadata.
• B.  The Libname statement is not compatible with the VALIDVARNAME option.
• C.  The stored process is not registered to the Orion Reporting Library in the metadata.
• D.  There is no libref OSDM registered in the metadata.

What is the purpose of setting SAS Web Report Studio capabilities in SAS Management Console?

• A.  control member level security
• B.  control creation of CSS formats for custom report styles
• C.  control which application features are available
• D.  control access to Information Maps