Microsoft DP-900 Dumps V17.02 [2023] Free DP-900 Dumps Questions For Testing

1. HOTSPOT

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

2. Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents acomplete solution. NOTE: Each correct selection is worth one point.(Choose three.)

3. You have data saved in the following format:

Which format was used?

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

5. CORRECT TEXT

Select the answer that correctly completes the sentence.

6. HOTSPOT

Select the answer that correctly completes the sentence.

7. HOTSPOT

Select the answer that correctly completes the sentence.

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

9. You need to store event log data that is semi-structured and received as the logs occur.

What should you use?

10. What are two characteristics of real-time data processing? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point.

11. 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.

12. 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.

13. HOTSPOT

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

14. HOTSPOT

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

15. You need to design and model a database by using a graphical tool that supports project-oriented offlinedatabase development.

What should you use?

16. HOTSPOT

Select the answer that correctly completes the sentence.

17. What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point. (Choose three.)

18. Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point. (Choose two.)

19. HOTSPOT

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

20. HOTSPOT

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

21. 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.

22. Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network.

Which type of data store should you use?

23. 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.

24. You have an application that runs on Windows and requires access to a mapped drive.

Which Azure service should you use?

25. 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.

26. 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.

27. HOTSPOT

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

28. Your company is designing a database that will contain session data for a website. The data will includenotifications, 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?

29. 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.

30. You have an Azure Cosmos DB account that uses the Core (SQL) API.

Which two settings can you configure at the container level? Each correct answer presents a completesolution.NOTE: Each correct selection is worth one point. (Choose two.)

31. HOTSPOT

Select the answer that correctly completes the sentence.

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

What should you create first?

33. You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. (Choose three.)

34. HOTSPOT

Select the answer that correctly completes the sentence.

35. CORRECT TEXT

Select the answer that correctly completes the sentence.

36. You have an application that runs on Windows and requires across to a mapped drive.

Which Azure service should you use?

37. DRAG DROP

Match the terms to the appropriate descriptions.

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

38. 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.

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

40. Which three actions are used when performing diagnostic analytics?

41. When can you use an Azure Resource Manager template?

42. HOTSPOT

Select the answer that correctly completes the sentence.

43. HOTSPOT

Select the answer that correctly completes the sentence.

44. You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to persist the SQL query so that other users can use the query.

What should you create?

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

46. CORRECT TEXT

Select the answer that correctly completes the sentence.

47. 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.

48. HOTSPOT

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

49. What is the primary purpose of a data warehouse?

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

51. HOTSPOT

Select the answer that correctly completes the sentence.

52. 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.

53. DRAG DROP

Match the terms to the appropriate descriptions.

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

54. HOTSPOT

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

55. HOTSPOT

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

56. HOTSPOT

Select the answer that correctly completes the sentence.

57. You need to create an Azure resource to store data in Azure Table storage.

Which command should you run?

58. Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

59. In Azure Table storage, each row in a table must be uniquely identified by which two components?

Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point.

60. You need to store data in Azure Blob storage for seven years to meet your company's compliancerequirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.

Which storage tier should you use?

61. CORRECT TEXT

Select the answer that correctly completes the sentence.

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

63. CORRECT TEXT

Select the answer that correctly completes the sentence.

64. HOTSPOT

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

65. You manage an application that stores data in a shared folder on a Windows server.

You need to move the shared folder to Azure Storage.

Which type of Azure Storage should you use?

66. Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?

67. You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down.

What should you use in Microsoft Power BI?

68. HOTSPOT

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

69. 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.

70. CORRECT TEXT

Select the answer that correctly completes the sentence.

71. Which scenario is an example of a streaming workload?

72. CORRECT TEXT

Select the answer that correctly completes the sentence.

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

74. What should you use to build a Microsoft Power BI paginated report?

75. HOTSPOT

Select the answer that correctly completes the sentence.

76. CORRECT TEXT

Select the answer that correctly completes the sentence.

77. DRAG DROP

Match the Azure services to the appropriate requirements.

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

78. HOTSPOT

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

79. You need to create a visualization of running sales totals per quarter as shown in the following exhibit.

What should you create in Power BI Desktop?

80. You need to create an Azure Storage account.

Data in the account must replica outside the Azure region automatically.

Which two types of replica can you us for the storage account? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one pint.

81. 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.

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

83. HOTSPOT

Select the answer that correctly completes the sentence.

84. You need to recommend a data store service that meets the following requirements:

✑ Native SQL API access

✑ Configurable indexes

What should you recommend?

85. CORRECT TEXT

Select the answer that correctly completes the sentence.

86. HOTSPOT

Select the answer that correctly completes the sentence.

87. Your company recently reported sales from the third quarter.

You have the chart shown in the following exhibit.

Which type of analysis is shown for the fourth quarter?

88. 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.

89. DRAG DROP

match the Azure data factory components to the appropriate descriptions.

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

90. Which Azure Data Factory component initiates the execution of a pipeline?

91. 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.

92. You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL

database.

Which type of authentication should you use?

93. HOTSPOT

Select the answer that correctly completes the sentence.

94. Which clause should you use in a select statement to combine rows in one table with rows in another table?

95. 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.

96. When you create an Azure SQL database, which account can always connect to the database?

97. HOTSPOT

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

98. DRAG DROP

Match the types of data to the appropriate Azure data services.

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