Question 1

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 2

What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

Options :

A : native support for cross-database queries and transactions

B : built-in high availability

C : system-Initiated automatic backups

D : support for encryption at rest

Answer: A

Question 3

Your company is designing a database that will contain session data for a website. The data will include

notifications, personalization attributes, and products that are added to a shopping cart.

Which type of data store will provide the lowest latency to retrieve the data?

Options :

A : key/value

B : graph

C : columnar

D : document

Answer: C

Question 4

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

Options :

A : SELECT

B : INSERT

C : DELETE

D : DROP

Answer: D

Question 5

You have data saved in the following format:

Which format was used?

Options :

A : YAML

B : HTML

C : XML

D : JSON

Answer: B