Which four statements should you use in sequence?

DRAG DROP
You have four Microsoft Azure SQL databases.
You need to configure cross-database queries.
Which four statements should you use in sequence? To answer, move the appropriate statements from the list
of statements to the answer area and arrange them in the correct order.
Select and Place:

DRAG DROP
You have four Microsoft Azure SQL databases.
You need to configure cross-database queries.
Which four statements should you use in sequence? To answer, move the appropriate statements from the list
of statements to the answer area and arrange them in the correct order.
Select and Place:

Answer:

Explanation:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-elastic-query-overview/



Leave a Reply 3

Your email address will not be published. Required fields are marked *


spguru

spguru

Does not seem to be right, why CREATE SHARD MAP was ignored?

jml

jml

I think it is horizontal, but the question is to use four statements, and creating a shard map is rather “prereq” than configuration step.

From: https://docs.microsoft.com/en-gb/azure/sql-database/sql-database-elastic-query-getting-started-vertical

Prerequisites
Create a shard map using the elastic database client library. see Shard map management. Or use the sample app in Get started with elastic database tools.
Alternatively, see Migrate existing databases to scaled-out databases.
The user must possess ALTER ANY EXTERNAL DATA SOURCE permission. This permission is included with the ALTER DATABASE permission.
ALTER ANY EXTERNAL DATA SOURCE permissions are needed to refer to the underlying data source.

Overview
These statements create the metadata representation of your sharded data tier in the elastic query database.

CREATE MASTER KEY
CREATE DATABASE SCOPED CREDENTIAL
CREATE EXTERNAL DATA SOURCE
CREATE EXTERNAL TABLE