AZ-305 · Question #395
AZ-305 Question #395: Real Exam Question with Answer & Explanation
The correct answer is C: Azure SQL Database. The elastic query feature (in preview) enables you to run a Transact-SQL (T-SQL) query that spans multiple databases in Azure SQL Database. It allows you to perform cross-database queries to access remote tables, and to connect Microsoft and third-party tools (Excel, Power BI, Ta
Question
You have an Azure subscription. You plan to deploy an app that will store data across multiple databases. You need to recommend a storage solution for the app. The solution must meet the following requirements: - Ensure that queries can be executed simultaneously across all the databases. - Minimize development effort. - Minimize query latency. What should you include in the recommendation?
Options
- ASQL Server on Azure Virtual Machines
- BAzure SQL Edge
- CAzure SQL Database
- DAzure SQL Managed Instance
Explanation
The elastic query feature (in preview) enables you to run a Transact-SQL (T-SQL) query that spans multiple databases in Azure SQL Database. It allows you to perform cross-database queries to access remote tables, and to connect Microsoft and third-party tools (Excel, Power BI, Tableau, etc.) to query across data tiers with multiple databases. Using this feature, you can scale out queries to large data tiers and visualize the results in business intelligence (BI) reports. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-overview
Community Discussion
No community discussion yet for this question.