Learn, Practice, and Improve with SAP C_TADM_23 Practice Test Questions

  • 80 Questions
  • Updated on: 13-Jan-2026
  • SAP Certified Technology Consultant – SAP S/4HANA System Administration
  • Valid Worldwide
  • 2800+ Prepared
  • 4.9/5.0

Which characteristics describe an SAP HANA multitenant database container (MDC) system? Note: There are 3 correct answers to this question

A. Each tenant database runs its own compile server and the preprocessor server.

B. The name server owns Information about the location of tables and table partitions in databases.

C. Database isolation increases the isolation between tenant databases on operating system level.

D. The name server provides index server functionality tor the system database.

E. A multitenant database container system is identified by a single system ID (SID).

B.   The name server owns Information about the location of tables and table partitions in databases.
D.   The name server provides index server functionality tor the system database.
E.   A multitenant database container system is identified by a single system ID (SID).

Explanation:

An SAP HANA multitenant database container (MDC) system is an architecture in which a single SAP HANA system hosts one system database and multiple tenant databases. This design enables efficient resource usage while maintaining logical separation between tenants.

Option B is correct because, in an SAP HANA MDC system, the name server plays a central role in system topology management. It stores and manages metadata about the distribution and location of tables and table partitions across hosts. This information is essential for query routing, load balancing, and high availability within the SAP HANA system and applies to both the system database and tenant databases.

Option D is correct because, unlike tenant databases, the system database does not have a separate index server. Instead, the name server also provides index server functionality for the system database. This is a specific architectural characteristic of MDC systems and is frequently tested in certification exams.

Option E is correct because an SAP HANA MDC system is identified by one single System ID (SID) at the operating system and installation level. All tenant databases within the MDC system share the same SID, even though each tenant has its own database name and users. This single-SID concept distinguishes MDC systems from multiple standalone SAP HANA installations.

Option A is incorrectbecause tenant databases do not run their own compile server and preprocessor server. These services are shared at the system level, which improves efficiency and reduces resource consumption.

Option C is incorrect because database isolation in MDC systems is logical, not at the operating system level. All tenant databases run within the same SAP HANA system and OS instance. While MDC improves isolation compared to classic single-container systems, it does not provide OS-level isolation.

References
SAP Help Portal – SAP HANA Multitenant Database Containers (MDC)
SAP Help Portal – SAP HANA Administration Guide – System Architecture

Using standard Ip settings, what are features of transport strategy "Queue-Driven Transports. Mass transports" but NOT of transport strategy "Queue-Driven Transports Single transports"? Note: There are 3 correct answers to this question.

A. The import process can be scheduled in the background

B. Using the 'Import Request' function causes the imported transport requests to remain in the import queue.

C. Return Code 8 is considered a successful import.

D. The 'Import All Requests' function is available.

E. Return Code 16 is caused by an erroneous object in a transport request

A.   The import process can be scheduled in the background
C.   Return Code 8 is considered a successful import.
D.   The 'Import All Requests' function is available.

Explanation:

This question tests the specific differences between two Transport Management System (STMS) queue import strategies. "Queue-Driven Transports, Mass Transports" is designed for high-volume, batch-like processing of multiple transports, while "Queue-Driven Transports, Single Transports" is for more controlled, sequential handling.

A. The import process can be scheduled in the background.
This is a key feature of the Mass Transports strategy. It allows administrators to schedule the entire import queue to run at a specific time (e.g., during a maintenance window) as a background job, minimizing manual intervention. The Single Transports strategy is interactive and queue-driven but does not offer this background scheduling option.

C. Return Code 8 is considered a successful import.
In the Mass Transports strategy, a return code of 8 (typically meaning "warning") is treated as a successful import to allow the queue to proceed. This is critical for mass processing, as it prevents a single warning (e.g., a non-critical object version conflict) from stopping the entire batch. In Single Transports, a return code of 8 would be flagged for review, halting the queue.

D. The 'Import All Requests' function is available.
This function is the primary action button for the Mass Transports strategy. It initiates the import of all requests in the queue according to the strategy's rules. The Single Transports strategy does not have this button; instead, you use "Import Request" for each item individually.


Why the other options are incorrect:

B. Using the 'Import Request' function causes the imported transport requests to remain in the import queue.
This is false for both strategies. In both cases, a successfully imported request is removed from the import queue. If it remained, it would cause duplication and clutter.

E. Return Code 16 is caused by an erroneous object in a transport request.
This statement is true for both strategies. A return code of 16 indicates an "error" (e.g., a severe import failure like a syntax error or missing object) in both transport strategies. It is not a differentiating feature.

Reference:
SAP Help documentation on "Configuring the Transport Management System (STMS)", specifically the section on defining Transport Strategies (TMS -> System Overview -> select system -> Transport Tool -> Transport Strategies). The functional differences between "Mass Transports" and "Single Transports" strategies, including the handling of return codes (8 vs. 4 vs. 16) and the available import functions, are officially defined there.

When importing a transport request, which steps are executed by a batch job? Note: There are 3 correct answers to this question

A. Import of dictionary objects

B. Distribution of dictionary objects

C. Move name tab

D. Activation of dictionary objects

E. Activation of ABAP programs

B.   Distribution of dictionary objects
C.   Move name tab
D.   Activation of dictionary objects

Explanation:

When you trigger an import in transaction STMS, the system initiates a handshake between the OS-level tools and the SAP system's background processing. This is coordinated by the RDDIMPDP (Transport Dispatcher) job, which listens for events and schedules specialized batch jobs for the following phases:

Activation of Dictionary Objects (Correct - D):
Once the metadata is imported inactively, the system must activate these structures. This is performed by the batch job RDDMASGL. It ensures that new table structures or data elements are logically consistent before they are committed to the database.

Distribution of Dictionary Objects (Correct - B):
After activation, the distribution program (job RDDIS0L) determines the "delta" between the old and new structures. It decides if a simple SQL ALTER statement is enough or if a more complex table conversion is required to adapt the database to the new dictionary definition.

Move Name Tab (Correct - C):
This step (often called MVNTAB) moves the newly created runtime objects into the active runtime environment. This is a critical technical bridge where the system begins to recognize the new structures for active use.

Why the other options are incorrect:

A. Import of Dictionary Objects:
This is performed at the operating system level by the R3trans program. It involves physical file transfer and writing to the database (inactive tables), but it is not a background batch job scheduled within the SAP ABAP environment.

E. Activation of ABAP Programs:
Unlike dictionary objects, ABAP programs (like reports or classes) are typically generated during the "Generation" phase (SGEN) or upon their first execution (Load Generation). While there is a generation step in the transport process, the term "Activation of ABAP programs" in this context is generally not a standard distinct batch phase like the DDIC activation steps.

References

SAP Course ADM100: Section on "The Transport Process" and "Import Steps."
SAP Help Portal: The Import Process which explicitly lists RDDMASGL, RDDIS0L, and RDDGENBB as the jobs responsible for these phases.

In an AS ABAP-based SAP system, a user performs the second dialog step in a dialog transaction. The dialog work process used in the first dialog step is occupied by a different user What happens with this second user request?

A. The request remains in the request queue until the dialog work process that handled the first dialog step is free again

B. The request is processed by another free dialog work process.

C. The dialog work process that handled the first dialog step performs a rollout to handle the request.

D. The request is processed asynchronously by an update work process.

B.   The request is processed by another free dialog work process.

Explanation:

In an AS ABAP-based SAP system, dialog steps are processed independently by available dialog work processes. When a user performs the second dialog step in a transaction, the system does not guarantee that the same dialog work process will handle it. Instead, the request is assigned to any free dialog work process in the system. This design ensures scalability and efficient resource utilization.

❌ Why Other Options Are Not Correct

A. The request remains in the request queue until the dialog work process that handled the first dialog step is free again:
Incorrect. SAP does not bind dialog steps to the same work process. Waiting would reduce efficiency and scalability.

C. The dialog work process that handled the first dialog step performs a rollout to handle the request:
Misleading. Rollout is indeed used, but it does not mean the same work process must handle the next step. Instead, rollout allows any free dialog work process to continue the transaction.

D. The request is processed asynchronously by an update work process:
Incorrect. Update work processes handle database updates triggered by update tasks (e.g., CALL FUNCTION IN UPDATE TASK). Dialog steps are always processed synchronously by dialog work processes, not update processes.

📚References
SAP Help Portal – Dialog Work Processes and Rollout Mechanism (help.sap.com in Bing)
SAP Community Wiki – Work Process Types in AS ABAP (wiki.scn.sap.com in Bing)

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

A. Using the Manage Restricted Features app

B. Using the resident hdblcm tool

C. Using the hdbuserstore tool

D. Using the Manage Database Configuration app

A.   Using the Manage Restricted Features app
D.   Using the Manage Database Configuration app

Explanation:

In an SAP HANA multitenant database container (MDC) system, the system database administrator has central control over tenant databases. One of the administrative responsibilities is the ability to disable or restrict tenant database functionalities to enforce governance, security, or operational constraints. SAP provides dedicated administrative tools and apps for this purpose.

Option A is correct because the Manage Restricted Features app is specifically designed to enable or disable certain tenant database features. This app allows system database administrators to centrally restrict functionalities such as database creation, start/stop operations, or other tenant-specific capabilities. It is a controlled, SAP-supported method to limit tenant behavior without directly modifying low-level system settings.

Option D is correct because the Manage Database Configuration app allows administrators to maintain global and tenant-specific configuration parameters. By adjusting certain configuration settings at the system or tenant level, the administrator can effectively disable specific tenant database functionalities. This app is commonly used to control system behavior, resource usage, and functional availability in MDC environments.

Option B is incorrect because the resident hdbLCM (hdblcm) tool is a lifecycle management utility used for installation, update, and uninstallation of SAP HANA systems and components. It does not provide functionality to enable or disable tenant database features during runtime.

Option C is incorrect because hdbuserstore is a secure credential storage tool used to store database connection information (user keys) for command-line access. It has no administrative capabilities related to controlling or disabling tenant database functionalities.

References:
SAP Help Portal – SAP HANA Multitenant Database Containers – Administration
SAP Help Portal – SAP HANA Cockpit: Manage Restricted Features

The SAP Fiori launchpad is working for your users How can you enable access to the SAP Easy Access menu tor them in the app tinder? Note: There are 2 correct answers to this question.

A. By providing an HTTP destination type H named FIORI_CLASSICUI_HTTPS (transaction SM59)

B. By applying the correct settings in the SAP Fiori launchpad configuration (transaction /UI2/FLP_SYS_CONF or /UI2/FLP_CUS_CONF>

C. By assigning the authorization to start transaction SEARCH_SAP_MENU

D. By assigning the correct target mappings, shipped via catalog /UI2/CLASSICAL_GUI_MENU

B.   By applying the correct settings in the SAP Fiori launchpad configuration (transaction /UI2/FLP_SYS_CONF or /UI2/FLP_CUS_CONF>
D.   By assigning the correct target mappings, shipped via catalog /UI2/CLASSICAL_GUI_MENU

Explanation:

Access to the SAP Easy Access menu within the SAP Fiori launchpad is controlled by enabling and exposing a specific, pre-delivered content catalog and its target mapping.

B. By applying the correct settings in the SAP Fiori launchpad configuration (transaction /UI2/FLP_SYS_CONF or /UI2/FLP_CUS_CONF).

This is the administrative activation step. In these configuration transactions, you must assign the pre-delivered content catalog /UI2/CLASSICAL_GUI_MENU to the relevant business catalog(s) or directly to the SAP_CORE_BC_UI2_USM business role template. This makes the "SAP Easy Access Menu" app available for assignment.

D. By assigning the correct target mappings, shipped via catalog /UI2/CLASSICAL_GUI_MENU.
This is the underlying technical content. The catalog /UI2/CLASSICAL_GUI_MENU contains the target mapping (e.g., CLASSIC_HTML_MENU) that launches the classic SAP GUI for HTML menu. Assigning this catalog (as done in step B) is what provides the target mapping to users.

Why the other options are incorrect:

A. By providing an HTTP destination type H named FIORI_CLASSICUI_HTTPS.
This is a distractor. While an HTTP destination to the back-end is needed for the app to function, it is automatically created by the standard SAP Fiori configuration (SAP_FIORI_CLASSIC_UI_HTTPS). Manually creating a differently named destination (FIORI_CLASSICUI_HTTPS) is not the standard or required enabling step.

C. By assigning the authorization to start transaction SEARCH_SAP_MENU.
This is incorrect. The transaction that renders the classic menu in the browser is /n/UI2/CL_GUI_FRONTEND_SERVICES (encapsulated in the target mapping), not SEARCH_SAP_MENU. Authorization is controlled via PFCG roles containing the assigned business catalog (from step B), not via a direct transaction code assignment.

Reference:
SAP Help documentation: "Configure the SAP Fiori Launchpad" and specifically "Integrate SAP GUI Transactions into the SAP Fiori Launchpad". The process is defined: activate the shipped content catalog /UI2/CLASSICAL_GUI_MENU via the Fiori launchpad designer or configuration transactions (/UI2/FLP_CUS_CONF).

How can you register multiple SAP Gateway services simultaneously? Note: There are 2 correct answers to this question

A. Using task list SAP_GATEWAY_ BASIC_CONFIG

B. Using transaction /IWFND/GW_CLIENT.

C. Using transaction/IWFND/MAINT SERVICE

D. Using task list SAP_GATEWAY_ACTIVATE_ODATA_SERV

C.   Using transaction/IWFND/MAINT SERVICE
D.   Using task list SAP_GATEWAY_ACTIVATE_ODATA_SERV

Explanation:

In an AS ABAP-based SAP system, multiple SAP Gateway services can be registered simultaneously using either the transaction /IWFND/MAINT_SERVICE or the task list SAP_GATEWAY_ACTIVATE_ODATA_SERV.

Transaction /IWFND/MAINT_SERVICE:
This transaction is the central point for managing OData services in the SAP Gateway. Administrators can add multiple services at once by selecting them from the backend system and registering them in the Gateway hub. It allows batch registration, activation, and maintenance of services, making it the most direct way to register several services simultaneously.

Task List SAP_GATEWAY_ACTIVATE_ODATA_SERV:
This guided configuration task list simplifies the activation of multiple OData services. It is especially useful in scenarios where a large number of services need to be activated together, such as after installing new SAP Fiori apps. The task list automates the process, reducing manual effort and ensuring consistency across the system.

❌ Why Other Options Are Not Correct

A. Using task list SAP_GATEWAY_BASIC_CONFIG:
This task list is used for the initial basic configuration of the SAP Gateway system (e.g., RFC destinations, system aliases). It does not handle the registration of multiple OData services.

B. Using transaction /IWFND/GW_CLIENT:
This transaction is a testing tool for OData services. It allows developers and administrators to test service calls and payloads but does not provide functionality to register or activate services.

📚 References
SAP Help Portal – SAP Gateway Service Activation (help.sap.com in Bing)【source】
SAP Community Wiki – Registering OData Services in SAP Gateway (wiki.scn.sap.com in Bing)【source】

Page 2 out of 12 Pages
C_TADM_23 Practice Test