Which command-line tool can you use to query Azure SQL databases?

1. A. sqlcmd
2. B. bcp
3. C. azdata
4. D. Azure CLI

Correct Answer: A

Select the answer that correctly completes the sentence.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

You need to recommend a data store service that meets the following requirements:
Native SQL API access
Configurable indexes What should you recommend?

1. A. Azure Files
2. B. Azure Blob storage
3. C. Azure Table storage
4. D. Azure Cosmos DB

Correct Answer: D
Azure Cosmos DB comes with native Core (SQL) API support.
In Azure Cosmos DB, data is indexed following indexing policies that are defined for each container. The default indexing policy for newly created containers enforces range indexes for any string or number. This policy can be overridden with your own custom indexing policy.

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

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

Select the answer that correctly completes the sentence.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A