You have an Excel workbook that has the following two workbook queries: A query named Consultants that retrieves a table named Consultants_Contact from a Microsoft SQL Server database A query named Employees that retrieves...
DRAG DROP You administer a Microsoft SQL Server instance that contains a database of confidential data. You need to encrypt the database files at the page level. You also need to encrypt the transaction...
You administer a Microsoft SQL Server database. You create an availability group named haContosoDbs. Your primary replica is available at Server01Contoso01. You need to configure the availability group to prevent data loss. In the...
You have multiple workbook queries that load data from tables in Microsoft Azure SQL Database to a Power Pivot data model. You discover that new rows were added to the tables in Azure SQL...
You administer a database that has User A, B and C. User A must be able to create new tables and stored procedures, User B must be able to select, update, delete and insert...
DRAG DROP You have a two- node SQL Server 2014 cluster that has an Always On availability group configured in synchronous mode. You plan to provide a reporting solution by using a third node...
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...
You administer a Microsoft SQL Server environment. You purchase a new server and plan to migrate your database from an existing server to the new server. You want to evaluate the new server’s performance...
You develop three Microsoft SQL Server 2012 databases named Database1, Database2, and Database3. You have permissions on both Database1 and Database2. You plan to write and deploy a stored procedure named dbo.usp_InsertEvent in Database3....
You have an Azure Stack integrated system that has several tenants. You back up the tenant data. You need to provide a backup solution for the Azure Stack infrastructure. What should you do first?A...
