DRAG AND DROP You are developing a SQL Server Integration Services (SSIS) package to insert new data into a data mart. The package uses a Lookup transformation to find matches between the source and destination. The data flow has the…

DRAG DROP You are designing a SQL Server Integration Services (SSIS) package. The package moves order-related data to a staging table named Order. Every night the staging data is truncated and then all the recent orders from the online store…

DRAG AND DROP You are designing a package control flow. The package moves sales order data from a SQL Azure transactional database to an on-premise reporting database. The package will run several times a day, while new sales orders are…

You administer a Microsoft SQL Server database. You want to import data from a text file to the database. You need to ensure that the following requirements are met: • Data import is performed by using a stored procedure. •…

You administer a Microsoft SQL Server 2012 database. The database contains two tables named Table A and Table B. You perform an import and export operation by using the following steps in sequence, as shown in the exhibit. (Click the…

You administer a Microsoft SQL Server 2012 instance. An application executes a large volume of dynamic queries. You need to reduce the amount of memory used for cached query plans. What should you do? (To answer, move the appropriate statements…

Your company is evaluating the data cleansing capabilities of SQL Server Data Quality Services (DQS). A stand-alone server will be used to host DQS, as well as all related services necessary to run this service. You need to install the…

You administer three Microsoft SQL Server 2012 servers. You need to install the Power View components on a stand-alone server. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to…

You administer a Microsoft SQL Server 2012 server that has a database named Contoso. The Contoso database has a table named ProductPrices in a schema named Sales. You need to create a script that writes audit events into the application…

You want to add a new GUID column named BookGUID to a table named dbo.Book that already contains data. BookGUID will have a constraint to ensure that it always has a value when new rows are inserted into dbo.Book. You…