Which Transact-SQL query should you use?
You have a Microsoft SQL Server 2012 database that contains tables named Customers and Orders.
The tables are related by a column named CustomerID.
You need to create a query that meets the following requirements:
Returns the CustomerName for all customers and the OrderDate for any orders that they have
placed.
Results must include customers who have not placed any orders.
Which Transact-SQL query should you use?
Which two actions should you perform?
You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package performs the following tasks:
Processes multiple files by using a ForEach Loopcontainer.
Imports the contents of the files to a table by using a Data Flowtask.
Logs the results of the status into a table by using an Execute SQL task.
You need to ensure that all the tasks of the package except the Execute SQL task execute
within a single transaction.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)
You need to reconfigure the mirroring strategy to minimize the risk of database unavailability
You administer a SQL Server 2008 instance. The instance hosts a database configured by
using highsafety mirroring operation mode along with a witness server. The witness server
is experiencing memory failure and will be offline for four hours. You need to reconfigure the
mirroring strategy to minimize the risk of database unavailability. What should you do?
You need to ensure that only users that belong to an appropriate database role can modify and execute the depl
You design a package by using SQL Server 2008 Integration Services (SSIS). The package
is designed by using your local development environment.
The package extracts data from a remote server and inserts it in the PROD database on the
local SQL Server 2008 instance. You deploy the package to the MSDB database on the
production server.
You need to ensure that only users that belong to an appropriate database role can modify
and execute the deployed package. You also need to ensure that these users cannot access
other packages that are deployed to the server.
What should you do?
You need to ensure that the package executes successfully in the production environment
You develop a package by using SQL Server 2008 Integration Services (SSIS).
You use a local instance of SSIS to develop and test the package.
The package uses an XML configuration file that contains a connection string. The
connection string includes a user name and a password to connect to the source data.
You deploy the package to the production server. You discover that validation errors occur
when the package is being executed.
You need to ensure that the package executes successfully in the production environment.
What should you do?
You need to ensure that if the package executes during a failover, the package can be resumed at the point of
You plan to use SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover
cluster. You have a complex package that takes a long time to run. You need to ensure that
if the package executes during a failover, the package can be resumed at the point of failure.
What should you do?
Which object should you create first?
You need to create a Service Broker solution. Which object should you create first?
You need to design a replication strategy to minimize latency
You administer a SQL Server 2008 instance. The instance is one of three servers in a
peer-to-peer transactional replication topology. The publication contains a table named
Orders. The Orders table contains 200 GB of data across multiple partitions. A batch
process bulk loads 10 GB of data to the Orders table periodically. You need to design a
replication strategy to minimize latency. What should you do?
You need to configure the package to restart at the point of failure after the package downloads the files
You develop a SQL Server 2008 Integration Services (SSIS) package.
The package downloads several files from a remote FTP server by using multiple FTP tasks,
and then processes data by using multiple Execute SQL tasks.
You need to configure the package to restart at the point of failure after the package
downloads the files.
What should you do?
You need to ensure that data-driven subscriptions successfully execute for this report
You develop a SQL Server 2008 Reporting Services (SSRS) report.
The report uses the “User!UserID” expression in a text box within the report header.
You need to ensure that data-driven subscriptions successfully execute for this report.
What should you do?