{"id":12906,"date":"2020-07-22T19:25:41","date_gmt":"2020-07-22T19:25:41","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=12906"},"modified":"2021-05-27T13:58:37","modified_gmt":"2021-05-27T13:58:37","slug":"exam-70-765-provisioning-sql-databases","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-765-provisioning-sql-databases\/","title":{"rendered":"Exam 70-765: Provisioning SQL Databases"},"content":{"rendered":"\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Microsoft-Provisioning-SQL-Databases.png\" alt=\"Exam 70-765: Provisioning SQL Databases Online Tutorial\" class=\"wp-image-12966\"\/><\/figure><\/div>\n\n\n\n<p>The <strong><a href=\"https:\/\/www.testpreptraining.ai\/provisioning-sql-databases-70-765-practice-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Exam 70-765: Provisioning SQL Databases<\/a><\/strong> exam will validate your expertise in the integration of Azure applications with external resources, in deploying models, up-gradation and migration of databases, and applications and services. This certification aims to enhance your knowledge in all the latest features in SQL Server Databases, along with the important capabilities across the SQL Server data platform. This certification exam is one of the two tests that any aspirant must pass so that he\/she is eligible to earn a Microsoft Certified Solutions Associate (MCSA): 2016 Database Administration certification.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Target Audience<\/strong> <\/h3>\n\n\n\n<p>This examination is intended for developers and architects who possess a working knowledge regarding cloud service models and service model architectures, data storage options, and data synchronization techniques. It is primarily focused on the below-given individuals &#8211; <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Architects<\/li><li>Senior Developers<\/li><li>Infrastructure specialists<\/li><li>Development leads<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Recommended Knowledge<\/strong> <strong>and Related Certifications<\/strong><\/h3>\n\n\n\n<p>Candidates must possess sufficient skills and knowledge in implementing SQL in Azure, learn, and know how to manage databases and instances, also need to know about managing storage. Candidates are expected to have a wider working knowledge of deployment models, upgrading and migrating databases, and applications and services, together with integrating Azure applications with external resources. <\/p>\n\n\n\n<p>The related certifications are &#8211; <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>MCSA: Microsoft Dynamics 365 for Operations<\/strong> \u2013 This certification demonstrates a candidate`s expertise in Microsoft Dynamics 365 technologies to put into use the fundamental technical and development tasks which are essential to customize Microsoft Dynamics 365 for operations.<\/li><li><strong>MCSA: SQL 2016 Database Administration<\/strong> \u2013 This certification shows a candidate`s skills with database installation, maintenance, configuration, and provisioning tasks.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Details<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table aligncenter\"><table><tbody><tr><td><strong>Exam Name<\/strong>&nbsp;Provisioning SQL Databases&nbsp;<\/td><td><strong>Exam Code<\/strong>&nbsp;70-765<\/td><\/tr><tr><td><strong>Exam Duration<\/strong>&nbsp;120 mins<\/td><td><strong>Exam Format<\/strong>&nbsp;Multiple Choice and Multi-Response Questions<\/td><\/tr><tr><td><strong>Exam Type<\/strong>&nbsp;SQL Server 2016\/2017\/2019<\/td><td><strong>Number of Questions<\/strong>&nbsp;40-60 Questions<\/td><\/tr><tr><td><strong>Eligibility\/Pre-Requisite<\/strong>&nbsp;MCSA<\/td><td><strong>Exam Fee<\/strong>&nbsp;$165 USD<\/td><\/tr><tr><td><strong>Exam Language<\/strong>&nbsp;English<\/td><td><strong>Validity<\/strong>&nbsp;700 (on a scale of 1-1000)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Result<\/strong><\/h3>\n\n\n\n<p>Right after successfully completing your <strong><strong><a href=\"https:\/\/www.testpreptraining.ai\/provisioning-sql-databases-70-765-certification-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Exam 70-765: Provisioning SQL Databases<\/a><\/strong><\/strong>, you will be notified of your pass or fail status within a few minutes of completing your exam. Also, printed reports providing your exam score and feedback on your performance will also be provided to you. Your score will be forwarded to Microsoft within five business days. As far as Beta exam results are concerned, your result will be visible on your Microsoft transcript. However, you will see your result only if you\u2019ve achieved a passing score. Also, this result will be published on Pearson VUE\u2019s site within 14 business days, after the live exam is published.<br><strong>Note<\/strong>&nbsp;\u2013 If you are able to clear the beta exam, you will earn Microsoft credit for that exam and will also receive a resulting certification. Moreover, you are not required to retake the exam in its live version after clearing its beta version.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Retake Policy<\/strong><\/h3>\n\n\n\n<p>General Microsoft Certification exam has the following retake policy:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>If a candidate fails to achieve the passing marks in the exam the first time, the candidate must wait 24 to 30 hours before retaking the exam. Candidates can log onto their certification dashboard and reschedule the exam after the aforesaid time period.<\/li><li>If a candidate fails to get the passing scores the second time, he\/she must wait for at least 14 days before retaking the exam a third time.<\/li><li>For the fourth and fifth subsequent exam retakes a 14 day waiting period is required.<\/li><li>Any candidate is not liable to give an exam more than 5 times per year. He\/she is eligible for the exams 12 months from that date.<\/li><\/ul>\n\n\n\n<p>Exam retakes exceptions will be accepted when there is a failure due to the lab crash, internet connectivity issues, equipment failure, or in case of requests that include a Pearson VUE case number. The exception requests must be mailed to <a rel=\"noreferrer noopener\" href=\"mailto:mlsecure@microsoft.com\" target=\"_blank\">mlsecure@microsoft.com<\/a>. These requests include candidate ID, first\/last name, email associated with the candidate ID, exam registration ID, exam number, description of error, Pearson VUE case number.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Cancellation policy<\/strong><\/h3>\n\n\n\n<p>For Microsoft exams, there is no charge if any candidate reschedules\/cancel an examination appointment at least 6 business days prior to your appointment. If he\/she cancels or reschedules the examination within 5 days of the registered exam time, some fee will be applied. If he\/she fails to cancel\/ reschedule the appointment or fails to appear for the appointment at least 24 hours before the candidate`s scheduled exam appointment, then he\/she forfeits the full examination fees.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Recertification Policy<\/strong><\/h3>\n\n\n\n<p>Microsoft certification is expected to expire when the products are out of mainstream support although the person`s certification will be recognized. Officially, the MCSA certification will never expire.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>For More Details See &#8211; <a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-70-765-provisioning-sql-databases-faq\/\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft 70-765: Provisioning SQL Databases FAQ<\/a><\/strong><\/h4>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Microsoft-Provisioning-SQL-Databases-1.png\" alt=\"\" class=\"wp-image-12971\"\/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Course Outline<\/strong><\/h3>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Microsoft-Provisioning-SQL-Databases-Course-Outline.png\" alt=\"Exam 70-765: Provisioning SQL Databases - Course Outline\" class=\"wp-image-12968\"\/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Implement SQL in Azure (40-45%)<\/strong><\/h4>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<ol class=\"wp-block-list\"><li><strong>Deploying a Microsoft Azure SQL database<\/strong><\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li>Choosing a service tier (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/service-tiers-dtu#:~:text=Choosing%20a%20service%20tier%20depends,%2C%20storage%2C%20and%20performance%20requirements.&amp;text=The%20Basic%2C%20Standard%20S0%2C%20S1,S3%20or%20greater%20is%20recommended.\" target=\"_blank\" rel=\"noreferrer noopener\">Service tiers in the DTU-based purchase model<\/a>)<\/li><li>Creating servers and databases (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/databases\/create-a-database?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create a Database<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/mysql\/quickstart-create-mysql-server-database-using-azure-portal\" target=\"_blank\" rel=\"noreferrer noopener\">Create an Azure Database for MySQL server in the Azure portal<\/a>)<\/li><li>Creating a sysadmin account (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/logins-create-manage\" target=\"_blank\" rel=\"noreferrer noopener\">Authorize database access to SQL Database, SQL Managed Instance, and Azure Synapse Analytics<\/a>)<\/li><li>Configuring elastic pools (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/elastic-pool-manage\" target=\"_blank\" rel=\"noreferrer noopener\">Manage elastic pools in Azure SQL Database<\/a>)<\/li><\/ul>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\"><li><strong>Plan for SQL Server installation<\/strong><\/li><\/ol>\n<\/div><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Planning for an IaaS or on-premises deployment (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/dynamics365\/fin-ops-core\/dev-itpro\/deployment\/plan-onprem-deployment\" target=\"_blank\" rel=\"noreferrer noopener\">Plan and prepare for on-premises deployments<\/a>)<\/li><li>Selecting the appropriate size for a virtual machine (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/virtual-machines\/sizes\" target=\"_blank\" rel=\"noreferrer noopener\">Sizes for virtual machines in Azure<\/a>)<\/li><li>Planning storage pools based on performance requirements (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-server\/storage\/storage-spaces\/plan-volumes\" target=\"_blank\" rel=\"noreferrer noopener\">Planning volumes in Storage Spaces Direct<\/a>)<\/li><li>Evaluating best practices for installation <\/li><li>Designing a storage layout for a SQL Server virtual machine (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/virtual-machines\/windows\/storage-configuration\" target=\"_blank\" rel=\"noreferrer noopener\">Storage configuration for SQL Server VMs<\/a>)<\/li><\/ul>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\"><li><strong>Deploy SQL Server instances<\/strong><\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li>Deploying a SQL Server instance in IaaS and on-premises (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/virtual-machines\/windows\/sql-server-on-azure-vm-iaas-what-is-overview\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server on Azure Virtual Machines (Windows)<\/a>)<\/li><li>Manually install SQL Server on an Azure virtual machine <\/li><li>Provisioning an Azure virtual machine to host a SQL Server instance (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/virtual-machines\/windows\/create-sql-vm-portal\" target=\"_blank\" rel=\"noreferrer noopener\">How to use the Azure portal to provision a Windows virtual machine with SQL Server<\/a>)<\/li><li>Automating the deployment of SQL Server databases (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/paths\/automate-tasks-sql-server\/\" target=\"_blank\" rel=\"noreferrer noopener\">Automate tasks in SQL Server<\/a>)<\/li><li>Deploying SQL Server by using templates (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/templates\/microsoft.sql\/servers\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft.Sql servers template reference<\/a>)<\/li><\/ul>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\"><li><strong>Deploy SQL Server databases to Azure virtual machines<\/strong><\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li>Migrating an on-premises SQL Server database to an Azure virtual machine (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/mem\/configmgr\/core\/support\/azure-migration-tool\" target=\"_blank\" rel=\"noreferrer noopener\">Extend and migrate on-premises site to Microsoft Azure<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/virtual-machines\/windows\/migrate-to-vm-from-sql-server\" target=\"_blank\" rel=\"noreferrer noopener\">Migrate a SQL Server database to SQL Server on an Azure virtual machine<\/a>)<\/li><li>Generating benchmark data for performance needs (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/virtual-machines\/windows\/disks-benchmarks\" target=\"_blank\" rel=\"noreferrer noopener\">Benchmarking a disk<\/a>)<\/li><li>Performing performance tuning on Azure IaaS <\/li><li>Supporting availability sets in Azure <\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Manage databases and instances (30-35%)<\/strong><\/h4>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>Configure secure access to Microsoft Azure SQL databases<\/strong><\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li>Configuring firewall rules (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/install\/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Configure the Windows Firewall to Allow SQL Server Access<\/a>)<\/li><li>Configuring Always Encrypted for Azure SQL Database (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/always-encrypted-azure-key-vault-configure?tabs=azure-powershell\" target=\"_blank\" rel=\"noreferrer noopener\">Configure Always Encrypted by using Azure Key Vault<\/a>)<\/li><li>Configuring cell-level encryption (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/encryption\/encrypt-a-column-of-data?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Encrypt a Column of Data<\/a>)<\/li><li>Configuring dynamic data masking (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/dynamic-data-masking?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Dynamic Data Masking<\/a>)<\/li><li>Configuring transparent data encryption (TDE) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/encryption\/transparent-data-encryption?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Transparent Data Encryption (TDE)<\/a>)<\/li><\/ul>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\"><li><strong>Configure SQL Server performance settings<\/strong><\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li>Configuring database performance settings (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/configure-databases-performance\/\" target=\"_blank\" rel=\"noreferrer noopener\">Configure databases for performance<\/a>)<\/li><li>Configuring max server memory (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/configure-windows\/server-memory-server-configuration-options?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Server memory configuration options<\/a>)<\/li><li>Configuring the database scope (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/alter-database-scoped-configuration-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)<\/a>)<\/li><li>Configuring operators and alerts (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/agent\/assign-alerts-to-an-operator?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Assign Alerts to an Operator<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/agent\/create-an-operator?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create an Operator<\/a>)<\/li><\/ul>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\"><li><strong>Manage SQL Server instances<\/strong><\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li>Creating databases (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/databases\/create-a-database?view=sql-server-ver15#:~:text=Server%20Management%20Studio-,To%20create%20a%20database,and%20then%20click%20New%20Database.\" target=\"_blank\" rel=\"noreferrer noopener\">Create a Database<\/a>)<\/li><li>Managing files and filegroups (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/databases\/database-files-and-filegroups?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Database Files and Filegroups<\/a>)<\/li><li>Managing system database files <\/li><li>Configuring temp-DB (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/databases\/tempdb-database?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">tempdb database<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Manage Storage (30-35%)<\/strong><\/h4>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>Managing SQL Storage<\/strong> <\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li>Managing SMB file shares (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-server\/storage\/file-server\/file-server-smb-overview\" target=\"_blank\" rel=\"noreferrer noopener\">Overview of file sharing using the SMB 3 protocol in Windows Server<\/a>)<\/li><li>Managing stretch databases (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/stretch-database\/stretch-database?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Stretch Database<\/a>)<\/li><li>Configuring Azure storage (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/storage\/\" target=\"_blank\" rel=\"noreferrer noopener\">Azure Storage<\/a>)<\/li><li>Changing service tiers (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/single-database-scale\" target=\"_blank\" rel=\"noreferrer noopener\">Scale single database resources in Azure SQL Database<\/a>)<\/li><li>Reviewing wait statistics (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-dynamic-management-views\/sys-dm-os-wait-stats-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">sys.dm_os_wait_stats (Transact-SQL)<\/a>)<\/li><li>Managing storage pools (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-server\/storage\/storage-spaces\/overview\" target=\"_blank\" rel=\"noreferrer noopener\">Storage Spaces overview<\/a>)<\/li><li>Recovering from failed storage (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/storage\/common\/storage-disaster-recovery-guidance\" target=\"_blank\" rel=\"noreferrer noopener\">Disaster recovery and storage account failover<\/a>)<\/li><\/ul>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\"><li><strong>Performing database maintenance<\/strong><\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li>Monitoring DMVs (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/monitoring-with-dmvs\" target=\"_blank\" rel=\"noreferrer noopener\">Monitoring Microsoft Azure SQL Database with DMV<\/a>)<\/li><li>Maintaining indexes (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/indexes\/indexes?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Indexes<\/a>)<\/li><li>Automating maintenance tasks (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/windows\/win32\/taskschd\/task-maintenence\" target=\"_blank\" rel=\"noreferrer noopener\">Automatic maintenance<\/a>)<\/li><li>Updating statistics (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/update-statistics-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">UPDATE STATISTICS (Transact-SQL)<\/a>)<\/li><li>Verifying database integrity (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/control-flow\/check-database-integrity-task?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Check Database Integrity Task<\/a>)<\/li><li>Recovering from database corruption (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/mysql\/how-to-fix-corrupt-database\" target=\"_blank\" rel=\"noreferrer noopener\">Troubleshoot database corruption on Azure Database for MySQL<\/a>)<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Microsoft 70-765: Provisioning SQL Databases Preparation Guide<\/strong><\/h3>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"2000\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Microsoft-Provisioning-SQL-Databases-4.png\" alt=\"Microsoft 70-765: Provisioning SQL Databases Preparation Guide\" class=\"wp-image-13410\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Microsoft-Provisioning-SQL-Databases-4.png 800w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Microsoft-Provisioning-SQL-Databases-4-160x400.png 160w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Instructor-led Training<\/strong><\/h3>\n\n\n\n<p><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/courses\/20765\" target=\"_blank\" rel=\"noreferrer noopener\">Course 20765-C: Provisioning SQL Databases<\/a><\/strong><\/p>\n\n\n\n<p>This course aims at providing students with knowledge regarding how to provision SQL databases both on-premise and in SQL Azure. This instructor laid training for 5 days with 10 modules is for the individuals who administer and maintain SQL Server Databases. These individuals are more likely to perform maintenance and database administration as their core area of work and responsibility. This course can also be undertaken by those who develop applications that deliver content from SQL Server databases. The essential prerequisites for this course include &#8211; <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Experience with database design<\/li><li>Candidates must possess some working knowledge of Transact \u2013SQL<\/li><li>Also, working knowledge of relational databases<\/li><li>Finally, some basic knowledge regarding the MS Windows operating system and its core functionality<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Microsoft Books<\/strong><\/h4>\n\n\n\n<p>Microsoft provides reference books that can be helpful while studying for the exam. These books contain various useful resources that can be used while studying. Visit <a rel=\"noreferrer noopener\" href=\"https:\/\/www.microsoftpressstore.com\/search\/index.aspx?page=1&amp;query=&amp;showResults=Store&amp;searchagain=Search+again&amp;sortBy=Relevance\" target=\"_blank\"><strong>Microsoft Press books<\/strong><\/a>, to find relevant books to get a deeper insight into the exam objectives, and hence crack the test, and earn your certification. Some of the recommended books are &#8211; <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong><a rel=\"noreferrer noopener\" href=\"https:\/\/www.microsoftpressstore.com\/store\/exam-ref-70-765-provisioning-sql-databases-9781509303816\" target=\"_blank\">Exam Ref 70-765 Provisioning SQL Databases<\/a><\/strong><\/li><li><strong><a rel=\"noreferrer noopener\" href=\"https:\/\/www.microsoftpressstore.com\/store\/exam-ref-70-765-provisioning-sql-databases-with-practice-9781509306381\" target=\"_blank\">Exam Ref 70-765 Provisioning SQL Databases with Practice Test<\/a><\/strong><\/li><li><strong><a rel=\"noreferrer noopener\" href=\"https:\/\/www.microsoftpressstore.com\/store\/mcsa-sql-2016-database-administration-exam-ref-2-pack-9780672338052\" target=\"_blank\">MCSA SQL 2016 Database Administration Exam Ref 2-pack: Exam Refs 70-764 and 70-765<\/a><\/strong><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Join Microsoft Community<\/strong><\/h4>\n\n\n\n<p>A healthy discussion is always beneficial, no matter where it is done. The prospects of getting resolutions to an issue increase steeply when a greater number of people are involved. Also, multiple viewpoints make the stuff more dynamic. These discussions make the studies more comprehensive. Introverts get a chance to express themselves, who might otherwise prefer staying out of discussions. Forums work really well to build a community that is essential for understanding others.&nbsp; &nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Practice Tests<\/strong><\/h4>\n\n\n\n<p>Microsoft offers a Practice Test for the candidates taking its certification exam to give a better understanding of the exam objectives. Regardless of how you prepare for the Microsoft Exam 70-765, a practice run or two can help you in more ways than you might expect. Taking a practice test is a great way to diversify your study strategy and ensure the best possible results for the real thing. Analyzing your answers will help you identify the areas where you need to give special attention to, and will also let you know your alignment with the exam objectives. So take the <strong><a rel=\"noreferrer noopener\" href=\"https:\/\/www.testpreptraining.ai\/provisioning-sql-databases-70-765-free-practice-test\" target=\"_blank\">Microsoft 70-765: Provisioning SQL Databases Practice Test<\/a><\/strong>.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.testpreptraining.ai\/provisioning-sql-databases-70-765-free-practice-test\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/70-765-1.png\" alt=\"\" class=\"wp-image-12976\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/70-765-1.png 960w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/70-765-1-750x117.png 750w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/a><\/figure><\/div>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Enrich and Upgrade your profile to pass <a rel=\"noreferrer noopener\" href=\"https:\/\/www.testpreptraining.ai\/provisioning-sql-databases-70-765-free-practice-test\" target=\"_blank\">Microsoft 70-765: Provisioning SQL Databases<\/a> exam with hundreds of practice Exam. Start Preparing Now!<\/strong><\/h5>\n","protected":false},"excerpt":{"rendered":"<p>The Exam 70-765: Provisioning SQL Databases exam will validate your expertise in the integration of Azure applications with external resources, in deploying models, up-gradation and migration of databases, and applications and services. This certification aims to enhance your knowledge in all the latest features in SQL Server Databases, along with the important capabilities across the&#8230;<\/p>\n","protected":false},"author":1,"featured_media":12966,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[174],"tags":[4,1971,1969,1970],"class_list":["post-12906","page","type-page","status-publish","has-post-thumbnail","hentry","category-microsoft-azure","tag-m4f","tag-microsoft-70-765-provisioning-sql-databases-practice-tests","tag-microsoft-70-765-provisioning-sql-databases-preparation-guide","tag-microsoft-70-765-provisioning-sql-databases-study-tutorial"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exam 70-765: Provisioning SQL Databases - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Increase your chances to crack the Microsoft Exam 70-765: Provisioning SQL Databases with our Free Practice Tests, and Study Tutorials.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-765-provisioning-sql-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exam 70-765: Provisioning SQL Databases - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Increase your chances to crack the Microsoft Exam 70-765: Provisioning SQL Databases with our Free Practice Tests, and Study Tutorials.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-765-provisioning-sql-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-27T13:58:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Microsoft-Provisioning-SQL-Databases.png\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-765-provisioning-sql-databases\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-765-provisioning-sql-databases\/\",\"name\":\"Exam 70-765: Provisioning SQL Databases - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-07-22T19:25:41+00:00\",\"dateModified\":\"2021-05-27T13:58:37+00:00\",\"description\":\"Increase your chances to crack the Microsoft Exam 70-765: Provisioning SQL Databases with our Free Practice Tests, and Study Tutorials.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-765-provisioning-sql-databases\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-765-provisioning-sql-databases\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-765-provisioning-sql-databases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam 70-765: Provisioning SQL Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exam 70-765: Provisioning SQL Databases - Testprep Training Tutorials","description":"Increase your chances to crack the Microsoft Exam 70-765: Provisioning SQL Databases with our Free Practice Tests, and Study Tutorials.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-765-provisioning-sql-databases\/","og_locale":"en_US","og_type":"article","og_title":"Exam 70-765: Provisioning SQL Databases - Testprep Training Tutorials","og_description":"Increase your chances to crack the Microsoft Exam 70-765: Provisioning SQL Databases with our Free Practice Tests, and Study Tutorials.","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-765-provisioning-sql-databases\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-05-27T13:58:37+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Microsoft-Provisioning-SQL-Databases.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-765-provisioning-sql-databases\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-765-provisioning-sql-databases\/","name":"Exam 70-765: Provisioning SQL Databases - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-07-22T19:25:41+00:00","dateModified":"2021-05-27T13:58:37+00:00","description":"Increase your chances to crack the Microsoft Exam 70-765: Provisioning SQL Databases with our Free Practice Tests, and Study Tutorials.","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-765-provisioning-sql-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-765-provisioning-sql-databases\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-765-provisioning-sql-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam 70-765: Provisioning SQL Databases"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/12906","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=12906"}],"version-history":[{"count":12,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/12906\/revisions"}],"predecessor-version":[{"id":21728,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/12906\/revisions\/21728"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media\/12966"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=12906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=12906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=12906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}