Implementing a SQL Data Warehouse — Question 59

You have Microsoft Azure SQL Database instances named DB1 and DB2.
The databases are hosted in different regions and contain different tables.
You must allow Transact-SQL queries in DB1 to access data in DB2.
You need to configure DB1 to ensure that you can run queries that join tables from DB1 and DB2.
What should you do?

Answer options

• A. Use the CREATE EXTERNAL DATA SOURCE statement to form an external data source for DB1. The LOCATION statement must reference the URL for DB2.
• B. Configure a linked server connection on DB1 to access DB2 remotely. Configure the linked server RPC Out option to TRUE.
• C. Create an elastic database pool. Place DB1 and DB2 into the elastic database pool.
• D. Create a global shard map on DB1 for horizontal partitioning. Add DB1 and DB2 to the shard map.

Correct answer: B

Explanation

The correct answer is B because configuring a linked server allows DB1 to access DB2 remotely, enabling the execution of queries that join tables across both databases. Options A, C, and D do not provide the necessary means for DB1 to directly query DB2, as they either establish an external data source or focus on resource pooling, which is not suitable for cross-database querying.