Page: 1
/ 14
Total 316 questions
Microsoft Azure Data Fundamentals DP-900 Exam Questions
Question 1
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, 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 2
Which Azure Data Factory component provides the compute environment for activities?
Answer : B, B
The Integration Runtime (IR) is the compute infrastructure used by Azure Data Factory to provide the following data integration capabilities across different network environments:
Data Flow
Data movement
Activity dispatch
SSIS package execution
https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime
Question 3
Which scenario is an example of a streaming workload?
Answer : C, C
Question 4
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 ?
Answer : A, A
Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux.
Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal.
https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio
Question 5
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?
Answer : A, A
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/
https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/
Question 6
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?
Answer : A, A
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/
https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/
Question 7
You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you rec ommend?
Answer : C, C
Object storage is optimized for storing and retrieving large binary objects (images, files, video and audio streams, large application data objects and documents, virtual machine disk images). Large data files are also popularly used in this model, for example, delimiter file (CSV), parquet, and ORC. Object stores can manage extremely large amounts of unstructured data.
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
All Official Question Types