Additional Technologies

Question 1

Within the context of Multitenant Database Containers, each database is self-contained and fully isolated with it’s own

Answer 1

Set of database users, backups, and trace & logs

Question 2

In a multitenant environment the systemDB does not have its own

Answer 2

Index Server

Question 3

You are processing a customer incident for an MDC system and need to log onto the system DB to check some configurations. Which service acts as the SQL port to allow the connection to the system DB

Answer 3

Nameserver

Question 4

One of the benefits of MDC is a strong separation of users and data between the tenants. However, to support cross-application reporting, cross-database queries are possible. What does a user, U2 in a tenant DB, DB2 need to be done to access objects in another tenant DB Db1

Answer 4

A user, U1 needs to be created in DB1 with user, U2 in Db2 as a remote identity

Question 5

in the context of data management strategy what does data tiering refer to

Answer 5

Assigning data to various storage areas and storage media often by their temperature classification

Question 6

A customer has a scale out BQ system with a huge data memory footprint. However they only have a small budget for a additional HQ resources. They briefly read about extension nodes and wanted to know if this option could benefit them. What do you advise

Answer 6

Yes, due to the relaxed static and dynamic memory ratio that allows for fewer nodes and less overall RAM