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
