A00-250 Online Practice Questions and Answers

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.

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.

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.

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

A. Batch server, metadata server, objectspawner, OLAP server, pooled workspace server, stored process server, workspace server

B. Workspace server, stored process server, pooled workspace server, OLAP server, objectspawner, metadata server, batch server

C. Metadata server, batch server, objectspawner, OLAP server, pooled workspace server, stored process server, workspace server

D. Metadata server, objectspawner, OLAP server

By default, the SASMeta application server context:

A. can only be accessed by unrestricted users.

B. is a backup for theSASApp application server context.

C. only holds the metadata server definition.

D. holds the metadata server definition and a definition for a workspace server and DATA step batch server used for administrative functions.

You have used the SAS Management Console to unregister a repository. Which statement is true?

A. The metadata and physical files for the repository are deleted.

B. The metadata for the repository is deleted but the physical files are not affected.

C. The metadata for the repository is not affected but the physical files are deleted.

D. The metadata and physical files for the repository are not affected.

Which statement is FALSE regarding the use of the OMABAKUP macro to backup the SAS environment?

A. It can be used to restore the backup files.

B. It can be used to reclaim unused disk space with the REORG option.

C. It stops the metadata server while performing a backup.

D. It creates a backup with minimal disruption in service.

A user needs to access data in a cube. The user has the following characteristics: Is in Enterprise Guide: OLAP role Does not have Read and ReadMetadata permissions for the cube.

What will be the result when the user attempts to access data in the cube?

A. The user will be able to access the data since Read andReadMetadata permissions are not required.

B. The user will be able to access the data since they are using Enterprise Guide.

C. The user will be able to access the data since they are in the OLAP Role.

D. The user will not be able to access the data.

A platform administrator needs to update service account passwords in the metadata and configuration files.

How can the platform administrator perform this configuration task?

A. Modify theRollingFileAppender.

B. Use the Server Manager plug-in.

C. Use the SAS Deployment Manager.

D. Modify the UpdatePasswords.html file.

Metadata repositories are a collection of files in a physical folder. In what format are the files stored?

A. XML

B. SAS metadata sets

C. SAS data sets

D. SGML