70-764

70-764 practice questions, page 11 of 14, with answer review and explanations.

Question 51

You are the database administrator of a Microsoft SQL Server instance. Developers are writing stored procedures to send emails using sp_send_dbmail. Database Mail is enabled. You need to configure each accounts profile security and meet the following requirements: ✑ Account SMTP1_Account must only be usable by logins that have been given explicit permissions to use the SMTP1_profile. ✑ Account SMTP2_Account must only be usable by logins who are a member of the [DatabaseMailUserRole] role in msdb. In the table below. identify the profile type that must be used for each account. NOTE: Make only one selection in each column. Hot Area:

Question 52

You have a Microsoft SQL Server instance that hosts a database named DB1 that contains 800 gigabyte (GB) of data. The database is used 24 hours each day. You implement indexes and set the value of the Auto Update Statistics option set to True. Users report that queries take a long time to complete. You need to identify statistics that have not been updated for a week for tables where more than 1,000 rows changed. How should you complete the Transact-SQL statement? To answer, configure the appropriate Transact-SQL segments in the answer area. Hot Area:

Question 53

You are the database administrator for a Microsoft SQL Server instance. You develop an Extended Events package to look for events related to application performance. You need to change the event session to include SQL Server errors that are greater than error severity 15. Which five Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact- SQL segments to the answer area and arrange them in the correct order. Select and Place:

Question 54

You manage a Microsoft SQL Server environment. A server fails and writes the following event to the application event log: MSG_AUDIT_FORCED_SHUTDOWN - You configure the SQL Server startup parameters as shown in the following graphic: Use the drop-down menus to select the answer choice that answers each question. NOTE: Each correct selection is worth one point. Hot Area:

Question 55

A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instanced. The environments host several customer databases. You host a local database and a Stretch database that has a table named Members for one specific customer. You need to provide the customer with information about the space used in the databases. In the table below, identify the query that provides the required information for each database. NOTE: Make only one selection in each column. Hot Area: