A00-250 practice question 10 of 15
For metadata library connections to an RDBMS, which statement is true?
Full set: 65 questionsWhen accessing a Relational Database Management System (RDBMS) through a SAS metadata-defined library, a dual-layered security model is applied. First, the SAS Metadata Server evaluates the user's permissions on the metadata objects (e.g., the library and table definitions). A user must have at least ReadMetadata permission to see the library. If this check passes, the connection is attempted. Second, the RDBMS enforces its own native security model. The credentials used for the database connection must have the appropriate privileges (e.g., SELECT, INSERT) on the underlying database objects. Access is granted only when permissions are sufficient in both security layers.
A. Security is applied to the metadata object itself, regardless of whether the library is pre-assigned or assigned dynamically upon request.
B. This is false because it ignores the mandatory SAS metadata security layer that controls access to the library definition itself.
C. This is false because the RDBMS always enforces its own native security on the physical data, independent of SAS metadata permissions.
1. SAS® 9.4 Intelligence Platform: Security Administration Guide, Second Edition.
Reference: Chapter 11, "Securing Data," Section: "How Authorization Decisions Are Made for Data," p. 163.
Quote/Concept: The documentation explains the flow of authorization. It states, "For external data such as a table in an Oracle database, the database server makes the final decision about whether to grant access." This confirms that the RDBMS security is the final authority on the data, while preceding paragraphs describe how the SAS Metadata Server first checks permissions on the metadata objects.
2. SAS/ACCESS® 9.4 for Relational Databases: Reference, Eighth Edition.
Reference: Part 1, "SAS/ACCESS Concepts," Chapter 2, "SAS/ACCESS LIBNAME Statement," Section: "LIBNAME Statement Syntax for Relational Databases," p. 20.
Quote/Concept: The documentation details connection options like USER= and PASSWORD=, stating these are the "database user name" and "database password." This explicitly shows that authentication and subsequent authorization are handled by the target RDBMS using its own security credentials, which is separate from the SAS metadata security layer.
Keep practicing
Take the free A00-250 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other A00-250 practice questions
- Question 1A platform administrator needs to restore backup files to a running metadata server. Whic…
- Question 2How many object spawners, at a minimum, need to be defined in the metadata?
- Question 3The passwords for service accounts that occur in some of the configuration files have bee…
- Question 4A platform administrator needs to associate a library with an application server. What pe…
- Question 5What is the correct order in which to start up the SAS servers and spawners?
- Question 6An internal account is used to provide the initial connection to which server?
