- All Exams Instant Download
What should you recommend?
You have a SQL Server instance on a server named Server1. You need to recommend a solution to perform the following tasks every week: Rebuild the indexes by using a new fill factor. Run a custom T-SQL command. Back up the databases. What should you recommend? More than one answer...
Which features should you identify?
DRAG DROP You plan to deploy a database by using SQL Server 2014. Your company identifies the following requirements for the database: The name of all stored procedures must start with "usp_"always. All distribution statistics must be updated daily. You need to identify which feature must be used to meet...
You manage a Microsoft SQL Server environment
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 NOTE: Each correct...
Which isolation levels should you recommend?
DRAG DROP You plan to deploy SQL Server 2014. You are designing two stored procedures named SP1 and SP2 that have the following requirements: - Prevent data read by SP1 from being modified by other active processes. - Prevent SP2 from performing dirty reads. You need to recommend the isolation...
What should you include in the recommendation?
Overview Application Overview Contoso, Ltd, is the developer of an enterprise resource planning (ERP) application. Contoso is designing a new version of the ERP application. The previous version of the ERP application used SQL Server 2008 R2. The new version will use SQL Server 2014. The ERP application relies on...
Does the solution meet the goal?
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Databaseinstances. 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....
In which order should the four actions be performed?
DRAG DROP You need to recommend the actions that are required to partition a table. In which order should the four actions be performed? To answer, move the actions from the list of actions to the answer area and arrange them in the correct order. Select and Place: View AnswerAnswer:...
You need to recommend a solution to minimize the amount of time it takes to execute USP_1. With what should you recommend replacing Table1?
Overview General Overview ADatum Corporation has offices in Miami and Montreal. The network contains a single Active Directory forest named adatum.com. The offices connect to each other by using a WAN link that has 5-ms latency. A. Datum standardizes its database platform by using SQL Server 2014 Enterprise edition. Databases...
Which code fragment should you use in each location in the command to complete one of the commands you will need to include in the job?
DRAG DROP Background Corporate Information Fabrikam, Inc. is a retailer that sells electronics products on the Internet. The company has a headquarters site and one satellite sales office. You have been hired as the database administrator, and the company wants you to change the architecture of the Fabrikam ecommerce site...
What should you configure?
General Overview You are the Senior Database Administrator (DBA) for a manufacturing company named Fairstone Manufacturing. Fairstone Manufacturing is based in the New York area. The company has two offices: a main office in the city and a branch office just outside the city. The company has four factories where...
