Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question
in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
A company has offices in Vancouver, Tokyo, and Paris. The company uses Microsoft SQL Server 2016
Standard edition. You must design a reporting solution that uses data from a point of sale (POS) application-s transactional database.
After data is entered into the POS system, users must be able to run reports within 24 hours. Latency must be minimized
.
You need to implemented a solution that minimizes licensing costs.
What should you implement?
A. a Microsoft Azure Stretch Database
B. log shipping
C. an Always On Availability Group with all replicas in synchronous-commit mode
D. a file share witness
E. a Microsoft SQL Server failover cluster instance (FCI)
F. a Windows cluster with a shared-nothing architecture
G. an Always On Availability Group with secondary replicas in asynchronous-commit mode
Stretch Database targets transactional
databases with large amounts of cold data, typically stored in a small number of tables. These tables may contain more than a billion rows.
Stretch Database provides the following benefits:
Provides cost-effective availability for cold data
Doesn-t requir
e changes to queries or applications
Streamlines on-premises data maintenance
Keeps your data secure even during migration
References:
https://docs.microsoft.com/en-us/sql/sql-server/stretch-database/stretch-database