You need to deploy the project
You are developing a SQL Server Integration Services (SSIS) project by using the Project
Deployment Model.
The project will be deployed to an SSIS catalog folder where Environments have already
been created. You need to deploy the project. What should you do?
Which Transact-SQL statement should you use?
You administer a Microsoft SQL Server 2012 database named Contoso that contains a
single user-defined database role namedBillingUsers.
All objects in Contoso are in the dbo schema.
You need to grant EXECUTE permission for all stored procedures in Contoso to
BillingUsers.
Which Transact-SQL statement should you use?
You need to ensure that the package error information is captured and written to the table
You are developing a SQL Server Integration Services (SSIS) package to load data into a
data warehouse. The package consists of several data flow tasks.
The package experiences intermittent errors in the data flow tasks.
If any data flow task fails, all package error information must be captured and written to a
SQL Server table by using an OLE DB connection manager.
You need to ensure that the package error information is captured and written to the table.
What should you do?
What should you include in your solution?
You have been hired as a Database Consultant by ABC.com to design a SQL Server 2012
database solution.
You are tasked with designing a scale-out and high-availability SQL Server 2012 Online
Transaction Processing (OLTP) database solution that will maintain copies of data across
two server instances.
Your solution must provide scale-out of read operations by distributing the reads from clients
across two SQL Server 2012 nodes. The data in both SQL Server nodes needs to be
indexed.
What should you include in your solution?
You need to create a solution to meet the requirements by using the least amount of administrative effort and
You are developing a SQL Server Integration Services (SSIS) project to read and write data
from a Windows Azure SQL Database database to a server that runs SQL Server 2012.
The connection will be used by data flow tasks in multiple SSIS packages. The address of
the target Windows Azure SQL Database database will be provided by a project parameter.
You need to create a solution to meet the requirements by using the least amount of
administrative effort and maximizing data flow performance.
What should you do?
Which Transact- SQL statement should you use?
You are a database developer of a Microsoft SQL Server 2012 database. You are designing
a table that will store Customer data from different sources. The table will include a column
that contains the CustomerID from the source system and a column that contains the
SourceID. A sample of this data is as shown in the following table.
You need to ensure that the table has no duplicate CustomerID within a SourceID. You also
need to ensure that the data in the table is in the order of SourceID and then CustomerID.
Which Transact- SQL statement should you use?
You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues
You develop a SQL Server Integration Services (SSIS) project by using the Package
Deployment Model. A package in the project extracts data from a Windows Azure SQL
Database database.
The package is deployed to SQL Server.
The package is not producing the desired results.
You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues.
What should you do?
Which Transact-SQL query should you use?
You administer a Microsoft SQL Server 2012 database named ContosoDb. Tables are
defined as shown in the exhibit. (Click the Exhibit button.)
You need to display rows from the Orders table for the Customers row having the
CustomerId value set to 1 in the following XML format.
Which Transact-SQL query should you use?
You need to develop this project with the least amount of development effort
You are developing a SQL Server Integration Services (SSIS) project that contains a project
Connection Manager and multiple packages.
All packages in the project must connect to the same database. The server name for the
database must be set by using a parameter named ParamConnection when any package in
the project is executed.
You need to develop this project with the least amount of development effort.
What should you do? (Each answer presents a part of the solution. Choose all that apply.)
Which Transact-SQL query should you use?
You administer a Microsoft SQL Server 2012 database named ContosoDb. Tables are
defined as shown in the exhibit. (Click the Exhibit button.)
You need to display rows from the Orders table for the Customers row having the
CustomerId value set to 1 in the following XML format.
Which Transact-SQL query should you use?