c_hanatec_17 Exam QuestionsBrowse all questions from this exam

c_hanatec_17 Exam - Question 6


What do you need in a multitenant database container (MDC) system to run queries across tenant databases? (Choose two.)

Show Answer
Correct Answer: AD

To run queries across tenant databases in a multitenant database container (MDC) system, you need to ensure that the user in the source system is associated with a user in the target database. This association, often known as a remote identity, is crucial because the associated user in the target database will execute the query and their authorization is checked. Additionally, cross-tenant database communication must be explicitly activated as it is not enabled by default and requires configuration.

Discussion

4 comments
Sign in to comment
schalke04Options: CD
Feb 17, 2023

C. The user in the source system must have sufficient privileges in the target database. D. The cross-tenant database communication must be explicitly activated. To run queries across tenant databases in a multitenant database container (MDC) system, the user in the source system must have sufficient privileges in the target database. The MDC system must allow cross-tenant database communication, which is typically explicitly activated through configuration settings or other means. It is not necessary for the user in the source system to be associated with a user in the target database or for the bidirectional communication channel to be whitelisted

Certhicc
Mar 2, 2023

Answer is A and D, the user in the source system must be associated with a user in the target database. The association is Unidirectional and only the SELECT privilege of the target database user are considered.

NiubileyeahOptions: AD
May 11, 2023

Answer is A and D. A user in one database can run a query that references objects in another database, if the user is associated with a sufficiently privileged user in the remote database. This associated user is called a remote identity. This is the user who executes the query (or part of the query) in the remote database, and therefore the user whose authorization is checked. Cross-database access is not enabled by default and must be configured before such user mappings can be set up.

LizzyOlivanOptions: AD
Aug 7, 2023

HA200 SAP HANA 2.0 SPS06 - Installation and Administration. Activation of Cross-Tenant Database Access To access a cross-tenant database, the following must be activated: ●Turn on cross-tenant database communication (run this from SYSTEM database only) ●A user in the target database can only be associated with one user in the source database.

lucho73Options: AD
Dec 6, 2023

In HA200 page 465 Answer is A and D