Question 211 · 291 in bank
You have a database that stores data in the format shown in the following table.
Of which type of database is this an example?
Show answer
Answer: B
DP-900FoundationalMicrosoftAll questions freePage 22 of 30
DP-900 practice questions 211–220
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 212 · 291 in bank
You need to implement an Azure platform as a service (PaaS) service that will host a relational database. The solution must support built-in autoscaling. Which service should you implement?
Show answer
Answer: A
Explanation
A. Azure SQL Database the reason: Azure SQL Database is a relational database-as-a-service PaaS from Microsoft Azure, and it supports the autoscaling feature that allows system resources to be automatically scaled based on load.
Source: Adapted from community discussion — MAKI911
Question 213 · 291 in bank
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.
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
Question 214 · 291 in bank
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.
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
Answer is YNN 1. Azure SQL Managed support cross-DB queries three-part name queries 2. Elastic pools are used to manage and scale multiple databases with varying workloads on Azure SQL Database, not SQL Server on Azure Virtual Machines. 3. SQL DB Supported on both Physical & VMs (Not Azure SQL)
Source: Adapted from community discussion — Andrewwfw
References
Question 215 · 291 in bank
You have the following data.
Which type of data is this?
Show answer
Answer: B
Question 216 · 291 in bank
You need to create an Azure resource to store data in Azure Table storage. Which command should you run?
Show answer
Answer: B
Explanation
Ans is B for me. Due to no az storage table create in the selection. The best answer is B create storage account (first)
Source: Adapted from community discussion — PanP
Question 217 · 291 in bank
HOTSPOT - To complete the sentence, select the appropriate option in the answer area. 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
Azure Cosmos DB SQL API accounts provide support for querying items using the Structured Query Language (SQL) syntax. Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/choose-api
Source: Adapted from community discussion — Kanatius
Question 218 · 291 in bank
You need to modify a view in a relational database by adding a new column. Which statement should you use?
Show answer
Answer: B
Question 219 · 291 in bank
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. 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
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
Source: Adapted from community discussion — Kardec
Question 220 · 291 in bank
HOTSPOT - You plan to deploy a PostgreSQL database to Azure. Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. 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
Reference: https://azure.microsoft.com/en-us/overview/what-is-saas/ https://azure.microsoft.com/en-us/overview/what-is-paas/
Source: Adapted from community discussion — SameerL
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
DP-900 practice, question 211. 291 questions available.
About this question bank
Version 1.0.0. How we source questions