Microsoft DP-900 Microsoft Azure Data Fundamentals Exam Practice Test

Page: 1 / 14
Total 306 questions
Question 1

What should you use to automatically delete blobs from Azure Blob Storage?



Answer : D


Question 2

Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use?



Answer : C

Azure Private Link enables you to access Azure PaaS Services (for example, Azure Storage and SQL Database) and Azure hosted customer-owned/partner services over a private endpoint in your virtual network.

Traffic between your virtual network and the service travels the Microsoft backbone network. Exposing your service to the public internet is no longer necessary


https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-private-link-private-endpoint-connectivity/ba-p/1235573

Question 3

Which statement is an example of Data Manipulation Language (DML)?



Answer : A

Data Manipulation Language (DML) statements:

DELETE

INSERT

UPDATE


https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements

Question 4

Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.)

NOTE: Each correct selection is worth one point.



Answer : B, C


https://www.sqlshack.com/a-beginners-guide-to-azure-databricks/

Question 5

How is raw data stored in a data lakehoose?



Answer : B


Question 6

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



Answer : D

Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include:

ALTER

Collations

CREATE

DROP

DISABLE TRIGGER

ENABLE TRIGGER

RENAME

UPDATE STATISTICS

TRUNCATE TABLE


https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

Question 7

You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).

Which Azure service should you use to support the application?



Answer : D

Azure SQL Database is relational database and a managed service.


https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment

Page:    1 / 14   
Total 306 questions