/
Browse
/
Courses
/
Ride the SAP HANA Wave: Fundamentals and Insights into Cloud Databases
/
Assignment Week 3
Introduction to SAP HANA
Introduction
The case for an in-memory database
Getting to know SAP HANA
Deployment options for SAP HANA
The cloud imperative
How to get started with SAP HANA free tier
Wrap-up
Downloads
Quiz
Data Integration and Modeling
Introduction
Overview of integration
Data virtualization (SDA)
Data acquisition (SDI)
Overview of modeling
Modeling concepts
Model deployment
Wrap-up
Downloads
Quiz
Architecture and Admin
Introduction
Table partitions and data tiering
Data lake and SQL on files
Database administration tools
Data center readiness
Security basics
Wrap-up
Downloads
Quiz
Advanced Topics (Optional Course Week)
Bonus week 4
Introduction
Data privacy
Multi-model
Machine learning
HDI application development in XSA and BTP
Wrap-up
Downloads
Introduction to SAP HANA
Introduction
The case for an in-memory database
Getting to know SAP HANA
Deployment options for SAP HANA
The cloud imperative
How to get started with SAP HANA free tier
Wrap-up
Downloads
Quiz
Data Integration and Modeling
Introduction
Overview of integration
Data virtualization (SDA)
Data acquisition (SDI)
Overview of modeling
Modeling concepts
Model deployment
Wrap-up
Downloads
Quiz
Architecture and Admin
Introduction
Table partitions and data tiering
Data lake and SQL on files
Database administration tools
Data center readiness
Security basics
Wrap-up
Downloads
Quiz
Advanced Topics (Optional Course Week)
Bonus week 4
Introduction
Data privacy
Multi-model
Machine learning
HDI application development in XSA and BTP
Wrap-up
Downloads
Knowledge quiz
It's time to put what you've learned to the test, get 8 right to pass this week.
1.
Which of the following statements about SAP HANA persistence and savepoints are true?
There are three correct answers.
Savepoints are executed every 5 minutes by default.
Both data and undo log information is automatically saved to disk at regular savepoints.
Logs are saved asynchronously after each COMMIT.
During database recovery, the system is returned to its last consistent state by replaying the redo log since the last savepoint.
SAP HANA holds the bulk of its data in disk for maximum performance.
2.
Which of the following are use cases supported by SAP HANA Cloud, data lake?
There are two correct answers.
Elastic extensibility
SQL on Files
Standalone data lake IQ
Market data
Store and explore data
3.
Which of the following file formats is supported by SQL on Files?
Choose the correct answer.
ANSI
SQL
PARQUET
STRUCTURED
4.
Which of the following are part of the overall SAP HANA used memory?
There are three correct answers.
Column store tables
Row store tables
OS / Other programs
Working memory
Free space memory
5.
Which of the following are examples of types of SAP HANA authorization privilege?
There are three correct answers.
System
Object
Analytic
Memory
Predictive
6.
Which administration tool provides database administrators with the ability to execute SQL statements?
Choose the correct answer.
SAP HANA Cloud Central
SAP HANA Cockpit
SAP HANA Database Explorer
SAP HANA DB Control Center
7.
Which of the following are typical benefits of table partitioning in SAP HANA?
There are three correct answers.
Data compression
Partition pruning
No need for a primary key
Parallelization
Load balancing
8.
The SAP HANA cockpit allows database administrators to monitor the utilization of which of the following types of resources?
There are three correct answers.
CPU
Disk
Email
Memory
Printer
9.
What are some of the benefits of the SAP HANA Data Anonymization feature?
There are two correct answers.
Fully integrated with SAP HANA authorization framework
Administrative reporting views on use of data anonymization features by end users
5 delivered methods of data anonymization
Periodic batch jobs that update anonymization views (not in real time)
10.
Which of the following are examples of single level partition methodology in SAP HANA Cloud?
There are three correct answers.
Hash
Range
Key
Round Robin
Dictionary