DP-900 MCQs
DP-900 TestPrep DP-900 Study Guide
DP-900 Practice Test DP-900 Exam Questions
killexams.com
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.
Question: 46
What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
native support for cross-database queries and transactions
built-in high availability
system-Initiated automatic backups
support for encryption at rest
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.
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.
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.
complete control over backup and restore processes
access to the latest features
in-database machine learning services
reduced administrative effort for managing the server infrastructure
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.
Question: 51
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
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?
Power BI report Builder
Power BI Desktop
Charticulator
the Power BI service
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.
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?
Azure DNS
Azure Application Gateway
Azure Private link
Azure Traffic Manager
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?
document
key/value
object
columnar
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?
a table
an index
scalar function
a view
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
KILLEXAMS.COM
Killexams.com is a leading online platform specializing in high-quality certification exam preparation. Offering a robust suite of tools, including MCQs, practice tests, and advanced test engines, Killexams.com empowers candidates to excel in their certification exams. Discover the key features that make Killexams.com the go-to choice for exam success.
Killexams.com provides exam questions that are experienced in test centers. These questions are updated regularly to ensure they are up-to-date and relevant to the latest exam syllabus. By studying these questions, candidates can familiarize themselves with the content and format of the real exam.
Killexams.com offers exam MCQs in PDF format. These questions contain a comprehensive
collection of questions and answers that cover the exam topics. By using these MCQs, candidate can enhance their knowledge and improve their chances of success in the certification exam.
Killexams.com provides practice test through their desktop test engine and online test engine. These practice tests simulate the real exam environment and help candidates assess their readiness for the actual exam. The practice test cover a wide range of questions and enable candidates to identify their strengths and weaknesses.
Killexams.com offers a success guarantee with the exam MCQs. Killexams claim that by using this materials, candidates will pass their exams on the first attempt or they will get refund for the purchase price. This guarantee provides assurance and confidence to individuals preparing for certification exam.
Killexams.com regularly updates its question bank of MCQs to ensure that they are current and reflect the latest changes in the exam syllabus. This helps candidates stay up-to-date with the exam content and increases their chances of success.