SAS Institute SAS Institute Certifications A00-270 Questions & Answers

• Question 81:

  A SAS Information Map is based on multiple relational tables.

  Which statement is true regarding joins between them?

  A. The default join created is a full outer join.

  B. The default join is an inner join.

  C. A Cartesian product is created by default.

  D. Join conditions once created cannot be modified in an information map.

  Correct Answer: B

• Question 82:

  In SAS Information Map Studio, where can you set the Initial Creation Rule for relationships between data sources?

  A. Resources pane

  B. Options window

  C. Properties pane

  D. Design tab

  Correct Answer: B

• Question 83:

  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. Only the SQL code generated by the information map

  C. First the stored process code followed by the SQL code generated by the information map

  D. First the SQL code generated by the information map followed by the stored process code

  Correct Answer: C

• Question 84:

  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

  Correct Answer: C

• Question 85:

  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 libref OSDM registered in the metadata.

  B. There is no library named Orion Reporting Library registered in the metadata.

  C. The Libname statement is not compatible with the VALIDVARNAME option.

  D. The stored process is not registered to the Orion Reporting Library in the metadata.

  Correct Answer: B

• Question 86:

  In a stored process, a multiple value prompt selection named Country is used. Which macro variable can a developer use in SAS code to determine how many values the user selected?

  A. Country_COUNT

  B. Country_INDEX

  C. Country_NUM

  D. Country_NUNIQUE

  Correct Answer: A

• Question 87:

  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

  Correct Answer: D

• Question 88:

  What is the significance of the %STPBEGIN statement? (Choose two.)

  A. Initializes the ODS system

  B. Initiates the prompting for parameters

  C. Processes the user written SAS code

  D. Generates the reserve macro variables

  Correct Answer: AD

• Question 89:

  Refer to the exhibit.

  

  When attempting to create a stored process from the entire SAS Enterprise Guide project (Process Flow)

  you receive a warning message window (shown in the exhibit). The warning message is a result of the project containing:

  A. a data source

  B. multiple tasks

  C. a code node

  D. a stored process

  Correct Answer: D

• Question 90:

  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

  Correct Answer: D