You want to prevent changes to system properties in tenant databases. Which configuration file stores the blocklisted properties?
Correct Answer: A
Question 2
Which user is assigned by default when you provision a data lake in SAP HANA Cloud?
Correct Answer: D
In the context of provisioning a data lake in SAP HANA Cloud, the default user assigned isHDLADMIN. This user is specifically designed to manage and operate within the data lake environment, providing administrative privileges necessary for managing the data lake's database objects and configurations. References=The role and capabilities of the HDLADMIN user are typically outlined in SAP HANA Cloud data lake documentation and provisioning guides, which specify default users and their roles within different SAP HANA Cloud scenarios. Database Administration
Question 3
Which tools are available in SAP HANA Cloud Central? Note: There are 2 correct answers to this question.
Correct Answer: C,D
Question 4
Which storage tier is used to manage rarely changing, persistent data?
Correct Answer: C
The storage tier used to manage rarely changing, persistent data within SAP HANA is the Native Storage Extension (NSE). NSE is designed to: * Native storage extension (C): Extend the in-memory capabilities of SAP HANA to include disk-based storage, effectively managing larger data volumes that do not fit into memory or do not require the high performance of in-memory processing. NSE allows for cost-effective data management and storage optimization by placing less frequently accessed, non-volatile data on lower-cost, slower disk storage while maintaining seamless access and integration with the in-memory data. This capability supports scenarios where data is infrequently accessed but still needs to be readily available within the SAP HANA environment, without the need for external storage solutions like data lakes (B) or specialized hardware such as WORM devices (D). References= SAP HANA documentation on data tiering options provides insights into how NSE works as an integral part of the data management strategy, focusing on cost-efficiency and resource optimization. User Management
Question 5
Which object types are stored in an SAP HANA catalog? Note: There are 3 correct answers to this question.
Correct Answer: A,C,E
The SAP HANA catalog stores various object types including:A. Cubes, which are multidimensional data structures optimized for query operations in analytical scenarios.C. Agents, which are components or processes that interact with the database for specific tasks like data integration, monitoring, or administration.E. JSON collections, which represent structured data storage formatted as JSON, utilized within database applications for handling semi-structured data.HDI containers and Cockpit roles are managed differently within the SAP HANA environment, with HDI containers being part of the deployment infrastructure and Cockpit roles associated with administrative interfaces rather than the catalog.References= SAP HANA SQL and System Views Reference, which details the types of objects maintained within the SAP HANA catalog and their roles within the database system. SAP HANA Architecture
