Question 241 · 291 in bank
You have a data store that has the structure shown in the following exhibit.
Which type of data store is this?
Show answer
Answer: C
DP-900FoundationalMicrosoftAll questions freePage 25 of 30
DP-900 practice questions 241–250
Microsoft Azure Data Fundamentals291 questions across 30 pages are complete and free, with no account or card.
Official study references
291 questions in this bank
Free access · progress saved on this device
Question 242 · 291 in bank
Which type of database contains nodes and edges?
Show answer
Answer: A
Explanation
A graph database shows two types of information, nodes and edges. The edges specify the relationships between nodes. Both nodes and edges own properties that provide details about that node or edge. This is similar to columns in a table. The edges can also have a direction to indicate the relationship's nature.
Source: Adapted from community discussion — JA2018
Question 243 · 291 in bank
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. Select and Place:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
Box 1: Diagnostic - Diagnostic Analytics: At this stage you can begin to answer some of those why questions. Historical data can begin to be measured against other data to answer the question of why something happened in the past. This is the process of gathering and interpreting different data sets to identify anomalies, detect patters, and determine relationships. Box 2: Prescriptive - Prescriptive analytics is a combination of data, mathematical models, and various business rules to infer actions to influence future desired outcomes. Predictive analytics, broadly speaking, is a category of business intelligence that uses descriptive and predictive variables from the past to analyze and identify the likelihood of an unknown future outcome Box 3: Descriptive - ✑ 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://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/
Source: Adapted from community discussion — gs23mi
References
Question 244 · 291 in bank
HOTSPOT - Select the answer that correctly completes the sentence. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
A data analyst's primary skill set revolves around data acquisition, handling, and processing. Incorrect: * A data engineer requires an intermediate level understanding of programming to build thorough algorithms along with a mastery of statistics and math. * A data scientist needs to be a master of both worlds. Data, stats, and math along with in-depth programming knowledge for Machine Learning and Deep Learning. Reference: https://www.edureka.co/blog/data-analyst-vs-data-engineer-vs-data-scientist/
Source: Adapted from community discussion — Massimo70
References
Question 245 · 291 in bank
You have an inventory management database that contains the following table.
Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
Show answer
Answer: C
Explanation
Update is the SIMPLEST way, but a MERGE can also do the update... I think the question should be a little bit more specific.
Source: Adapted from community discussion — vince60370
Question 246 · 291 in bank
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?
Show answer
Answer: B
Explanation
SQL Database - https://azure.microsoft.com/en-us/products/azure-sql/database/#features Fully managed SQL database automates updates, provisioning, and backups so you can focus on application development
Source: Adapted from community discussion — yeanlingmedal71
Question 247 · 291 in bank
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?
Show answer
Answer: B
Explanation
B. Azure Data Studio is a cross-platform database tool that allows you to embed documents and query results into a SQL notebook. It supports Azure SQL databases, SQL Server, and other databases. It also has built-in support for SQL Notebooks, which allows you to mix markdown, code, and results in a single notebook. This makes it a great tool for creating documentation and troubleshooting guides for administrators to use when working with Azure SQL databases.
Source: Adapted from community discussion — Pinha
Question 248 · 291 in bank
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. Select and Place:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
Reference: https://en.wikipedia.org/wiki/Table_(database) https://en.wikipedia.org/wiki/View_(SQL) https://en.wikipedia.org/wiki/Database_index
Source: Adapted from community discussion — gabo
Question 249 · 291 in bank
You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?
Show answer
Answer: D
Explanation
Yes, read and write is a keyword, as OLTP does transactional processing: these consists of read and writes. Streaming is ingesting the data as it is being created, usually to be processed for analytics.
Source: Adapted from community discussion — BabyBee
Question 250 · 291 in bank
When can you use an Azure Resource Manager template?
Show answer
Answer: A
Explanation
This one is correct as well. ARM allows you to automate the creation of resources by specifying in a JSON document the resources you want to generate. The process can be replicated (if needed) to deploy resources to a different region.
Source: Adapted from community discussion — AlfuryDB
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
DP-900 practice, question 241. 291 questions available.
About this question bank
Version 1.0.0. How we source questions