Free Preparation Discussions
MENU
Microsoft 70-764 Exam Questions
- Microsoft MCSA: Microsoft Dynamics 365 for Operations Certifications
- Microsoft MCSA: SQL 2016 Database Administration Certifications
- Topic 1: Identify Sessions That Consume Tempdb Resources/ Configure An Azure SQL Database Audit
- Topic 2: Perform Point-In-Time Recovery/ Identify Sessions That Cause Blocking Activity
- Topic 3: Develop A Plan To Automate And Test Restores/ Identify Problematic Execution Plans
- Topic 4: Troubleshoot Server Health Using Extended Events/ Implement Database Consistency Checks
- Topic 5: Configure User Options For Azure SQL Database/ Implement Cell-Level Encryption
- Topic 6: Implement Auto Update Statistics/ Recover From Database Corruption/ Configure Transparent Data Encryption
- Topic 7: Configure Encryption For Connections/ Configure Data Access And Permissions/ Implement Backup Encryption
- Topic 8: Configure Alerting For Failed Backups/ Configure An Audit On SQL Server
- Topic 9: Manage Existing Columnstore Indexes/ Identify And Repair Index Fragmentation/ Identify And Correct Outdated Statistics
- Topic 10: Implement Statistics For Large Tables/ Configure Cluster Shared Volumes/ Create And Maintain Users
- Topic 11: Configure Policy-Based Management/ Identify Database Corruption/ Implement Alwayson Availability Groups
- Topic 12: Monitor SQL Server Instances/ Manage Database Integrity/ Create And Manage Operators
- Topic 13: Configure Read-Only Routing, Manage Failover/ Configure Windows Clustering/ Implement Failover Cluster Instances
- Topic 14: Identify And Create Missing Indexes/ Identify And Drop Underutilized Indexes/ Create And Maintain Custom Roles
- Topic 15: Create And Manage SQL Agent Alerts/ Configure Database Recovery Models/ Troubleshoot Encryption Errors
- Topic 16: Configure Dynamic Data Masking/ Configure The Data Collector/ Manage Database Object Permissions
- Topic 17: Query The SQL Server Audit Log, Manage A SQL Server Audit/ Configure Row-Level Security
- Topic 18: Analyze Audit Logs And Reports From Azure SQL Database/ Configure Extended Events And Trace Events
- Topic 19: Create Distributed Availability Groups/ Perform Piecemeal Restores/ Implement Always Encrypted
- Topic 20: Manage Transaction Log Backups/ Back Up Very Large Databases/ Configure Backup Automation
Free Microsoft 70-764 Exam Actual Questions
Note: Premium Questions for 70-764 were last updated On 01-01-1970 (see below)
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these
questions will not appear in the review screen.
You have a database named DB1 that contains a table named Table1.
You need to audit all updates to Table1.
Solution: From Local Group Policy Editor, you configure auditing for object access.
Does this meet the goal?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases.
One customer reports that their database is not responding as quickly as the service level agreements dictate. You observe that the database is fragmented.
You need to optimize query performance.
Solution: You run the DBCC CHECKDB command.
Does the solution meet the goal?
DBCC CHECKDB only checks the logical and physical integrity of all the objects in the specified database. It does not update any indexes, and does not improve query performance.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases.
One customer reports that their database is not responding as quickly as the service level agreements dictate. You observe that the database is fragmented.
You need to optimize query performance.
Solution: You rebuild all indexes.
Does the solution meet the goal?
You can remedy index fragmentation by either reorganizing an index or by rebuilding an index.
References: https://msdn.microsoft.com/en-us/library/ms189858(v=sql.105).aspx
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases.
One customer reports that their database is not responding as quickly as the service level agreements dictate. You observe that the database is fragmented.
You need to optimize query performance.
Solution: You reorganize all indexes.
Does the solution meet the goal?
You can remedy index fragmentation by either reorganizing an index or by rebuilding an index.
References: https://msdn.microsoft.com/en-us/library/ms189858(v=sql.105).aspx
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company has a server that runs Microsoft SQL Server 2016 Web edition. The server has a default instance that hosts a database named DB1.
You need to ensure that you can perform auditing at the database level for DB1.
Solution: You migrate DB1 to a named instance on a server than runs Microsoft SQL Server 2016 Standard edition.
Does the solution meet the goal?
All editions of SQL Server support server level audits. All editions support database level audits beginning with SQL Server 2016 SP1. Prior to that, database level auditing was limited to Enterprise, Developer, and Evaluation editions.
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Currently there are no comments in this discussion, be the first to comment!