What should you recommend?

You need to optimize storage for CONT_SQL3.

What should you recommend?
A . AlwaysOn
B . Transactional processing
C . General
D . Data warehousing

View Answer

Answer: B

Explanation:

CONT_SQL3 with the SQL Server role, 100 GB database size, Hyper-VM to be migrated to Azure VM.

The storage should be configured to optimized storage for database OLTP workloads.

Azure SQL Database provides three basic in-memory based capabilities (built into the underlying database engine) that can contribute in a meaningful way to performance improvements:

In-Memory Online Transactional Processing (OLTP)

Clustered columnstore indexes intended primarily for Online Analytical Processing (OLAP) workloads

Nonclustered columnstore indexes geared towards Hybrid Transactional/Analytical Processing (HTAP) workloads

Reference: https://www.databasejournal.com/features/mssql/overview-of-in-memory-technologies-of-azure-sql­database.html