70-765 exam

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals. You have a mission-critical application that stores data in a Microsoft SQL Server instance. The application runs several financial...

You administer a Microsoft SQL Server 2014 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals. You manage a Microsoft SQL Server environment with several databases. You need to ensure that queries use statistical data...

You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size. The Sales database is configured as shown in the following table. You discover that all files except Sales_2.ndf are corrupt. You need to recover the corrupted data in the minimum amount of time. What...

You administer a Microsoft SQL Server 2014 instance named SQL2012 that hosts an OLTP database of 1 terabyte in size. The database is modified by users only from Monday through Friday from 09:00 hours to 17:00 hours. Users modify more than 30 percent of the data in the database during...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals. Your company plans to use Microsoft Azure Resource Manager templates for all future deployments of SQL Server on Azure...

You administer a Microsoft SQL Server 2014 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of...

You administer a Microsoft SQL Server 2014 server. You plan to deploy new features to an application. You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance. What should you do?A . Query the sys.dm_db_index_usage_stats DMC . Query the sys.dm_db_missing_index_details DME . Use the Database...

Topic 2, Manage databases and instances HOTSPOT You need to ensure that a user named Admin2 can manage logins. How should you complete the Transact-SQL statements? To answer, select the appropriate Transact-SQL segments in the answer area. View AnswerAnswer: Explanation: Step 1: CREATE LOGIN First you need to create a...

You administer a Microsoft SQL Server 2014 database. You need to ensure that the size of the transaction log file does not exceed 2 GB. What should you do?A . Execute sp_configure 'max log size', 2C . use the ALTER DATABASD . ..SET LOGFILE command along with the maxsize parameter.E...