Which five Transact-SQL segments should you use to develop the solution?

DRAG DROPYou are the database administrator for a Microsoft SQL Server instance. You develop an Extended Eventspackage 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, […]

Read More

Hot Area:

HOTSPOTYou manage a Microsoft SQL Server environment. A server fails and writes the following event to theapplication event log:MSG_AUDIT_FORCED_SHUTDOWNYou 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: Answer: Explanation:Box 1: […]

Read More

How should you complete the Transact-SQL statement?

HOTSPOTYou 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 UpdateStatistics option set to True.Users report that queries take a long time to complete.You need to identify statistics […]

Read More

Which three actions should you perform in sequence?

DRAG DROPYou administer a database that is used for reporting purposes. The database has a large fact table thatcontains three hundred million rows. The table includes a clustered columnstore index and a nonclusteredindex on the ProductID column. New rows are inserted into the table every day.Performance of queries that filter the Product ID column have […]

Read More

You need to configure each account’s profile security and meet the following requirements:

HOTSPOTYou are the database administrator of a Microsoft SQL Server instance. Developers are writing storedprocedures to send emails using sp_send_dbmail. Database Mail is enabled.You need to configure each account’s profile security and meet the following requirements:Account SMTP1_Account must only be usable by logins that have been given explicit permissions to usethe SMTP1_profile.Account SMTP2_Account must only […]

Read More

You need to address the performance issues with each table

HOTSPOTYou deploy a Microsoft SQL Server instance to support a global sales application. The instance includes thefollowing tables: TableA and TableB.TableA is a partitioned table that uses an incrementing integer number for partitioning. The table has millions ofrows in each partition. Most changes to the data in TableA affect recently added data. The UPDATESTATISTICS for […]

Read More

Which Transact-SQL statement should you run?

You have a database named DB1 that stores more than 700 gigabyte (GB) of data and serves millions ofrequests per hour.Queries on DB1 are taking longer than normal to complete.You run the following Transact-SQL statement:SELECT * FROM sys.database_query_store_optionsYou determine that the Query Store is in Read-Only mode.You need to maximize the time that the Query […]

Read More

What should you configure?

You manage a Microsoft SQL Server environment. You plan to encrypt data when you create backups.You need to configure the encryption options for backups.What should you configure? A. a certificate B. an MD5 hash C. a DES key D. an AES 256-bit key Explanation:To encrypt during backup, you must specify an encryption algorithm, and an […]

Read More

Which three Transact-SQL segments should you use to develop the solution?

DRAG DROPYou administer a Microsoft SQL Server database named Contoso. You create a stored procedure namedSales.ReviewInvoice by running the following Transact-SQL statement: You need to create a Windows-authenticated login named ContosoSearch and ensure that ContosoSearch canrun the Sales.ReviewInvoices stored procedure.Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriateTransact-SQL […]

Read More