SAS A00-250 Exam Practice Test Instant Access

Question 1

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

AUpdate Metadata option in Data Library Manager in SAS Management Console.

BUpdate Library Metadata task in SAS Enterprise Guide.

CUpdate Metadata option in SAS Data Integration Studio.

DMETALIB procedure using SAS code.

Answer : D

Question 2

A platform administrator needs to register CLAP cubes. What permission levels are required for this task?

ACM for the target folder and WMM for the CLAP schema.

BWM for the CLAP schema and RMLE for the target folder.

CWM for the target folder and WMM for the CLAP schema.

DWM for the CLAP schema and WMM for the target folder.

Answer : D

Question 3

You used the SAS Add-In for Microsoft Office in Microsoft Excel to view a SAS OLAP cube. Which type of server is used to access the OLAP cube?

AOLAP server

BWorkspace server

COLAP and workspace server

DOLAP and batch server

Answer : A

Question 4

The SAS configuration directory on each server machine must be protected by:

Ametadata access controls.

Boperating system controls.

Cthe Authorization Manager of SAS Management Console.

Dthe default Access Control Template (ACT).

Answer : B

Question 5

In most deployments of the Platform for SAS Business Analytics, which type of access requires passwords for external accounts to be stored in the metadata?

Aseamless access to the SAS datasets

Bseamless access to SAS OLAP cubes

Cseamless access to external databases

Dall of the above

Answer : C

Question 6

Given the following applications:

- SAS Add-in for Microsoft Office

- SAS Enterprise Guide By default,

How do these applications assign libraries?

Aby using the SAS/ACCESS interface

Bby using the metadata LIBNAME engine

Cby using the BASE SAS engine

Dby using the server autoexec file

Answer : B

Question 7

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?

Adelete repository

Bdelete physical library

Cdelete the table's metadata folder

Dupdate table metadata

Answer : D

SAS Certified Platform Administrator for SAS A00-250 Exam Practice Test