A SaaS provider is designing a multi-tenant application. Each tenant has a unique ID and requires strong isolation. The largest tenants generate high write throughput, while smaller tenants have low usage. The team wants to minimize cost while ensuring performance isolation. They are considering Azure SQL Database offerings. Which recommendation best balances these requirements?

Use a single large Azure SQL Database for all tenants

Use a single Azure SQL Managed Instance for all tenants

Use Azure SQL Database serverless for all tenants

Use a pool of Azure SQL Databases with elastic pools for smaller tenants and dedicated databases for large tenants

A healthcare organization runs SQL Server 2016 on-premises and wants to extend its environment to Azure for additional capacity and disaster recovery. They need to keep the on-premises and cloud databases synchronized and support failover. They also want to manage both environments from a single pane of glass. Which hybrid SQL Server solution should you recommend?

Use Azure Arc to manage the on-premises instance only

Deploy SQL Server on Azure VM and use Always On Availability Groups

Use Azure SQL Database with transactional replication

Use Azure SQL Managed Instance with a link feature

You are designing a table in Azure SQL Database that stores IoT sensor readings. The table currently has 2 billion rows and is expected to grow by 500 million rows per year. Queries frequently filter by a datetime column for the last 30 days. You need to improve query performance and simplify data archiving. Which partitioning strategy should you use?

Partition the table by the datetime column using a monthly partition function

Use a hash-distributed table with a datetime column as the distribution key

Create a nonclustered index on the datetime column

Create a clustered columnstore index on the table

Microsoft Certified:Azure Database Administrator Associate

Domain 1Objective 1

Plan and Deploy Azure SQL Solutions DP-300 Practice Questions (Page 4)

Part of the Plan and implement data platform resources domain, which accounts for 15–20% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~6–13 in this domain), expect 2–4 from this objective — we provide 31 practice questions to prepare you well beyond it. (estimate)

31questions here

7free pages

9concepts

15–20%of the exam

Questions 16–20

16expert · hard
A SaaS provider is designing a multi-tenant application. Each tenant has a unique ID and requires strong isolation. The largest tenants generate high write throughput, while smaller tenants have low usage. The team wants to minimize cost while ensuring performance isolation. They are considering Azure SQL Database offerings. Which recommendation best balances these requirements?
Select an answer first
17foundation · easy
A company wants to extend its on-premises SQL Server environment to Azure by creating a disaster recovery site. They want to use Azure as a secondary replica for an Always On availability group. Which Azure service should they use?
Select an answer first
18foundation · easy
A company has SQL Server instances running on-premises in a remote branch office with intermittent connectivity. They want to manage these instances centrally from Azure and apply consistent policies. Which solution should they use?
Select an answer first
19application · medium
A healthcare organization runs SQL Server 2016 on-premises and wants to extend its environment to Azure for additional capacity and disaster recovery. They need to keep the on-premises and cloud databases synchronized and support failover. They also want to manage both environments from a single pane of glass. Which hybrid SQL Server solution should you recommend?
Select an answer first
20application · medium
You are designing a table in Azure SQL Database that stores IoT sensor readings. The table currently has 2 billion rows and is expected to grow by 500 million rows per year. Queries frequently filter by a datetime column for the last 30 days. You need to improve query performance and simplify data archiving. Which partitioning strategy should you use?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-300” is a trademark of its owner, used for identification only.

Plan and Deploy Azure SQL Solutions DP-300 Practice Questions (Page 4)

Questions 16–20

A company wants to extend its on-premises SQL Server environment to Azure by creating a disaster recovery site. They want to use Azure as a secondary replica for an Always On availability group. Which Azure service should they use?

A company has SQL Server instances running on-premises in a remote branch office with intermittent connectivity. They want to manage these instances centrally from Azure and apply consistent policies. Which solution should they use?

Keep studying — Plan and implement data platform resources