DRAG DROP -You administer a database that is used for reporting purposes. The database has a large fact table that contains three hundred million rows. The table includes a clustered columnstore index and a nonclustered index on the ProductID column. New rows are inserted into the table every day.Performance of queries that filter the Product ID column have degraded significantly.You need to improve the performance of the queries.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:
HOTSPOT -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:
HOTSPOT -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:
DRAG DROP -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:
HOTSPOT -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:
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 need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail.Solution: You add the DatabaseMailUserRole to Mail1 in the tempdb database.Does the solution meet the goal?
