What should you do?

October 29, 2020Pdfprep70-76470-764 exam questions, 70-764 practice exam, MCSA

You maintain a database named DB1 that has a nonpartitioned table. You create an index in the table. Automatic statistics updates are disabled. Users report that some Microsoft SQL Server Reporting Service (SSRS) queries take...

Read more +

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

October 28, 2020Pdfprep70-76470-764 exam questions, 70-764 practice exam, MCSA

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 account’s profile security and...

Read more +

How does the script affect the environment?

October 28, 2020Pdfprep70-76470-764 exam questions, 70-764 practice exam, MCSA

HOTSPOT You are configuring log shipping for a Microsoft SQL Server database named salesOrders. You run the following Transact-SQL script: You need to determine the changes that the script has on the environment. How does...

Read more +

Which Transact-SQL statement should you run?

October 28, 2020Pdfprep70-76470-764 exam questions, 70-764 practice exam, MCSA

You have a database named DB1 that is configured to use the full recovery model. You have a full daily backup job that runs at 02:00. The job backs up data from DB1 to the...

Read more +

Which Transact-SQL statement should you run?

October 27, 2020Pdfprep70-76470-764 exam questions, 70-764 practice exam, MCSA

You have a database named DB1 that stores more than 700 gigabyte (GB) of data and serves millions of requests per hour. Queries on DB1 are taking longer than normal to complete. You run the...

Read more +

How should you complete the Transact-SQL statement?

October 27, 2020Pdfprep70-76470-764 exam questions, 70-764 practice exam, MCSA

HOTSPOT Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices,...

Read more +

Does this meet the goal?

October 27, 2020Pdfprep70-76470-764 exam questions, 70-764 practice exam, MCSA

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...

Read more +

Which two actions should you perform?

October 27, 2020Pdfprep70-76470-764 exam questions, 70-764 practice exam, MCSA

You have a Microsoft SQL Server instance that has database named DBI. The database is used purposes. You plan to capture all queries for a specific table and save the data as a text file....

Read more +

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series

October 27, 2020Pdfprep70-76470-764 exam questions, 70-764 practice exam, MCSA

HOTSPOT Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices,...

Read more +

Does this meet the goal?

October 27, 2020Pdfprep70-76470-764 exam questions, 70-764 practice exam, MCSA

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...

Read more +