DP-900 : Microsoft Azure Data Fundamentals Exam

DP-900 Dumps
DP-900 Braindumps DP-900 Real Questions DP-900 Practice Test
DP-900 Actual Questions
killexams.com
Microsoft
DP-900
Microsoft Azure Data Fundamentals
https://killexams.com/pass4sure/exam-detail/DP-900
Question: 45
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Answer:
Question: 46
What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
1. native support for cross-database queries and transactions
2. built-in high availability
3. system-Initiated automatic backups
4. support for encryption at rest
Answer: A Explanation:
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison
Question: 47
DRAG DROP
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics
type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
Answer:
Explanation:
Reference: https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive- cognitive-analytics/
Question: 48
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.
Answer:
Explanation:
Box 1: Image files
Azure Blob storage is suitable for image files. Box 2: Key/value pairs
Azure CosmosDB table API is a key-value storage hosted in the cloud. Box 3: Relationship between employees
One-to-many relationships between business domain objects occur frequently: for example, one department has many employees. There are several ways to implement one-to-many relationships in the Azure Table service.
Reference: https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-design-modeling
Question: 49
What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
1. complete control over backup and restore processes
2. access to the latest features
3. in-database machine learning services
4. reduced administrative effort for managing the server infrastructure
Answer: B, C Explanation:
Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.
SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time- to-market, rather than on managing virtual machines and infrastructure.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
Question: 50
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.
Answer:
Question: 51
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Generally speaking, data analytics comes in four types:
Descriptive, to answer the question: What’s happening? Diagnostic, to answer the question: Why’s happening? Predictive, to answer the question: What will happen?
Prescriptive, to answer the question: What actions should we take?
Reference: https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will- happen-with-iot-analytics/
Question: 52
What should you use to build a Microsoft Power BI paginated report?
1. Power BI report Builder
2. Power BI Desktop
3. Charticulator
4. the Power BI service
Answer: A Explanation:
Power BI Report Builder is the standalone tool for authoring paginated reports for the Power BI service. https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-quickstart-aw Question: 53
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference: https://www.bmc.com/blogs/what-is-batch-processing-batch-processing-explained/
Question: 54
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?
1. Azure DNS
2. Azure Application Gateway
3. Azure Private link
4. Azure Traffic Manager
Answer: C Explanation:
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
Reference: https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-private-link-private- endpoint-connectivity/ba-p/1235573
Question: 55
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 recommend?
1. document
2. key/value
3. object
4. columnar
Answer: C Explanation:
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.
Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
Question: 56
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?
1. a table
2. an index
3. scalar function
4. a view
Answer: D Explanation:
A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/views/views

User: Helena***** I can not thank killexams.com enough for helping me score high in my DP-900 exam last month. As we all know, DP-900 certification is very challenging, but with the material provided by Killexams, I found it easy to understand. I highly recommend this site to all students looking for quality instructional material to prepare for their DP-900 exam. Keep up the excellent work, Killexams!

User: Malak***** To my surprise, I passed the DP-900 exam today with a perfect score of 100%, thanks to Killexams.com. I was initially impressed with the practice materials provided, which covered all the necessary topics and included many questions. However, I did not expect to see the exact same questions in the actual exam. It was a pleasant surprise, and I highly recommend using Killexams.com for exam preparation.

User: Gabriel***** Passing the dp-900 exam proved to be a challenging task for me. However, killexams.com aided me in gaining composure and using their dp-900 practice tests to prepare myself for the exam. Their dp-900 exam simulator was particularly helpful, and thanks to it, I passed the dp-900 exam and even got promoted in my company. I am grateful to the team for their useful questions and answers that helped me complete the exam on the first try.

User: Lee***** I am extremely grateful to Killexams for providing me with such beneficial practice tests for my dp-900 exam. The content was data-rich and exactly what I needed for my coaching. It boosted my confidence and gave me the self-assurance I needed to excel in my exam. The practice tests were so close to the real exam questions that I was able to complete the exam in just 95 minutes, despite being a non-native English speaker. I am thankful for the great practice test that you provided me with.

User: William***** In my preparation for the exam, I ensured to cover a wide variety of topics, and my efforts paid off as I achieved a great result of 89%. Although I found the exam questions to be quite challenging, I found support in the killexams.com practice tests, which provided clear and concise explanations of the fast-paced answers.

---