Microsoft-Upgrade Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008

1.

You need to modify the Customer dimension table to support the design and reporting constraints. Certkey.com - Make You Succeed To Pass IT Exams Certkey 70-446 What should you do?

Add a version number to the Customer dimension table. Add a current version flag to the Customer dimension table. Add a tracking table to the BlueDW database to hold customer history. Add version start time and version end time to the Customer dimension table.

2.

You need to modify the SecurityAgencyLoad SSIS package to meet the audit trail requirements. What should you do?

Configure the Microsoft Windows Event Log logging provider. Use the OnPostExecute event of the task to capture the row count to log the Event Log. Use a row count transformation to store the total row count in a user variable. Configure a logging providerto use the variable to log the Microsoft Windows Event Log. Use an Execute SQL task to write a query to write the row count to a user variable.Configure a logging provider to use the variable to log the Microsoft Windows Event Log. Use a row count transformation to store the total row count in a user variable. Use a Script task to write thevalue of the variable to the DTS Log. Configure a logging provider to log the script task to the Microsoft Windows Event Log.

3.

You need to modify the PartnerAirmilesLoad SSIS package to avoid duplicate customers in the BlueCRM system. Which SSIS transformation task should you use?

Sort Pivot Fuzzy Grouping Conditional Split

4.

You need to reduce the duration of the daily full database backup process. What should you do?

Perform transaction log backups every 30 minutes throughout the day. Partition the Transaction table by a range based on the TransactionID. Daily, back up only the file groupsthat have changed. Place the Transaction table in its own file group. Back up the Transaction table and the remaining filegroups each evening. Partition the Transaction table by a range based on the MortgageID. Daily, back up only the file groups thathave changed.

5.

You need to redesign the TicketSalesByFlight report. Which component should you use?

Bookmarks Drilldown Drillthrough Document Map

6.

You need to modify the Executive Dashboard suite reports to allow testing to occur per the requirements. What should you do?

Create a single shared data source of type XML. Replace the connection string with an expression. Create a Report database and a ReportTempDB database on each SQL Server. Install reporting services on each of the SQL Server machines. Create an embedded report-specific data source of type SQL Server. Replace the connection string with anexpression. Repeat for all reports.

7.

You need to identify the data mining algorithm that meets the requirements of the credit department. Certkey.com - Make You Succeed To Pass IT Exams Certkey 70-446 Which algorithm should you use?

Microsoft Clustering Microsoft Decision Tree Microsoft Nave Bayes Microsoft Association

8.

You need to deliver the three reports that detail the previous days transaction activity. What should you do?

Create a new report that has three embedded subreports. Create one standard subscription. Create three new reports based on the same dataset. Create one data-driven subscription. Create three data-driven subscriptions on a single shared schedule. Ensure that the e-mail recipient list isidentical across all three subscriptions. Create three standard subscriptions on a single shared schedule. Ensure that the mail recipient list andsubject are identical across all three subscriptions.

9.

You need to meet the fraud detection requirements. What should you do?

Use Percentage Sampling in SSIS. Use a Neural Network Data mining algorithm. Create an SSAS Key Performance Indicator for each account. Monitor transactions by using SQL Server Profiler.

10.

You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use?

Custom event handlers Data flow error output SSIS log provider for SQL Server Execute SQL tasks with failure precedence constraints

Microsoft-Upgrade Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

Microsoft-Upgrade Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner