Knowledge quiz

It's time to put what you've learned to the test, get 8 right to pass this week.

Which of the following file formats is supported by SQL on Files?

Choose the correct answer.

ANSI

SQL

PARQUET

STRUCTURED

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

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

Memory

Printer

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

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)

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

Which of the following are examples of types of SAP HANA authorization privilege?

There are three correct answers.

System

Object

Analytic

Memory

Predictive

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.

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

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