Azure Database Administrator Associate (DP-300) - Full Practice Exam 1

1. A business permits at most ten minutes of lost data and one hour to restore database service. Which TWO recovery objectives match? Select TWO.
2. A client must protect SQL traffic and verify it is connecting to the trusted server. Which configuration is appropriate?
3. A database application requires a specific SQL Server installation and a third-party OS component. Which Azure target best preserves that control?
4. A database uses a customer-managed TDE protector. What additional dependency must the recovery design preserve?
5. A database uses asynchronous geographic replication. What must be acknowledged in a forced failover after the primary region becomes unavailable?
6. A database uses TDE, but an authorized user can still query plaintext values. Is that expected?
7. A deployment plan contains many databases and expects unlimited scale because it is managed. What should the administrator validate?
8. A design must prevent the database engine administrator from seeing selected plaintext columns during ordinary processing, with decryption handled by authorized clients. Which capability should be evaluated?
9. A disaster-recovery exercise restores the database but the application cannot authenticate or resolve its target endpoint. What should the plan include?
10. A frequently executed query became slow after its execution plan changed. The administrator needs historical plans and runtime statistics. Which capability should be examined?
11. A large sort repeatedly spills to tempdb and latency rises. Which evidence should the administrator inspect?
12. A large SQL database needs a storage architecture that can scale substantially and provide supported fast scaling and restore characteristics. Which service tier should be evaluated against workload requirements?
13. A migration requires broad SQL Server instance compatibility and SQL Server Agent, but the team wants Microsoft to manage the underlying OS. Which target should be assessed first?
14. A migration to SQL Managed Instance needs scheduled database tasks using a supported instance-level job service. Which capability is available to evaluate?
15. A planned geographic database failover is possible while the primary is still reachable. Why is synchronizing according to the supported failover process valuable?
16. A production database must tolerate a zone outage within its allowed region. Which design should be evaluated?
17. A proposed index speeds one report but significantly increases write cost. What should guide the decision?
18. A query filters by a common key and returns a few additional columns. A suitable covering index could reduce lookups. What must be evaluated?
19. A query returns a few rows but performs a large scan. What should the administrator inspect before changing compute size?
20. A reporting identity should select from specified tables and must not update data or administer the database. Which approach best fits least privilege?
21. A SaaS platform has many small databases with sporadic peaks that rarely occur together. Which deployment model should be evaluated to share compute capacity?
22. A scheduled database operation reports failure. The automation must remain retryable and diagnosable. Which behavior is best?
23. A scheduled maintenance job targets several databases. What security design should its execution identity follow?
24. A security standard requires encryption of database files at rest. Which SQL capability directly addresses this?
25. A team masks a sensitive column in query output and assumes this alone is a complete security boundary against all database users. What should be explained?
26. A team must evaluate and execute a supported database migration to Azure with appropriate source and target compatibility. Which service should it assess?
27. A team rebuilds every index nightly without measuring fragmentation, page density, usage, or resource impact. What should be improved?
28. A team runs SQL Server on Azure VMs and wants supported Azure management integrations such as eligible backup and patching automation. Which component should it evaluate?
29. A test database has long idle intervals and can tolerate resume latency. Which Azure SQL compute option should be evaluated where supported?
30. A user accidentally deletes rows at 10:05. The database has suitable retained point-in-time backups. Which recovery approach should be evaluated?
31. After a major data distribution change, a query plan estimates far fewer rows than it actually processes. Which maintenance or analysis step should be evaluated?
32. An administrator needs centrally scheduled T-SQL maintenance across many Azure SQL databases. Which capability should be evaluated?
33. An application needs a stable Azure SQL Database read-write endpoint across a supported regional failover. Which feature fits?
34. An application retries a deadlock victim transaction. What property is important for safe retry handling?
35. An application will use its supported managed identity to connect to Azure SQL instead of storing a SQL password. Which TWO requirements must be addressed? Select TWO.
36. An organization wants supported SQL threat alerts and vulnerability assessment capabilities. Which security service should be evaluated?
37. Azure SQL Database can recommend or apply supported tuning actions. What operational practice should accompany their use?
38. Azure SQL private access is required. A private endpoint is configured, but clients resolve the server publicly. What must be corrected?
39. Before choosing a managed Azure SQL target, which assessment is most important?
40. Database infrastructure must be reproduced in several environments with reviewed changes. Which approach is appropriate?
41. Encrypted backups are retained, but access to the required customer-managed key is lost. What risk does the recovery plan face?
42. Many queries are blocked behind a long-running transaction. What should be determined before terminating its session?
43. Query Store identifies a previous plan that performed well for the same query. Which controlled mitigation should be evaluated while investigating the regression?
44. Several database alerts must notify the same on-call group and invoke supported response automation. Which reusable object should they reference?
45. SQL Server on Azure VMs requires a supported database-level high-availability design using multiple SQL instances. Which capability should be evaluated?
46. SQL Server runs on Azure VMs. The team wants supported OS patch scheduling within an agreed maintenance window. Which feature should it evaluate?
47. The organization needs supported backup retention beyond the ordinary short-term recovery window. Which capability should be evaluated?
48. The organization relies on geo-restore from backups instead of a continuously maintained readable secondary. What tradeoff should it expect?
49. Two transactions wait on resources held by each other, and SQL Server selects a deadlock victim. What should be investigated?
50. Users should query the same table but see only rows allowed by a defined tenant-access predicate. Which SQL feature fits?

Comments — 0