Question 1

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

Options :

A : sqlcmd

B : bcp

C : azdata

D : Azure CLI

Answer: A

Question 2

You have data saved in the following format:

Which format was used?

Options :

A : YAML

B : HTML

C : XML

D : JSON

Answer: B

Question 3

What can be used with native notebook support to query and visualize data by using a web-based interface?

Options :

A : Azure Databricks

B : pgAdmin

C : Microsoft Power Bl

Answer: A

Question 4

You have an application that runs on Windows and requires access to a mapped drive. Which Azure service should you use?

Options :

A : Azure Files

B : Azure Blob storage

C : Azure Cosmos DB

D : Azure Table storage

Answer: A

Question 5

Which statement is an example of Data Definition Language (DDL)?

Options :

A : SELECT

B : INSERT

C : DELETE

D : DROP

Answer: D

Free DP-900 Mock Exam – Practice Online Confidently