SAS Institute A00-250 Online Practice Questions and Exam Preparation

SAS Institute A00-250 Online Questions & Answers

• Question 1:

  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 the platform administrator perform these tasks?

  A. open the Server Monitoring OLAP Tab
  B. open the Server Monitoring Servers Tab
  C. use the SAS OLAP Server Monitor plug-in
  D. use the SAS Server Processes plug-in
  C. use the SAS OLAP Server Monitor plug-in

• Question 2:

  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.
  B. The metadata for the repository is deleted but the physical files are not affected.

• Question 3:

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

  A. Directly applied and ACT applied, Inherited from parent, Inherited from default ACT
  B. ACT applied, Directly applied, Inherited from parent, Inherited from default ACT
  C. Inherited from parent, Inherited from default ACT, ACT applied, Directly applied
  D. Directly applied, Inherited from parent, ACT applied, Inherited from default ACT
  A. Directly applied and ACT applied, Inherited from parent, Inherited from default ACT

• Question 4:

  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
  D. Metadata server, objectspawner, OLAP server

• Question 5:

  Identify the repository that holds information about the other repositories in the environment.

  A. custom repository
  B. foundation repository
  C. project repository
  D. repository manager
  D. repository manager

• Question 6:

  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?

  A. OLAP server
  B. Workspace server
  C. OLAP and workspace server
  D. OLAP and batch server
  A. OLAP server

• Question 7:

  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.
  D. Security can be applied in SAS metadata and in the RDBMS.

• Question 8:

  A platform administrator wants to prevent all restricted users from accessing data that requires the Read permission. Which permission level(s) should the platform administrator assign?

  A. RM and R for PUBLIC
  B. RM and R for PUBLIC and SAS Administrators
  C. R for PUBLIC
  D. RM for PUBLIC and SAS System Services
  C. R for PUBLIC

• Question 9:

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

  A. Modify theRollingFileAppender.
  B. Use the IOMServerAppender to specify the message.
  C. Use the Server Manager plug-in to modify the logger settings dynamically.
  D. Modify the logconfig.xml file.
  C. Use the Server Manager plug-in to modify the logger settings dynamically.

• Question 10:

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

  A. Use the restore job created by the Backup Wizard.
  B. Execute the restoreServer.sas program.
  C. Write custom code to invoke the OMABAKUP macro with the RESTORE option enabled.
  D. Use the RESTORE macro.
  D. Use the RESTORE macro.