Administering Microsoft Azure SQL Solutions
Last Update Apr 27, 2024
Total Questions : 311
You will be glad to know that we serve better with the real exam topics related to your subject. We give you Microsoft Certified: Azure Database Administrator Associate DP-300 questions answers. You can prepare them easily and quickly. Microsoft DP-300 exam dumps are also available with accurate exam content. All Exam questions of Microsoft Certified: Azure Database Administrator Associate DP-300 Exam are related to latest Administering Microsoft Azure SQL Solutions topics, let’s take a look:
| Exam Name | Administering Microsoft Azure SQL Solutions |
| Exam Code | DP-300 |
| Actual Exam Duration | 120 minutes |
| Expected no. of Questions in Actual Exam | 60 |
| Exam Registration Price | $165 |
| Official Information | https://docs.microsoft.com/en-us/learn/certifications/exams/dp-300 |
| See Expected Questions | Microsoft DP-300 Expected Questions in Actual Exam |
| Take Self-Assessment | Use Microsoft DP-300 Practice Test to Assess your preparation - Save Time and Reduce Chances of Failure |
| Section | Weight | Objectives |
|---|---|---|
| Configure resources for scale and performance | 15-20% | - configure Azure SQL database/elastic pools for scale and performance - configure Azure SQL managed instances for scale and performance - configure SQL Server in Azure VMs for scale and performance - calculate resource requirements - evaluate database partitioning techniques, such as database sharding - set up SQL Data Sync |
| Recommend an appropriate database offering based on specific requirements | 15-20% | - evaluate requirements for the deployment - evaluate the functional benefits/impact of possible database offerings - evaluate the scalability of the possible database offering - evaluate the HA/DR of the possible database offering - evaluate the security aspects of the possible database offering |
| Deploy resources by using manual methods | 15-20% | - deploy database offerings on selected platforms - configure customized deployment templates - apply patches and updates for hybrid and IaaS deployment |
| Evaluate a strategy for moving to Azure | 15-20% | - evaluate requirements for the migration - evaluate offline or online migration strategies - evaluate requirements for the upgrade - evaluate offline or online upgrade strategies |
| Implement a migration or upgrade strategy for moving to Azure | 15-20% | - implement an online migration strategy - implement an offline migration strategy - implement an online upgrade strategy - implement an offline upgrade strategy |
| Configure database authentication by using platform and database tools | 15-20% | - configure Azure AD authentication - create users from Azure AD identities - configure security principals |
| Configure database authorization by using platform and database tools | 15-20% | - configure database and object-level permissions using graphical tools - apply principle of least privilege for all securables |
| Implement security for data at rest | 15-20% | - implement Transparent Data Encryption (TDE) - implement object-level encryption - implement Dynamic Data Masking - implement Azure Key Vault and disk encryption for Azure VMs |
| Implement security for data in transit | 15-20% | - configure server and database-level firewall rules - implement Always Encrypted |
| Implement compliance controls for sensitive data | 15-20% | - apply a data classification strategy - configure server and database audits - implement data change tracking - perform a vulnerability assessment |
| Monitor activity and performance | 15-20% | - prepare an operational performance baseline - determine sources for performance metrics - interpret performance metrics - assess database performance by using Intelligent Insights for Azure SQL Database and Managed Instance - configure and monitor activity and performance at the infrastructure, server, service, and database levels |
| Implement performance-related maintenance tasks | 15-20% | - implement index maintenance tasks - implement statistics maintenance tasks - configure database auto-tuning - automate database maintenance tasks - manage storage capacity |
| Identify performance-related issues | 15-20% | - configure Query Store to collect performance data - identify sessions that cause blocking - assess growth/fragmentation of databases and logs - assess performance-related database configuration parameters |
| Configure resources for optimal performance | 15-20% | - configure storage and infrastructure resources - configure server and service account settings for performance - configure Resource Governor for performance |
| Configure a user database for optimal performance | 15-20% | - implement database-scoped configuration - configure compute resources for scaling - configure Intelligent Query Processing (IQP) |
| Review query plans | 5-10% | - determine the appropriate type of execution plan - identify problem areas in execution plans - extract query plans from the Query Store |
| Evaluate performance improvements | 5-10% | - determine the appropriate Dynamic Management Views (DMVs) to gather query performance information - identify performance issues using DMVs - identify and implement index changes for queries - recommend query construct modifications based on resource usage - assess the use of hints for query performance |
| Review database table and index design | 5-10% | - identify data quality issues with duplication of data - identify normal form of database tables - assess index design for performance - validate data types defined for columns - recommend table and index storage including filegroups - evaluate table partitioning strategy - evaluate the use of compression for tables and indexes |
| Create scheduled tasks | 10-15% | - manage schedules for regular maintenance jobs - configure multi-server automation - configure notifications for task success/failure/non-completion |
| Evaluate and implement an alert and notification strategy | 10-15% | - create event notifications based on metrics - create event notifications for Azure resources - create alerts for server configuration changes - create tasks that respond to event notifications |
| Manage and automate tasks in Azure | 10-15% | - perform automated deployment methods for resources - automate backups - automate performance tuning and patching - implement policies by using automated evaluation modes |
| Recommend an HADR strategy for a data platform solution | 15-20% | - recommend HADR strategy based on RPO/RTO requirements - evaluate HADR for hybrid deployments - evaluate Azure-specific HADR solutions - identify resources for HADR solutions |
| Test an HADR strategy by using platform, OS, and database tools | 15-20% | - test HA by using failover - test DR by using failover or restore |
| Perform backup and restore a database by using database tools | 15-20% | - perform a database backup with options - perform a database restore with options - perform a database restore to a point in time - configure long-term backup retention |
| Configure HA/DR by using OS, platform, and database tools | 15-20% | - configure replication - create an Availability Group - configure auto-failover groups - integrate a database into an Availability Group - configure quorum options for a Windows Server Failover Cluster - configure an Availability Group listener |
| Examine system health | 10-15% | - evaluate database health using DMVs - evaluate server health using DMVs - perform database consistency checks by using DBCC |
| Monitor database configuration by using T-SQL | 10-15% | - assess proper database autogrowth configuration - report on database free space - review database configuration options |
| Perform backup and restore a database by using T-SQL | 10-15% | - prepare databases for Always On Availability Groups - perform transaction log backup - perform restore of user databases - perform database backups with options |
| Manage authentication by using T-SQL | 10-15% | - manage certificates - manage security principals |
| Manage authorization by using T-SQL | 10-15% | - configure permissions for users to access database objects - configure permissions by using custom roles |
DP-300 Exam Topics | DP-300 Questions answers | DP-300 Test Prep | Administering Relational Databases on Microsoft Azure Exam Questions PDF | DP-300 Online Exam | DP-300 Practice Test | DP-300 PDF | DP-300 Test Questions | DP-300 Study Material | DP-300 Exam Preparation | DP-300 Valid Dumps | DP-300 Real Questions | Microsoft Certified: Azure Database Administrator Associate DP-300 Exam Questions
TESTED 28 Apr 2024
