Database Administration Quiz
10 Questions
5 Views

Database Administration Quiz

Created by
@SupremeVerisimilitude

Questions and Answers

How can the system database administrator disable tenant database functionalities? Note: There are 2 correct answers to this question.

  • Using the hdbuserstore tool
  • Using the Manage Restricted Features app
  • Using the Manage Database Configuration app (correct)
  • Using the resident hdblcm tool (correct)
  • When using the java Startup and Control Framework to shut down an AS Java-based SAP system, which of the following stop the server process(es)?

  • Instance Controller
  • Database
  • ICM
  • Sapstartsrv (correct)
  • Which file system locations do you need to specify when installing the SAP HANA multi-host database system using the default settings? Note: There are 2 correct answers to this question.

  • /usr/sap/hostctrl
  • /hana/shared (correct)
  • /hana/log/<SID> (correct)
  • /usr/sap/<SID>
  • You want to configure the TMS QA Approval procedure for an AS ABAP-based system landscape. Which approval steps can you choose? Note: There are 3 correct answers to this question.

    <p>To be approved by request owner</p> Signup and view all the answers

    For an SAP HANA tailored datacenter integration (TDI) approach, what is the additional disk space factor required during delta merge operations?

    <p>1.2</p> Signup and view all the answers

    In which situations can you resume the failed recovery of your productive SAP HANA tenant database? 2

    <p>An aborted recovery of a delta data backup</p> Signup and view all the answers

    You are installing an SAP S/4HANA Server 1909 system, using s4xhost as application server host and haxhost as database host. Which actions can Software Provisioning Manager (SWPM) perform? Note: 3

    <p>Set database import parameters for the database running on haxhost</p> Signup and view all the answers

    You are installing an SAP S/4HANA Server 2021 system, using s4xhost as application server host and haxhost as database host Which actions can Software Provisioning Manager (SWPM) perform? 2

    <p>Install the Central Services instance on s4xhost</p> Signup and view all the answers

    Which parameters are mandatory when using the HDBLCM tool to install the SAP HANA database system in batch mode? Note: 2

    <p>SAP HANA System ID (SID)</p> Signup and view all the answers

    You are updating an AS Java-based SAP system. Which actions can Software Update Manager execute? 2

    <p>Lock the development environment</p> Signup and view all the answers

    Study Notes

    Database Administration

    • Tenant database functionalities can be disabled via database management utilities or configuration files.
    • Access control mechanisms can be used to restrict tenant database features for certain users.

    SAP System Shutdown

    • The Java Startup and Control Framework allows stopping server processes through shutdown commands.
    • Admins can use specific control scripts to gracefully terminate server operations in an AS Java-based SAP environment.

    SAP HANA Installation

    • During the installation of SAP HANA multi-host system, the data file location and log file location must be specified.
    • Default settings usually require configuration of both shared and local storage locations for optimal performance.

    TMS QA Approval Procedure

    • The TMS QA approval procedure can include steps for development, quality assurance, and production approval.
    • Custom approvals can be tailored to organizational practices and project needs ensuring proper changes are validated.

    SAP HANA TDI Additional Disk Space

    • During delta merge operations in a SAP HANA tailored datacenter integration (TDI) approach, the additional disk space factor required is typically 1.5 times the size of the largest delta.
    • This factor considers the need for temporary data storage during the merge process.

    Failed Recovery of SAP HANA Tenant Database

    • Recovery of a failed productive SAP HANA tenant can be resumed if there are valid backups available.
    • The process can be restarted automatically if the system was configured for such a contingency.

    Software Provisioning Manager Actions - SAP S/4HANA Server 1909

    • SWPM can perform installation of the database and application server.
    • It handles system landscape configuration and prepares the environment for SAP S/4HANA deployment.

    Software Provisioning Manager Actions - SAP S/4HANA Server 2021

    • Similar to the 1909 version, SWPM can be utilized for both server and database installations.
    • It streamlines the migration process from previous SAP versions to the 2021 version.

    HDBLCM Tool Parameters

    • Mandatory parameters for HDBLCM tool in batch mode include instance number and system identifier (SID).
    • These ensure proper installation and configuration of the SAP HANA database system.

    Software Update Manager Actions

    • During updates of an AS Java-based SAP system, Software Update Manager can execute automatic updates of components.
    • It can also handle database schema adjustments as part of the update process.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Description

    Test your knowledge on how a system database administrator can effectively disable tenant database functionalities. This quiz focuses on identifying the correct methods for administration tasks, with two correct answers. Enhance your skills in database management and ensure optimal performance.

    Use Quizgecko on...
    Browser
    Browser