Microsoft 070-458 Value Pack (Frequently Bought Together)

You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on Windows Azure SQL Database. One of the columns in the data source is named ProductCode.
Some of the data to be loaded will reference products that need special processing logic in the data flow.
You need to enable separate processing streams for a subset of rows based on the source product code.
Which Data Flow transformation should you use?

• A. Conditional Split
• B. Multicast
• C. Source Assistant
• D. Script Task

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that downloads data from a Windows Azure SQL Database database.
A stored procedure will be called in an Execute SQL task by using an ODBC connection. This stored procedure has only the rustomerlD parameter of type INT.
A project parameter named CustID will be mapped to the stored procedure parameter @CustomerID.
You need to ensure that the value of the CustID parameter is passed to the @CustomerID stored procedure parameter.
In the Parameter Mapping tab of the Execute SQL task editor, how should you configure the parameter? (To answer, drag the appropriate option or options to the correct location or locations in the answer area.)

You are creating a Data Quality Services (DQS) solution. You must provide statistics on the accuracy of the data.
You need to use DQS profiling to obtain the required statistics.
Which DQS activity should you use?

• A. Knowledge Discovery
• B. Matching
• C. Matching Policy
• D. Cleansing

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database.
The recovery model and backup schedule are configured as shown in the following table: One of the hard disk drives chat stores the transactional database fails at 23:32 hours. Attempts to create a tail log backup are unsuccessful.

You need to ensure that the transactional database is restored. You also need to ensure that data loss is minimal,
What should you do?

• A. Restore the latest full backup. Then, restore the latest differential backup.
• B. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.
• C. Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.
• D. Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup.
• E. Perform a partial restore.
• F. Restore the latest full backup.
• G. Perform a point-in-time restore.
• H. Perform a page restore.

You are the senior database administrator for a Microsoft SQL Server environment that uses Windows Azure SQL Database.
You need to grant a junior database administrator only the permissions required to create new logins.
Which Windows Azure SQL Database role should you assign the junior database administrator?

• A. securityadmin
• B. loginmanager
• C. setupadmin
• D. serveradmin