A00-250 Exam Questions

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...

In order of precedence from highest to lowest, how are permissions on a metadata item evaluated?

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

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

What is the purpose of the SASFILE statement?

Which statement(s) in the DATASETS procedure alter(s) the name of a SAS data set stored in a SAS data library?

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...

Which statement regarding default groups is true?

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 Sales...

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

A platform administrator wants to physically segregate the physical storage for metadata in a single environment. What should the platform administrator create?

A user needs to modify metadata. Which method should be used?

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?

If a server or spawner is failing to start, what would be the most appropriate first step in troubleshooting the cause of the failure?

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

By default, the SASMeta application server context:

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

Identify the object type that can be promoted.

Your environment contains a restore program named restoreServer.sas. Which statement regarding restoreServer.sas is FALSE?

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

In what state must the metadata server be in if you choose to use operating system commands to backup metadata repositories?

A platform administrator used operating system commands to backup the metadata repositories and repository manager in a SAS environment. When the platform administrator attempted t...

A platform administrator needs to restore backup files to a running metadata server. Which macro can the platform administrator use to perform this task?

The metadata server is stopped. What will be the result when operating system commands are used to backup the metadata repositories and repository manager?

Which of the following is NOT a method you could use to restore your SAS environment?

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 Wh...

Which role is not pre-defined?

The suffix of a SAS Internal account is:

An internal account is used to provide the initial connection to which server?

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?

How do you modify the logging levels of a server without having to restart the server?

A platform administrator needs to update service account passwords in the metadata and configuration files. How can the platform administrator perform this configuration task?

Place the Log events in order of Diagnostic Level for severity from Highest (most severe) to Lowest.

Which process does NOT create a log file by default?

A platform administrator is working with SAS OLAP servers and wants to: - display all OLAP servers and schemas - provide session controls - manage advanced server options How can t...

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

Which statement is FALSE? Updating table metadata enables you to:

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 lib...

The METALIB procedure enables you to update table metadata. Which method does NOT provide access to the METALIB procedure?

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 platform administrator needs to delete metadata for table definitions with the following characteristics: - the table definitions exist in the metadata repository - the table def...

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

What is an advantage of using a hash object in a SAS DATA step?

Which statement is an advantage of pre-assigned libraries?

Which statement is a disadvantage of pre-assigned libraries?

Which statement regarding precedence principles for authorization is FALSE?

Which of the following is true about the COMPRESS=YES data set option?

Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data set?

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...

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 gran...