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…

Question

Options

• ASQL Server on Azure Virtual Machines
• BAzure SQL Edge
• CAzure SQL Database
• DAzure SQL Managed Instance

• A
  6% (2)
• B
  13% (4)
• C
  78% (25)
• D
  3% (1)

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

No community discussion yet for this question.