Exam 70-767 topic 2 question 8 discussion

Actual exam question from Microsoft's 70-767

Question #: 8
Topic #: 2

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?

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.

Show Suggested Answer

Suggested Answer: B 🗳️
References:
https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-ver15

by m83x at Aug. 29, 2020, 9:34 p.m.

Comments

Submit Cancel

MatthijsJanssen

4 years, 5 months ago

It is could be B... On a Managed Instance of Azure SQL database you can actually create linked-server connections: https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-ver15 As the question states "Microsoft Azure SQL Database Instance"...

upvoted 2 times

...

foqa

4 years, 6 months ago

A "Azure SQL Database does not support Linked Server" (from https://social.technet.microsoft.com/wiki/contents/articles/37170.azure-sql-database-using-external-data-sources.aspx)

upvoted 1 times

...

kimalto452

4 years, 7 months ago

its B https://www.sqlshack.com/querying-remote-data-sources-in-sql-server/

upvoted 2 times

...

DudeHere

4 years, 7 months ago

100% A: CREATE EXTERNAL DATA SOURCE <data_source_name> WITH ( [ LOCATION = '<prefix>://<path>[:<port>]' ] [ [ , ] CONNECTION_OPTIONS = '<name_value_pairs>'] [ [ , ] CREDENTIAL = <credential_name> ] [ [ , ] PUSHDOWN = { ON | OFF } ] [ [ , ] TYPE = { HADOOP | BLOB_STORAGE } ] [ [ , ] RESOURCE_MANAGER_LOCATION = '<resource_manager>[:<port>]' ) [ ; ] https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=sql-server-ver15&tabs=dedicated

upvoted 2 times

...

m83x

4 years, 10 months ago

I think the answer here is A. Can someone confirm?

upvoted 2 times

Cococo

4 years, 9 months ago

ask Microsoft and you'll find the answer: "...Creates an external data source for PolyBase queries. External data sources are used to establish connectivity and support these primary use cases: Data virtualization and data load using PolyBase Bulk load operations using BULK INSERT or OPENROWSET..." https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=sql-server-ver15

upvoted 2 times

...