70-764

DRAG DROP You plan to deploy SQL Server 2012. You must create two tables named Table 1 and Table 2 that will have the following specifications: Table1 will contain a date column named Column1 that will contain a null value approximately 80 percent of the time. Table2 will contain a...

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 plan to integrate an on-premises Microsoft SQL Server environment with Microsoft Azure. You need to create the authentication object so that you can connect to Azure. Which Windows PowerShell command or commands should you run?A . Invoke-Sqlcmd “CREATE EXTERNAL DATA SOURCE MyAzureStorage WITH (LOCATION = ‘wasbs://[email protected]/”, CREDENTIAL = Pa$$w0rd)”B...

You administer two instances of Microsoft SQL Server 2016. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you...

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

DRAG DROP You have two servers named SQL1 and SQL2 that have SQL Server 2012 installed. SQL1 contains a database that is mirrored asynchronously to SQL2. The database contents are updated once a month. You need to upgrade the database to SQL Server 2014. The solution must minimize downtime. Which...

You administer a SQL Server 2014 instance. Users report that the SQL Server has seemed slow today. A large database was being restored for much of the day, which could be causing issues. You want to write a query of the system views that will report the following: Number of...

You administer a Microsoft SQL Server 2016 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...

HOTSPOT You manage a Microsoft SQL Server environment. You have a database named salesOrders that includes a table named Table1. Table1 becomes corrupt. You repair the table. You need to verify that all the data in Table1 complies with the schema. How should you complete the Transact-SQL code statement? To...

General Overview You are the Senior Database Administrator (DBA) for a software development company named Leafield Solutions. The company develops software applications custom designed to meet customer requirements. Requirements Leafield Solutions has been asked by a customer to develop a web-based Enterprise Resource Planning and Management application. The new application...