Microsoft Azure Data Fundamentals291 questions across 30 pages are complete and free, with no account or card.
291 questions in this bank
Free access · progress saved on this device
You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database. Which type of authentication should you use?
Answer: B
B. Other authentication types, such as service principal authentication, SQL authentication and certificate authentication, don't allow the use of MFA.
Source: Adapted from community discussion — Pinha
What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
Answer: B
ACD are available for both SQL db and SQL managed instance. While multiple writes and reads for SQL managed instance and only multi read alone is available for SQL db. So it's B
Source: Adapted from community discussion — Kans19
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.
Answer: See figure below
When you create a new server in Azure SQL Database or Azure Synapse Analytics named mysqlserver, for example, a server-level firewall blocks all access to the public endpoint for the server Reference: https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql
Source: Adapted from community discussion — ExamPwnr
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.
Answer: See figure below
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel-processing-mpp-architecture
Source: Adapted from community discussion — sreekarv
You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?
Answer: A
SSDT, you can create an offline database project and implement schema changes by adding, modifying or deleting the definitions of objects (represented by scripts) in the project
Source: Adapted from community discussion — nicolase
DRAG DROP - Match the security components to the appropriate scenarios. To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component 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.
Answer: See figure below
Reference: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows-firewall-for-database-engine-access?view=sql-server-ver15 https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-certificate-store-configure
Source: Adapted from community discussion — Armandoo
You have a transactional application that stores data in an Azure SQL managed instance. When should you implement a read-only database replica?
Answer: A
Why C? It is not High Availability if you cannot write to the database. If your primary database goes down, HA means that users would continue to work as normal, but they cannot commit changes in this case (Read-Only). Answer should be only: A.
Source: Adapted from community discussion — ExamPwnr
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.
Answer: See figure below
4th Option is correct. 1.Relational databases are static schema so option A is wrong. 2.data stored as key/value pairs is JSON (semi-structured data)relationalDB are structured data. Option B is wrong 3. Storing large images and videos is unstructured data.Option c is wrong.
Source: Adapted from community discussion — SAIVEENA
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.
Answer: See figure below
Reference: https://teachcomputerscience.com/relational-databases/
Source: Adapted from community discussion — ndatta
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.
Answer: See figure below
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/views/views
Source: Adapted from community discussion — shinz
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
DP-900 practice, question 271. 291 questions available.
Version 1.0.0. How we source questions