Home » Microsoft » 70-765 » What should you do?
A company has an on-premises Microsoft SQL Server 2017 infrastructure. The storage area network (SAN) that supports the SQL infrastructure has reached maximum capacity.
You need to recommend a solution to reduce on-premises storage use without changing the application.
What should you do?
A. Configure an Express Route connection to Microsoft Azure.
B. Configure a Microsoft Azure Key Vault.
C. Configure geo-replication on the SAN.
D. Configure SQL Server Stretch Database in Microsoft Azure.
Correct Answer: D
Explanation/Reference:
Explanation:
Stretch warm and cold transactional data dynamically from SQL Server to Microsoft Azure with SQL Server Stretch Database. Unlike typical cold data storage, your data is always online and available to query. Benefit from the low cost of Azure rather than scaling expensive, on-premises storage.
References: https://docs.microsoft.com/en-us/sql/sql-server/stretch-database/stretch-database?view=sql-server-2017