You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.
You need to embed documents and query results into a SQL notebook.
What should you use?

• A.Microsoft SQL Server Management Studio (SSMS)
• B.Azure Data Studio
• C.Azure CLI
• D.Azure PowerShell

Comment: *

Name: *

Email: *

Verification: *

To complete the sentence, selectthe appropriate option in the answer area.

Correct Answer:

Explanation

Generally speaking, data analytics comes in four types (Figure 1):
Descriptive, to answer the question: What's happening?
Diagnostic, to answer the question: Why's happening?
Predictive, to answer the question: What will happen?
Prescriptive, to answer the question: What actions should we take?

Comment: *

Name: *

Email: *

Verification: *

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Box 1: Yes
Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record.
Box 2: No
An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the table or view.
Box 3: Yes
A view is a virtual table whose contents are defined by a query. Like a table, a view consists of a set of named columns and rows of data.

Comment: *

Name: *

Email: *

Verification: *

Select the answer that correctly completes the sentence.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *