SAS A00-250 Practice Questions with Explanations

Free SAS A00-250 practice questions. 23 of them, each with the correct answer, a full explanation, and the reason every other option is wrong.

A00-250 practice questions

Question 1

Select the method for updating table metadata that provides for the most control over updating features and can be run in batch.

  • A. Update Metadata option in Data Library Manager in SAS Management Console.
  • B. Update Library Metadata task in SAS Enterprise Guide.
  • C. Update Metadata option in SAS Data Integration Studio.
  • D. METALIB procedure using SAS code.
Show answer and explanation ▾

Correct answer: D

The METALIB procedure gives the most control over updating options and, being SAS code, can run in batch. The other options are interactive tools.

Why the other options are wrong:

  • A. The Update Metadata option in Data Library Manager is interactive and cannot run in batch.
  • B. The Update Library Metadata task in SAS Enterprise Guide is interactive and gives less control.
  • C. The Update Metadata option in SAS Data Integration Studio is interactive and gives less control.

Question 2

Which statement is FALSE?

Updating table metadata enables you to:

  • A. add table metadata for tables that exist in the physical library but have no metadata in the repository.
  • B. update table definitions to match corresponding physical tables.
  • C. update table security settings at the metadata and operating system level.
  • D. delete metadata for table definitions that exist in the metadata repository but do not have a corresponding table in the physical library.
Show answer and explanation ▾

Correct answer: C

Updating table metadata adds, updates and deletes table definitions to match the physical library. It does not change table security settings, so the statement about security is false.

Why the other options are wrong:

  • A. True: updating metadata can add metadata for physical tables that have none.
  • B. True: updating metadata can bring table definitions in line with the physical tables.
  • D. True: updating metadata can delete definitions with no matching physical table.

Question 3

A client wants to have their system set up so that stored processes can access libraries without having to manage library assignments in the stored process code.

How should the libraries be assigned?

  • A. by default
  • B. by client application
  • C. by pre-assignment
  • D. by user access
Show answer and explanation ▾

Correct answer: C

A pre-assigned library is assigned when the server starts, so stored processes can use it without library assignment code of their own.

Why the other options are wrong:

  • A. Assignment by default is not a library assignment method for this purpose.
  • B. Assignment by client application leaves each client to assign the library.
  • D. Assignment by user access is not a library assignment method.

Question 4

The METALIB procedure enables you to update table metadata.

Which method does NOT provide access to the METALIB procedure?

  • A. SAS Management Console's update metadata feature
  • B. SAS Enterprise Guide Explorer's library management feature
  • C. SAS Data Integration Studio's update table metadata feature
  • D. custom code using PROC METALIB.
Show answer and explanation ▾

Correct answer: B

SAS Enterprise Guide Explorer's library management feature does not provide access to PROC METALIB. The Management Console, Data Integration Studio and custom code all do.

Why the other options are wrong:

  • A. The update metadata feature in SAS Management Console runs the METALIB procedure.
  • C. The update table metadata feature in SAS Data Integration Studio runs the METALIB procedure.
  • D. Custom code using PROC METALIB calls the procedure directly.

Question 5

A host is using an LDAP provider as a back-end authentication mechanism. For this setup, how does the SAS server view the authentication?

  • A. integrated authentication
  • B. back-end authentication
  • C. internal authentication
  • D. host authentication
Show answer and explanation ▾

Correct answer: D

When the host uses an LDAP provider as its back-end authentication mechanism, the SAS server views this as host authentication.

Why the other options are wrong:

  • A. Integrated authentication is a different mechanism, based on the Windows login.
  • B. Back-end authentication is how the host works, not how the SAS server views it.
  • C. Internal authentication is used for accounts stored in SAS metadata.

Question 6

A platform administrator needs to delete metadata for table definitions with the following characteristics: - the table definitions exist in the metadata repository - the table definitions do not have a corresponding table in the physical library After performing impact analysis, what action should the platform administrator take?

  • A. delete repository
  • B. delete physical library
  • C. delete the table's metadata folder
  • D. update table metadata
Show answer and explanation ▾

Correct answer: D

Updating table metadata compares the registered table definitions with the physical library and can remove the definitions that no longer have a matching physical table. It cleans up the stale entries and leaves the library, its folder and the repository in place.

Why the other options are wrong:

  • A. Deleting the repository would remove all metadata, far more than the stale table definitions.
  • B. Deleting the physical library removes data and does nothing to the stale definitions held in metadata.
  • C. Deleting the folder would also remove valid table definitions and other items stored in it.

Question 7

Given the following applications: - SAS Add-in for Microsoft Office - SAS Enterprise Guide By default, How do these applications assign libraries?

  • A. by using the SAS/ACCESS interface
  • B. by using the metadata LIBNAME engine
  • C. by using the BASE SAS engine
  • D. by using the server autoexec file
Show answer and explanation ▾

Correct answer: B

When a library is not pre-assigned, SAS Enterprise Guide and SAS Add-in for Microsoft Office assign it with the metadata LIBNAME engine. The engine reads the library definition from metadata and enforces the metadata permissions set on its tables.

Why the other options are wrong:

  • A. A SAS/ACCESS interface is an engine for a specific database, not the default way these clients assign libraries.
  • C. The BASE engine reads SAS data sets directly and is not the default assignment method for these clients.
  • D. The server autoexec file is one way an administrator pre-assigns a library, not the default method these clients use.

Question 8

A customer's environment has a standard workspace server instantiated by the object spawner.

What authentication is required to support this configuration?

  • A. back-end authentication
  • B. integrated authentication
  • C. host authentication
  • D. internal authentication
Show answer and explanation ▾

Correct answer: C

A standard workspace server runs under the host identity of the requesting user, so the object spawner must authenticate that user against the operating system of the server machine. The user therefore needs a valid host account.

Why the other options are wrong:

  • A. Back-end authentication is not the term for the check that launches a standard workspace server.
  • B. Integrated Windows authentication is an optional sign-on method, not a requirement of this configuration.
  • D. Internal accounts exist only in metadata and cannot launch a standard workspace server process on the host.

Question 9

Which statement is an advantage of pre-assigned libraries?

  • A. Libraries are available in stored processes with no additional steps.
  • B. Metadata security is always applied to pre-assigned libraries.
  • C. User-written formats are only available to pre-assigned libraries.
  • D. Maintenance is reduced for the platform administrator.
Show answer and explanation ▾

Correct answer: A

A pre-assigned library is allocated automatically when the SAS server session starts, so stored processes and other code can reference its libref without issuing a LIBNAME statement first.

Why the other options are wrong:

  • B. Metadata security is not always applied, because it depends on the engine used for the pre-assignment.
  • C. User-written formats do not depend on whether a library is pre-assigned.
  • D. Pre-assignment adds configuration work for the administrator and does not reduce maintenance.

Question 10

Which statement is a disadvantage of pre-assigned libraries?

  • A. The server does not become available to the user until all pre-assigned libraries have been assigned.
  • B. Pre-assigned libraries must be identical across all SAS client applications.
  • C. Pre-assigned libraries must be assigned using the autoexec file.
  • D. The administrator cannot control which engine is used to access data in a pre-assigned library.
Show answer and explanation ▾

Correct answer: B

A pre-assigned library is assigned by the server at startup, so every client application that connects to that server receives the same assignment. The library cannot be assigned differently for individual client applications.

Why the other options are wrong:

  • A. This is not the listed disadvantage of pre-assigning libraries.
  • C. The autoexec file is only one option, since a library can also be pre-assigned through its metadata definition.
  • D. The administrator does control the engine, by choosing how the library is pre-assigned.

Question 11

Given the following authorization setup: - Mary is a direct member of DeptA and DeptB - Library Sales2 has an ACT denial for DeptA. - Library Sales2 has an explicit grant for DeptB. Which statement is true?

  • A. Mary can see Library Sales2.
  • B. Mary cannot see Library Sales2.
  • C. Mary can see Library Sales2 for data associated with DeptB only.
  • D. Mary can see Library Sales2 for data flagged as PUBLIC only.
Show answer and explanation ▾

Correct answer: A

DeptA and DeptB are both direct groups for Mary, so identity precedence is tied. The conflict is then settled by the type of setting, and an explicit grant outranks a denial that comes from an ACT, so Mary can see the library.

Why the other options are wrong:

  • B. The ACT denial loses to the explicit grant at the same identity level.
  • C. Library visibility is not divided by department data.
  • D. No setting in this scenario limits Mary to data flagged as PUBLIC.

Question 12

The WriteMemberMetadata (WWM) permission is only found on which type of items?

  • A. Data libraries
  • B. Folders
  • C. Information Maps
  • D. Data sets
Show answer and explanation ▾

Correct answer: B

WriteMemberMetadata applies only to folders. It controls whether a user can add items to the folder or remove items from it, separately from WriteMetadata on the folder itself.

Why the other options are wrong:

  • A. Libraries do not carry the WriteMemberMetadata permission.
  • C. Information maps do not carry the WriteMemberMetadata permission.
  • D. Data sets do not carry the WriteMemberMetadata permission.

Question 13

Which statement regarding precedence principles for authorization is FALSE?

  • A. Settings on an item have priority over settings on the item's parent.
  • B. If identity precedence and the type of setting do not resolve a conflict, the outcome is a denial.
  • C. Explicit settings have priority over ACT settings.
  • D. A direct member of multiple groups cannot have conflicting settings.
Show answer and explanation ▾

Correct answer: D

A user who is a direct member of several groups can receive conflicting settings, such as a grant for one group and a denial for another. The precedence rules exist to resolve exactly that kind of conflict, so the statement is false.

Why the other options are wrong:

  • A. This statement is true, because settings on an item outrank settings inherited from its parent.
  • B. This statement is true, because an unresolved conflict ends in a denial.
  • C. This statement is true, because an explicit setting outranks an ACT setting at the same identity level.

Question 14

A platform administrator needs to register OLAP cubes.

What permission levels are required for this task?

  • A. CM for the target folder and WMMfor the OLAP schema.
  • B. WM for the OLAP schema and RMLE for the target folder.
  • C. WM for the target folder and WMM for the OLAP schema.
  • D. WM for the OLAP schema and WMM for the target folder.
Show answer and explanation ▾

Correct answer: D

Registering a cube changes the OLAP schema it is associated with, which needs WriteMetadata on the schema. It also adds a new item to a folder, which needs WriteMemberMetadata on the target folder.

Why the other options are wrong:

  • A. WriteMemberMetadata does not apply to an OLAP schema, and CheckInMetadata is not what registering a cube requires.
  • B. ReadMetadata on the target folder does not allow a new item to be added to it.
  • C. WriteMemberMetadata applies to folders, not to an OLAP schema.

Question 15

Which permissions are found on all metadata item types?

  • A. RM WM RMM RW Administer
  • B. RM WM RW Administer
  • C. RM WM Administer
  • D. RM WM
Show answer and explanation ▾

Correct answer: D

ReadMetadata and WriteMetadata are the only permissions that apply to every type of metadata item. The other permissions are specialized and are relevant only for certain item types.

Why the other options are wrong:

  • A. Read, Write, ReadMemberMetadata and Administer are not relevant for every item type.
  • B. Read, Write and Administer are not relevant for every item type.
  • C. Administer is relevant only for certain server items.

Question 16

A platform administrator needs to associate a library with an application server.

What permission level on the application server will the platform administrator need for this task?

  • A. CM
  • B. RMLE
  • C. WM
  • D. WMM
Show answer and explanation ▾

Correct answer: C

Associating a library with an application server changes the metadata of that server, so the administrator needs WriteMetadata on the application server.

Why the other options are wrong:

  • A. CheckInMetadata relates to change-managed check-in and is not what this task requires.
  • B. ReadMetadata only lets the administrator see the server, not change it.
  • D. WriteMemberMetadata applies to folders, not to an application server.

Question 17

Given the following authorization setup: - Mary is a direct member of DeptA and DeptB - Library Sales2 has an explicit RM denial for DeptA. - Library Sales2 has an explicit RM grant for DeptB. Which statement is true?

  • A. Mary can see Library Sales2.
  • B. Mary cannot see Library Sales2.
  • C. Mary can see Library Sales2 for data associated with DeptB only.
  • D. Mary can see Library Sales2 for data flagged as PUBLIC only.
Show answer and explanation ▾

Correct answer: B

Both groups are direct groups for Mary and both settings are explicit, so neither identity precedence nor the type of setting resolves the conflict. An unresolved conflict ends in a denial, so Mary cannot see the library.

Why the other options are wrong:

  • A. The explicit grant does not win, because an equal-level conflict resolves to a denial.
  • C. Library visibility is not divided by department data.
  • D. No setting in this scenario limits Mary to data flagged as PUBLIC.

Question 18

For metadata library connections to an RDBMS, which statement is true?

  • A. Security is only applied if the library is pre-assigned.
  • B. Security can be applied only in the RDBMS.
  • C. Security can be applied only in SAS metadata.
  • D. Security can be applied in SAS metadata and in the RDBMS.
Show answer and explanation ▾

Correct answer: D

A library that connects to a database can be protected at two layers. Metadata permissions control who can see and use the library and table definitions, and the database enforces its own privileges for the account that connects.

Why the other options are wrong:

  • A. Security does not depend on the library being pre-assigned.
  • B. Security is not limited to the database, because metadata permissions also apply.
  • C. Security is not limited to SAS metadata, because the database still enforces its own privileges.

Question 19

A platform administrator wants to provide SAS Administrators and service identities with exclusive read access to metadata.

Which permission levels should the platform administrator assign?

  • A. RM for PUBLIC, SAS Administrators, and SAS System Services
  • B. RM and R for PUBLIC, SAS Administrators, and SAS System Services
  • C. RM for PUBLIC, and R for SAS Administrators and SAS System Services
  • D. R for PUBLIC, and RM for SAS Administrators and SAS System Services
Show answer and explanation ▾

Correct answer: A

The ability to read metadata is controlled by the ReadMetadata permission alone. The assignment therefore uses ReadMetadata settings only, for PUBLIC, which covers every user, and for SAS Administrators and SAS System Services, the groups that are to keep that access.

Why the other options are wrong:

  • B. The Read permission governs data access, not the ability to read metadata.
  • C. Read for SAS Administrators and SAS System Services does not control who can read metadata.
  • D. A Read setting for PUBLIC does not control who can read metadata.

Question 20

An identity hierarchy specifies a list of identities and the order of precedence of those identities.

Which listing of identities is ranked from highest priority to lowest priority?

  • A. User, direct group, indirect group, SASUSERS, PUBLIC
  • B. User, SASUSERS, PUBLIC, directgroup, indirect group
  • C. SASUSERS, PUBLIC, User, direct group, indirect group
  • D. direct group, indirect group, User, PUBLIC, SASUSERS
Show answer and explanation ▾

Correct answer: A

The user's own identity has the highest precedence, followed by groups the user belongs to directly, then groups reached through nested membership. The implicit groups come last, with SASUSERS ahead of PUBLIC.

Why the other options are wrong:

  • B. SASUSERS and PUBLIC rank below direct and indirect groups, not above them.
  • C. The implicit groups have the lowest precedence, not the highest.
  • D. The individual user identity always ranks above any group.

Question 21

Which statement regarding default groups is true?

  • A. SASUSERS is a subset of PUBLIC
  • B. PUBLIC is a subset of SASUSERS
  • C. SASUSERS is a subset of ADMINISTRATORS
  • D. ADMINISTRATORS is a subset of Unrestricted Users
Show answer and explanation ▾

Correct answer: A

PUBLIC includes everyone who can authenticate. SASUSERS includes only those members of PUBLIC who also have a registered identity in metadata, so SASUSERS is a subset of PUBLIC.

Why the other options are wrong:

  • B. PUBLIC is the broader group, so it is not a subset of SASUSERS.
  • C. SASUSERS contains every registered user, not only administrators.
  • D. Unrestricted status comes from a metadata server role, and administrators are not defined as a subset of it.

Question 22

Given the following authorization setup: - Mary is a direct member of DeptA. - DeptA is a direct member of DeptB. - Library Sales2 has an explicit denial for DeptA. - Library Sales2 has an explicit grant for DeptB. Which statement is true?

  • A. Mary can see Library Sales2.
  • B. Mary cannot see Library Sales2.
  • C. Mary can see Library Sales2 for data associated with DeptB only.
  • D. Mary can see Library Sales2 for data flagged as PUBLIC only.
Show answer and explanation ▾

Correct answer: B

DeptA is a direct group for Mary, while DeptB is an indirect group she reaches only through DeptA. A direct group has higher identity precedence, so the explicit denial for DeptA wins and Mary cannot see the library.

Why the other options are wrong:

  • A. The grant for DeptB is at a lower identity level than the denial for DeptA.
  • C. Library visibility is not divided by department data.
  • D. No setting in this scenario limits Mary to data flagged as PUBLIC.

Question 23

What is the correct order in which to start up the SAS servers and spawners?

  • A. Batch server, metadata server, object spawner, OLAP server, pooled workspace server, stored process server, workspace server
  • B. Workspace server, stored process server, pooled workspace server, OLAP server, object spawner, metadata server, batch server
  • C. Metadata server, batch server, object spawner, OLAP server, pooled workspace server, stored process server, workspace server
  • D. Metadata server, object spawner, OLAP server
Show answer and explanation ▾

Correct answer: D

The metadata server starts first because every other server depends on it. Workspace, pooled workspace and stored process servers are launched on demand by the object spawner, and batch servers run only when a job is submitted, so none of them is started as a separate step.

Why the other options are wrong:

  • A. The batch server cannot come first, because the metadata server must be running before anything else.
  • B. The metadata server must start first, not near the end.
  • C. Batch, workspace, pooled workspace and stored process servers are not started as separate steps.

That was 23 of 65.

The full SAS A00-250 pack has all 65 questions, each with the answer, the explanation and why the other options are wrong, plus a questions-only copy for timed runs. $39.00 USD, paid once, with free monthly updates and a pass-or-your-money-back guarantee.

Get the full pack

Not ready yet? Get the first 23 free as one PDF by email. Get the Half Pack →

About the A00-250 exam

These 23 SAS A00-250 questions are free here, and as a free PDF by email.

They are drawn from the same bank as the full A00-250 pack, which has 65 questions in total.

Back to blog