Which language is used to define queries in Azure Synapse Data Explorer?

Select the answer that correctly completes the sentence.

Your company is designing a data store that will contain student data. The data has the following format.

Which type of data store should you use?

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

You have an Azure SQL database that contains tables for customers and orders. You need to create a query that will return the orders placed by each customer.

Which two Transact-SQL statements should you include in the query? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You have structured data in tabular format.

What represents an individual instance of a data entity?

Match the terms to the appropriate descriptions.

To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Match the tools to the appropriate descriptions.

To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.