{"id":8049,"date":"2020-06-19T12:33:24","date_gmt":"2020-06-19T12:33:24","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=8049"},"modified":"2021-05-27T13:55:53","modified_gmt":"2021-05-27T13:55:53","slug":"exam-70-764-administering-a-sql-database-infrastructure","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-764-administering-a-sql-database-infrastructure\/","title":{"rendered":"Exam 70-764: Administering a SQL Database Infrastructure"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Administering-a-SQL-Database-Infrastructure-70-764.png\" alt=\"Administering a SQL Database Infrastructure (70-764) \" class=\"wp-image-8050\"\/><\/a><\/figure><\/div>\n\n\n\n<p>Microsoft&#8217;s SQL Server platform is one of the top three relational database products in the world&#8217;s enterprise marketplace, which means that those with SQL Server skills are in high demand everywhere. <a href=\"https:\/\/www.testpreptraining.ai\/administering-a-sql-database-infrastructure-70-764-practice-exam-prep\" target=\"_blank\" rel=\"noreferrer noopener\">Administering a SQL Database Infrastructure (70-764)<\/a> is designed for those who want to become a SQL Server administrator. After this exam, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain the knowledge and skills to administer a SQL server database infrastructure.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Who can take this exam?<\/strong><\/h4>\n\n\n\n<p>This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"154\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/764-certificate-750x154.png\" alt=\"Administering a SQL Database Infrastructure (70-764) \" class=\"wp-image-8051\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/764-certificate-750x154.png 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/764-certificate.png 917w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Learning Objectives&nbsp;<\/strong><\/h4>\n\n\n\n<p>Microsoft provides a learning path for Administering a SQL Database Infrastructure (70-764) exam which is specifically designed for the candidates who are seeking to build a career as Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Administration. The objectives for (70-764) exam are as follows:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Configure data access and auditing (20\u201325%)<\/li><li>Manage backup and restore of databases (20\u201325%)<\/li><li>Manage and monitor SQL Server instances (35\u201340%)<\/li><li>Manage high availability and disaster recovery (20\u201325%)<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to prepare for Exam 70-764 ?\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/eWCgeMcNr7k?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Learning Path&nbsp;<\/strong><\/h3>\n\n\n\n<p>Microsoft provides various certifications in several fields. However, Administering a SQL Database Infrastructure (70-764) Exam and Provisioning SQL Databases (70-765) are paths to become MCSA: SQL 2016 Database Administration.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"391\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/764-path-750x391.png\" alt=\"Administering a SQL Database Infrastructure (70-764) \" class=\"wp-image-8052\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/764-path-750x391.png 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/764-path.png 907w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Exam Details&nbsp;<\/strong><\/h4>\n\n\n\n<p>Explaining the format of Administering a SQL Database Infrastructure (70-764) exam is the most important step. The exam includes 40-60 number of questions. The questions will appear in the form of multiple-choice. The candidate will get 120 minutes to complete the exam, in total, they get 150 minutes. The exam is available in various languages such as English, Japanese, Chinese (Simplified), Korean. The candidate has to pay $165 USD as the examination fee.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/www.testpreptraining.ai\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/764-details.png\" alt=\"Administering a SQL Database Infrastructure (70-764) \" class=\"wp-image-8053\" width=\"531\" height=\"453\"\/><\/a><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Scheduling the Exam<\/strong><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/eFKS4ZC2nmxb0rlh3mPkn96--35l8rpY5APRIL4n9AJDt0roy-rF3XQX-Ea_ZmHfSl4LpbXOSB2igFc6gRXtNG-kj7JG4REQT4CNHqfaTxNeWDmgdVIfsL7wDJzurA7eJjJsVoXf\" width=\"143\" height=\"39\"><\/h4>\n\n\n\n<p>In order to appear in Microsoft exam, the candidate has to schedule the exam and make themselves register with Microsoft. The candidate can schedule their exam with the Pearson VUE.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Detailed Course Outline<\/strong><\/h3>\n\n\n\n<p>The Administering a SQL Database Infrastructure (70-764) exam includes its objectives and sub-topics in it. The detailed course outline is mentioned below:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/www.testpreptraining.ai\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/764-objectives.png\" alt=\"Administering a SQL Database Infrastructure (70-764) \" class=\"wp-image-8054\" width=\"757\" height=\"434\"\/><\/a><\/figure><\/div>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Configure data access and auditing (20\u201325%)<\/strong><\/h5>\n\n\n\n<p><em>Configure encryption<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>implement 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>implement Always Encrypted (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/encryption\/always-encrypted-database-engine?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Always Encrypted<\/a>)<\/li><li>implement backup encryption (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/backup-encryption?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Backup Encryption<\/a>)<\/li><li>configure transparent data encryption (<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><li>configure encryption for connections (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/configure-windows\/enable-encrypted-connections-to-the-database-engine?view=sql-server-ver15#:~:text=On%20the%20Object%20Explorer%20toolbar,Properties%20tab%2C%20click%20Encrypt%20connection.\" target=\"_blank\" rel=\"noreferrer noopener\">Enable encrypted connections to the Database Engine<\/a>)<\/li><li>troubleshoot encryption errors<\/li><\/ul>\n\n\n\n<p><em>Configure data access and permissions<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>manage database object permissions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/permissions-database-engine?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Permissions (Database Engine)<\/a>)<\/li><li>create and maintain users<\/li><li>create and maintain custom roles (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/authentication-access\/create-a-server-role?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create a Server Role<\/a>)<\/li><li>configure user options for Azure SQL Database (<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<\/a>)<\/li><li>configure row-level security (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/row-level-security?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Row-Level Security<\/a>)<\/li><li>configure 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#:~:text=Dynamic%20data%20masking%20helps%20prevent,the%20result%20sets%20of%20queries.\" target=\"_blank\" rel=\"noreferrer noopener\">Dynamic Data Masking<\/a>)<\/li><\/ul>\n\n\n\n<p><em>Configure auditing<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>configure an audit on SQL Server (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/auditing\/sql-server-audit-database-engine?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server Audit (Database Engine)<\/a>)<\/li><li>query the SQL Server audit log (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/auditing\/view-a-sql-server-audit-log?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">View a SQL Server Audit Log<\/a>)<\/li><li>manage a SQL Server audit (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/auditing\/sql-server-audit-database-engine?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server Audit (Database Engine)<\/a>)<\/li><li>configure an Azure SQL Database audit (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/auditing\/sql-server-audit-database-engine?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server Audit (Database Engine)<\/a>)<\/li><li>analyze audit logs and reports from Azure SQL Database (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/auditing-overview#:~:text=Go%20to%20the%20Azure%20portal,modify%20the%20server%20auditing%20settings.\" target=\"_blank\" rel=\"noreferrer noopener\">Auditing for Azure SQL Database<\/a>)<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Manage backup and restore of databases (20\u201325%)<\/strong><\/h5>\n\n\n\n<p><em>Develop a backup strategy<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>back up very large databases (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/back-up-and-restore-of-sql-server-databases?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Back Up and Restore of SQL Server Databases<\/a>)<\/li><li>configure alerting for failed backups<\/li><li>back up databases to Azure (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/backup\/backup-azure-sql-database\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server Backup in Azure VMs<\/a>)<\/li><li>manage transaction log backups (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/transaction-log-backups-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Transaction Log Backups (SQL Server)<\/a>)<\/li><li>configure database recovery models (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/view-or-change-the-recovery-model-of-a-database-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">View or Change the Recovery Model of a Database (SQL Server)<\/a>)<\/li><li>configure backup automation<\/li><\/ul>\n\n\n\n<p><em>Restore databases<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>perform piecemeal restores (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/piecemeal-restores-sql-server?view=sql-server-ver15#:~:text=Piecemeal%20restore%20allows%20databases%20that,one%20or%20more%20secondary%20filegroups.\" target=\"_blank\" rel=\"noreferrer noopener\">Piecemeal Restores (SQL Server)<\/a>)<\/li><li>perform page recovery (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/restore-pages-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Restore Pages (SQL Server)<\/a>)<\/li><li>perform point-in-time recovery (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/recovery-using-backups#:~:text=To%20recover%20a%20managed%20instance,new%20database%20will%20be%20created.\" target=\"_blank\" rel=\"noreferrer noopener\">Recover using automated database backups<\/a>)<\/li><li>restore file groups (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/restore-files-and-filegroups-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Restore Files and Filegroups (SQL Server)<\/a>)<\/li><li>develop a plan to automate and test restores<\/li><\/ul>\n\n\n\n<p><em>Manage database integrity<\/em><\/p>\n\n\n\n<p><strong>Microsoft Documentation: <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/maintenance-plans\/check-database-integrity-task-maintenance-plan?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Check Database Integrity Task (Maintenance Plan)<\/a><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>implement database consistency checks<\/li><li>identify database corruption<\/li><li>recover from database corruption<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Manage and monitor SQL Server instances (35\u201340%)<\/strong><\/h5>\n\n\n\n<p><em>Monitor database activity<\/em><\/p>\n\n\n\n<p><strong>Microsoft Documentation: <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/authentication-access\/database-level-roles?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Database-Level Roles<\/a><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>monitor current sessions<\/li><li>identify sessions that cause blocking activity<\/li><li>identify sessions that consume tempdb resources (<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 and Azure SQL Managed Instance performance<\/a>)<\/li><li>configure the data collector (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/data-collection\/data-collection?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Data Collection<\/a>)<\/li><\/ul>\n\n\n\n<p><em>Monitor queries<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>manage the Query Store (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/best-practice-with-the-query-store?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Best practices with Query Store<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/monitoring-performance-by-using-the-query-store?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Monitoring performance by using the Query Store<\/a>)<\/li><li>configure Extended Events and trace events (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/extended-events\/quick-start-extended-events-in-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Extended events in SQL Server<\/a>)<\/li><li>identify problematic execution plans (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/automatic-tuning\/automatic-tuning?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Automatic tuning<\/a>)<\/li><li>troubleshoot server health using Extended Events (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/extended-events\/use-the-system-health-session?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Use the system_health Session<\/a>)<\/li><\/ul>\n\n\n\n<p><em>Manage indexes<\/em><\/p>\n\n\n\n<p><strong>Microsoft Documentation: <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/indexes\/indexes?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Indexes<\/a><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>identify and repair index fragmentation (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/indexes\/reorganize-and-rebuild-indexes?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Resolve index fragmentation by reorganizing or rebuilding indexes<\/a>)<\/li><li>identify and create missing indexes<\/li><li>identify and drop underutilized indexes<\/li><li>manage existing column store indexes (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/indexes\/columnstore-indexes-overview?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Columnstore indexes: Overview<\/a>)<\/li><\/ul>\n\n\n\n<p><em>Manage statistics<\/em><\/p>\n\n\n\n<p><strong>Microsoft Documentation: <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/statistics\/statistics?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Statistics<\/a><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>identify and correct outdated statistics<\/li><li>implement Auto Update Statistics<\/li><li>implement statistics for large tables<\/li><\/ul>\n\n\n\n<p><em>Monitor SQL Server instances<\/em><\/p>\n\n\n\n<p><strong>Microsoft Documentation: <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/install\/work-with-multiple-versions-and-instances-of-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Work with multiple versions and instances of SQL Server<\/a><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>create and manage operators (<strong>Microsoft Documentation:<\/strong> <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><li>create and manage SQL Agent alerts (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/agent\/alerts?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Alerts<\/a>)<\/li><li>define custom alert actions<\/li><li>define failure actions<\/li><li>configure database mail (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/database-mail\/configure-database-mail?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Configure Database Mail<\/a>)<\/li><li>configure Policy-Based Management (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/policy-based-management\/administer-servers-by-using-policy-based-management?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Administer Servers by Using Policy-Based Management<\/a>)<\/li><li>identify available space on data volumes<\/li><li>identify the cause of performance degradation<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Manage high availability and disaster recovery (20\u201325%)<\/strong><\/h5>\n\n\n\n<p><em>Implement log shipping<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>configure and monitor log shipping (<strong>Microsoft Documentation: <\/strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/log-shipping\/about-log-shipping-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">About Log Shipping<\/a>)<\/li><\/ul>\n\n\n\n<p><em>Implement AlwaysOn Availability Groups<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>configure Windows clustering<\/li><li>create an availability group (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-availability-group-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">CREATE AVAILABILITY GROUP<\/a>)<\/li><li>configure read-only routing (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/availability-groups\/windows\/configure-read-only-routing-for-an-availability-group-sql-server?view=sql-server-ver15#:~:text=To%20support%20read%2Donly%20routing%2C%20the%20availability%20group%20must%20possess,be%20read%2Dintent%20connection%20requests.\" target=\"_blank\" rel=\"noreferrer noopener\">Configure read-only routing for an Always On availability group<\/a>)<\/li><li>manage failover <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-server\/manage\/windows-admin-center\/use\/manage-failover-clusters\" target=\"_blank\" rel=\"noreferrer noopener\">Manage Failover Clusters with Windows Admin Center<\/a>)<\/li><li>create distributed availability groups <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/availability-groups\/windows\/configure-distributed-availability-groups?view=sql-server-ver15#:~:text=You%20can%20create%20a%20distributed,replica%20of%20the%20FCI%20instance.\" target=\"_blank\" rel=\"noreferrer noopener\">Create distributed availability group on failover cluster instances<\/a>)<\/li><\/ul>\n\n\n\n<p><em>Implement failover cluster instances<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>manage shared disks and configure cluster shared volumes (<strong>Microsoft Documentation: <\/strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/failover-clusters\/install\/sql-server-failover-cluster-installation?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server Failover Cluster Installation<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Exam Policies&nbsp;<\/strong><\/h4>\n\n\n\n<p>While preparing for the Microsoft exam, the candidate should visit the Microsoft official site and refer o the <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/certification-exam-policies\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft exam policies<\/a> and try to understand them. The Microsoft policies provide information regarding basic information such as policies about <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/certification-exam-policies\" target=\"_blank\" rel=\"noreferrer noopener\">retaking the exam<\/a>, scheduling the exam, candidate appeal process, etc.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/administering-a-sql-database-infrastructure-70-764-faq\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Administering-a-SQL-Database-Infrastructure-70-764-1-1.png\" alt=\"Administering a SQL Database Infrastructure (70-764)\" class=\"wp-image-8056\"\/><\/a><\/figure><\/div>\n\n\n\n<h5 class=\"has-text-align-center wp-block-heading\"><strong><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/administering-a-sql-database-infrastructure-70-764-faq\/\" target=\"_blank\" rel=\"noreferrer noopener\">Administering a SQL Database Infrastructure (70-764) FAQ<\/a><\/strong><\/h5>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step-by-step Preparation Guide<\/strong><\/h3>\n\n\n\n<p>Here is a step-by-step preparation guide for successfully passing the Administering a SQL Database Infrastructure (70-764) exam.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/764-resources-750x400.png\" alt=\"Administering a SQL Database Infrastructure (70-764) \" class=\"wp-image-8057\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/764-resources-750x400.png 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/764-resources.png 1006w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Microsoft Learning Platform&nbsp;<\/strong><\/h4>\n\n\n\n<p>Microsoft offers various learning paths, the candidate should visit the official website of Microsoft. The candidate can find every possible information on the official site. For this exam, the candidate will find many learning paths and documentations. Finding the relatable content on the Microsoft website is quite an easy task.&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Microsoft Documentation<\/strong><\/h4>\n\n\n\n<p>Documentations are an important learning resource while preparing for Administering a SQL Database Infrastructure (70-764). The candidate will find documentation on every topic relating to the particular exam. This step is very valuable in preparing for Implementing an Azure Data Solution exam.&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Microsoft Online Training&nbsp;<\/strong><\/h4>\n\n\n\n<p>Microsoft also offers online training for many certifications. For Administering a SQL Database Infrastructure (70-764) exam, there are some online training courses available which are as follows:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.edx.org\/course\/securing-data-in-azure-and-sql-server-2\" target=\"_blank\" rel=\"noreferrer noopener\">Securing Data in Azure and SQL Server<\/a><\/li><li><a href=\"https:\/\/www.edx.org\/course\/recovering-data-in-azure-and-sql-server\" target=\"_blank\" rel=\"noreferrer noopener\">Recovering Data in Azure and SQL Server<\/a><\/li><li><a href=\"https:\/\/www.edx.org\/course\/managing-sql-server-operations\" target=\"_blank\" rel=\"noreferrer noopener\">Managing SQL Server Operations<\/a><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Instructor-Led Training<\/strong><\/h4>\n\n\n\n<p>The training programs that the Micorosft provide itself is available on their website. The instructor-led training is an essential resource in order to prepare for the exam like 70-764. The candidate can find the instructor-led training on the page of the particular exam on the Microsoft website. There are various training courses available prior to one exam. The following is the training program offered by Microsoft.&nbsp;<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><a href=\"https:\/\/www.microsoft.com\/en-us\/learning\/course.aspx?cid=20764\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Course 20764C: Administering a SQL Database Infrastructure<\/strong><\/a><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Module 1: SQL Server Security<\/li><li>Module 2: Assigning Server and Database Roles<\/li><li>Module 3: Authorizing Users to Access Resources<\/li><li>Module 4: Protecting Data with Encryption and Auditing<\/li><li>Module 5: Recovery Models and Backup Strategies<\/li><li>Module 6: Backing Up SQL Server Databases<\/li><li>Module 7: Restoring SQL Server 2016 Databases<\/li><li>Module 8: Automating SQL Server Management<\/li><li>Module 9: Configuring Security for SQL Server Agent<\/li><li>Module 10: Monitoring SQL Server with Alerts and Notifications<\/li><li>Module 11: Introduction to Managing SQL Server by using PowerShell<\/li><li>Module 12: Tracing Access to SQL Server with Extended events<\/li><li>Module 13: Monitoring SQL Server<\/li><li>Module 14: Troubleshooting SQL Server<\/li><li>Module 15: Importing and Exporting Data<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Books and Guides&nbsp;<\/strong><\/h4>\n\n\n\n<p>Candidate should study some books and guides which will definitely help them to gather knowledge about the particular exam. Microsoft itself recommends the following:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"218\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/764-book-750x218.png\" alt=\"Administering a SQL Database Infrastructure (70-764) \" class=\"wp-image-8058\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/764-book-750x218.png 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/764-book.png 791w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Join a Study Group&nbsp;<\/strong><\/h4>\n\n\n\n<p>For passing the exam like Administering a SQL Database Infrastructure (70-764), the candidate needs to get and share knowledge. So, we are suggesting you join some study where you can discuss the concepts with the people who have the same goal. This will lead the candidate throughout their preparation.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Practice Test<\/strong><\/h4>\n\n\n\n<p>The most important step is to try your hands on the practice test. <a href=\"https:\/\/www.testpreptraining.ai\/administering-a-sql-database-infrastructure-70-764-practice-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Practice tests<\/a> are the one which ensures the candidate about their preparation. There are many practice tests are available on the internet nowadays, the candidate can choose whichever they want. The practice test is very beneficial in preparing the exam like 70-764.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/administering-a-sql-database-infrastructure-70-764-free-practice-test\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"200\" height=\"200\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/practice-test-3.png\" alt=\"\" class=\"wp-image-8059\"\/><\/a><\/figure><\/div>\n\n\n\n<h5 class=\"has-text-align-center wp-block-heading\"><strong><a href=\"https:\/\/www.testpreptraining.ai\/administering-a-sql-database-infrastructure-70-764-free-practice-test\" target=\"_blank\" rel=\"noreferrer noopener\">Administering a SQL Database Infrastructure (70-764) Free Practice Test<\/a><\/strong><\/h5>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft&#8217;s SQL Server platform is one of the top three relational database products in the world&#8217;s enterprise marketplace, which means that those with SQL Server skills are in high demand everywhere. Administering a SQL Database Infrastructure (70-764) is designed for those who want to become a SQL Server administrator. After this exam, professionals who administer&#8230;<\/p>\n","protected":false},"author":1,"featured_media":8050,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[174],"tags":[1142,1143,1144,1145,4],"class_list":["post-8049","page","type-page","status-publish","has-post-thumbnail","hentry","category-microsoft-azure","tag-administering-a-sql-database-infrastructure-70-764","tag-administering-a-sql-database-infrastructure-70-764-details","tag-administering-a-sql-database-infrastructure-70-764-faq","tag-administering-a-sql-database-infrastructure-70-764-tutorial","tag-m4f"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exam 70-764: Administering a SQL Database Infrastructure | Study Guide<\/title>\n<meta name=\"description\" content=\"Get ready to boost your learning and prepare for MCSA. Practice and prepare for Administering a SQL Database Infrastructure (70-764) Now!\" \/>\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-764-administering-a-sql-database-infrastructure\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exam 70-764: Administering a SQL Database Infrastructure | Study Guide\" \/>\n<meta property=\"og:description\" content=\"Get ready to boost your learning and prepare for MCSA. Practice and prepare for Administering a SQL Database Infrastructure (70-764) Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-764-administering-a-sql-database-infrastructure\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-27T13:55:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Administering-a-SQL-Database-Infrastructure-70-764.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-764-administering-a-sql-database-infrastructure\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-764-administering-a-sql-database-infrastructure\/\",\"name\":\"Exam 70-764: Administering a SQL Database Infrastructure | Study Guide\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-06-19T12:33:24+00:00\",\"dateModified\":\"2021-05-27T13:55:53+00:00\",\"description\":\"Get ready to boost your learning and prepare for MCSA. Practice and prepare for Administering a SQL Database Infrastructure (70-764) Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-764-administering-a-sql-database-infrastructure\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-764-administering-a-sql-database-infrastructure\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-764-administering-a-sql-database-infrastructure\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam 70-764: Administering a SQL Database Infrastructure\"}]},{\"@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-764: Administering a SQL Database Infrastructure | Study Guide","description":"Get ready to boost your learning and prepare for MCSA. Practice and prepare for Administering a SQL Database Infrastructure (70-764) Now!","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-764-administering-a-sql-database-infrastructure\/","og_locale":"en_US","og_type":"article","og_title":"Exam 70-764: Administering a SQL Database Infrastructure | Study Guide","og_description":"Get ready to boost your learning and prepare for MCSA. Practice and prepare for Administering a SQL Database Infrastructure (70-764) Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-764-administering-a-sql-database-infrastructure\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-05-27T13:55:53+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Administering-a-SQL-Database-Infrastructure-70-764.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-764-administering-a-sql-database-infrastructure\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-764-administering-a-sql-database-infrastructure\/","name":"Exam 70-764: Administering a SQL Database Infrastructure | Study Guide","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-06-19T12:33:24+00:00","dateModified":"2021-05-27T13:55:53+00:00","description":"Get ready to boost your learning and prepare for MCSA. Practice and prepare for Administering a SQL Database Infrastructure (70-764) Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-764-administering-a-sql-database-infrastructure\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-764-administering-a-sql-database-infrastructure\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-764-administering-a-sql-database-infrastructure\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam 70-764: Administering a SQL Database Infrastructure"}]},{"@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\/8049","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=8049"}],"version-history":[{"count":15,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/8049\/revisions"}],"predecessor-version":[{"id":42780,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/8049\/revisions\/42780"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media\/8050"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=8049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=8049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=8049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}