Plan and implement data platform resources Questions
Practice questions for Plan and implement data platform resources topic in Microsoft Certified: Azure Database Administrator Associate. 36 questions covering this domain.
A single Azure SQL Database is expected to grow far beyond traditional size limits and needs support for named replicas and fast restore. Which servic...
A company wants to move an existing SQL Server instance to Azure with minimal to no compatibility issues. Which target platform is the best fit accord...
An administrator moves a database to another Azure SQL Managed Instance by using the managed instance move feature. What happens to the existing point...
An Azure SQL Managed Instance deployment must support more than 100 databases on one instance and more than 16 TB of reserved storage while remaining ...
You plan to copy a database online from one Azure SQL Managed Instance to another in a different virtual network. Which prerequisite must be satisfied...
A security team requires Always Encrypted with secure enclaves backed by Intel SGX hardware in Azure SQL Database. Which hardware family is required?
A SaaS application uses one Azure SQL Database per customer. Most databases are idle most of the day, but each customer can have short unpredictable s...
An application requires consistently low storage latency around 1 to 2 ms and wants to offload read-only reporting to a readable secondary replica in ...
A development team wants an Azure SQL Database that automatically scales compute based on demand and can pause during inactivity to reduce cost. Which...
Which Azure VM family does Microsoft recommend for SQL Server workloads that need a high ratio of memory to vCPU and premium SSD v2 support?
Which Microsoft tool is purpose-built to assess SQL Server databases for Azure SQL readiness, including feature parity and performance, before migrati...
An architect wants a purchasing model in Azure SQL Database that lets them independently scale compute and storage and use Azure Hybrid Benefit. Which...
A team wants Azure to apply system updates to their Azure SQL resources only on weekend nights. What feature should they configure?
An architect needs the lowest possible latency between application tier VMs and an Azure SQL Database, including for chatty workloads sensitive to rou...
A team wants to copy an existing Azure SQL Database to a new logical server in another region with a single T-SQL or REST call. Which feature should t...
A team must deploy an Azure SQL Managed Instance with the smallest supported subnet for a small environment. What is the documented minimum subnet siz...
What is the maximum database size supported by Azure SQL Database Hyperscale?
An administrator must place an Azure SQL Managed Instance into a customer VNet. Which subnet requirement applies?
A DBA is troubleshooting a migration from SQL Server 2016 to Azure SQL Database that fails during the schema creation phase. The migration assessment ...
A team plans to use Azure SQL Database in Microsoft Fabric. Which primary capability does this integration provide?
Sign in to see all 36 questions
Create a free account to browse all questions — completely free during our launch phase.