The Most Update Microsoft Azure Data Fundamentals DP-900 Dumps

test2022-08-02T06:57:12+00:00

It is best to challenge and develop your knowledge in order to pass the DP-900 Microsoft Azure Data Fundamentals exam. We have updated the latest Microsoft Azure Data Fundamentals DP-900 Dumps so that you can prepare and pass the Microsoft DP-900 exam on your first try. Candidates for the DP-900 exam benefit from using the FreeTestShare Microsoft Azure Data Fundamentals DP-900 Dumps, which allow them to study more efficiently and in less time. Try DP–900 dumps and check your result with verified answers to see if you are ready for the real exam questions.

Here we’ve prepared some real DP-900 exam questions. Have a try!

Page 1 of 5

1. You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica?

You need to generate reports without affecting the transactional workload.

You need to audit the transactional application.

You need to implement high availability in the event of a regional outage

You need to improve the recovery point objective (RPO).

2. HOTSPOT

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

3. HOTSPOT

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

4. HOTSPOT

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

5. Select the answer that correctly completes the sentence.

6. Which storage solution supports role-based access control (RBAC) at the file and folder level?

Azure Disk Storage

Azure Data Lake Storage

Azure Blob storage

Azure Queue storage

7. HOTSPOT

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

8. DRAG DROP

Match the security components to the appropriate scenarios.

To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

9. HOTSPOT

You plan to deploy a PostgreSQL database to Azure.

Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

10. When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

multi-master replication

Availability Zones

automatic failover

the strong consistency level

Page 2 of 5

11. HOTSPOT

To complement the sentence, select the appropriate option in the answer area.

12. Select the answer that correctly completes the sentence.

13. 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?

Microsoft SQL Server Management Studio (SSMS)

Azure Data Studio

Azure CLI

Azure PowerShell

14. You need to store data by using Azure Table storage.

What should you create first?

an Azure Cosmos DB instance

a storage account

a blob container

a table

15. HOTSPOT

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

16. HOTSPOT

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

17. Which setting can only be configured during the creation of an Azure Cosmos DB account?

geo-redundancy

multi-region writes

production or non-reduction account type

API

18. HOTSPOT

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

19. DRAG DROP

Match the types of workloads to the appropriate scenarios.

To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

20. HOTSPOT

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

Page 3 of 5

21. Select the answer that correctly completes the sentence.

22. HOTSPOT

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

23. HOTSPOT

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

24. Select the answer that correctly completes the sentence.

25. Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

Azure SQL Database Hyperscale

Azure SQL managed instance

Azure SQL Database serveless

Azure SQL Database elastic pod

26. DRAG DROP

Match the tools to the appropriate descriptions.

To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

27. HOTSPOT

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

28. HOTSPOT

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

29. Your company needs to implement a relational database in Azure. The solution must minimize ongoing

maintenance.

Which Azure service should you use?

Azure HDInsight

Azure SQL Database

Azure Cosmos DB

SQL Server on Azure virtual machines

30. HOTSPOT

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

Page 4 of 5

31. HOTSPOT

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

32. 1.HOTSPOT

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

33. HOTSPOT

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

34. HOTSPOT

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

35. You need to modify a view in a relational database by adding a new column.

Which statement should you use?

MERGE

ALTER

INSERT

UPDATE

36. DRAG DROP

Match the types of data stores to the appropriate scenarios.

To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

37. You need to gather real-time telemetry data from a mobile application.

Which type of workload describes this scenario?

Online Transaction Processing (OLTP)

batch

massively parallel processing (MPP)

streaming

38. DRAG DROP

Match the Azure services to the appropriate locations in the architecture.

To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

39. You have data saved in the following format.

Which format was used?

XML

yaml

JSON

HTML

40. Which type of database is Azure Database for PostgreSQL?

Platform as a service (PaaS)

Infrastructure as a service (laaS)

Microsoft SQL Server

on-premises

Page 5 of 5

41. HOTSPOT

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

42. HOTSPOT

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

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

sqlcmd

bcp

azdata

Azure CLI

44. Select the answer the correctly completes the sentence.

45. DRAG DROP

You have a table named Sales that contains the following data.

You need to query the table to return the average sales amount day.

The output must produce the following results.

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

46. DRAG DROP

Match the types of visualizations to the appropriate descriptions.

To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

47. You have an Azure SQL database that you access directly from the internet.

You recently changed your external IP address.

After changing the IP address, you can no longer access the database. You can connect to other resources in Azure

What is a possible cause of the issue?

a database-level firewall

role-based access control (RSAC)

Dynamic Host Configuration Protocol (DHCP)

Domain Name Service (DNS)

48. HOTSPOT

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

49. A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.

The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense.

What should the developers use ?

Azure Data Studio

sq1cmd

Microsoft SQL Server Management Studio (SSMS)

Azure Data Explorer

50. Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?

control flow

linked services

datasets

the integration runtime