70-463 Exam Questions - Online Test

70-463 Premium VCE File

Learn More 100% Pass Guarantee - Dumps Verified - Instant Download
150 Lectures, 20 Hours

Want to know Pass4sure microsoft 70 463 Exam practice test features? Want to lear more about Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012 certification experience? Study High value Microsoft microsoft 70 463 answers to Update 70 463 dumps questions at Pass4sure. Gat a success with an absolute guarantee to pass Microsoft exam 70 463 (Implementing a Data Warehouse with Microsoft SQL Server 2012) test on your first attempt.

Q41. You are designing a data warehouse with two fact tables. The first table contains sales per 

month and the second table contains orders per day. 

Referential integrity must be enforced declaratively. 

You need to design a solution that can join a single time dimension to both fact tables. 

What should you do? 

A. Create a time mapping table. 

B. Partition the fact tables by day. 

C. Create a time dimension that can join to both fact tables at their respective granularity. 

D. Join the two fact tables. 

Answer: B 

Q42. You are deploying a new SQL Server Integration Services (SSIS) package to five servers. 

The package must meet the following requirements: 

. .NET Common Language Runtime (CLR) integration in SQL Server must not be enabled. . The Connection Managers used in the package must be configurable without 

editing and redeploying the package. 

. The deployment procedure must be automated as much as possible. 

. Performance must be maximized. 

You need to set up a deployment strategy that meets the requirements. 

What should you do? 

A. Add an OnError event handler to the SSIS project. 

B. Use an msi file to deploy the package on the server. 

C. Open a command prompt and run the gacutil command. 

D. Open a command prompt and run the dtutil /copy command. 

E. Open a command prompt and run the dtexec /rep /conn command. 

F. Open a command prompt and run the dtexec /dumperror /conn command. 

G. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility. 

H. Create a reusable custom logging component and use it in the SSIS project. 

I. Configure the SSIS solution to use the Project Deployment Model. 

J. Configure the output of a component in the package data flow to use a data tap. 

K. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server. 

Answer: D 

Q43. You are developing a SQL Server Integration Services (SSIS) package. 

OnError and OnWarning events must be logged for viewing in the built-in SSIS reports by 

using SQL Server Management Studio. 

You need to execute the package and minimize the number of event types that are logged. 

Which setting should you use? (To answer, change the appropriate setting in the answer 

area.) 

Answer: 

Q44. 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. Multicast 

B. Conditional Split 

C. Destination Assistant 

D. Script Task 

Answer: D 

Q45. You are designing a partitioning strategy for a large fact table in a data warehouse. Tens of millions of new records are loaded into the data warehouse weekly, outside of business hours. 

Most queries are generated by reports and by cube processing. Data is frequently queried at the day level and occasionally at the month level. 

You need to partition the table to maximize the performance of queries. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.) 

A. Partition the fact table by month, and compress each partition. 

B. Partition the fact table by week. 

C. Partition the fact table by year. 

D. Partition the fact table by day, and compress each partition. 

Answer: D 

Q46. Topic 2) 

You are the administrator for a Data Quality Server. You are adding a user who must have permission to: 

Edit and execute a project 

View the activity monitoring data 

This user must not be able to: 

Perform any kind of knowledge management 

Create or change a knowledge base 

Terminate an activity or perform administrative duties 

You need to develop a Transact-SQL (T-SQL) script to meet these requirements. 

What should you do? (To answer, drag the appropriate code segment or segments to the correct location or locations in the answer area.) 

Answer: 

Q47. You are editing a SQL Server Integration Services (SSIS) project named Project1 in SQL Server Data Tools. 

A package Connection Manager has been parameterized with project scope. 

You need to display the parameters that have been generated for the Connection Manager. 

What should you use? To answer, select the appropriate setting or settings in the answer area. 

Answer: 

Q48. You are installing the Data Quality Server component of Data Quality Services. 

You need to provision the hardware and install the software for the server that runs the 

Data Quality Server. 

You must ensure that the minimum Data Quality Server prerequisites are met. 

What should you do? 

A. Install SQL Server 2012 Database Engine. 

B. Install Microsoft SharePoint Server 2010 Enterprise Edition with PowerPivot. 

C. Make sure the server has at least 4 GB of RAM. 

D. Install Microsoft Internet Explorer 6.0 SP1 or later. 

Answer: A 

Explanation: Data Quality Server Minimum System Requirements 

* SQL Server 2012 Database Engine. 

* Memory (RAM): Minimum: 2 GB Recommended: 4 GB or more 

Note: SQL Server Data Quality Services (DQS) is a new feature in SQL Server 2012 that contains the following two components: Data Quality Server and Data Quality Client. 

Q49. You are developing a SQL Server Integration Services (SSIS) package. 

You need to design a package to change a variable value during package execution by using the least amount of development effort. 

What should you use? 

A. Expression task 

B. Script task 

C. Execute SQL task 

D. Execute Process task 

E. Term Extraction transformation 

Answer: A 

Reference: 

http://msdn.microsoft.com/en-us/library/hh213137.aspx 

Q50. You are developing a data flow transformation to merge two data sources. One source contains product data and the other source contains data about the country in which the product was manufactured. Both data sources contain a two-character CountryCode column and both use SQL Server. Both data sources contain an ORDER BY clause to sort the data by the CountryCode column in ascending order. 

You use a Merge Join transformation to join the data. 

You need to ensure that the Merge Join transformation works correctly without additional transformations. 

What should you do? (Each correct answer presents part of the solution. Choose all that apply.) 

A. Change the ORDER BY clause on the product source to order by ProductName. 

B. Change the Merge Join transformation to a Merge transformation. 

C. Set the appropriate SortKeyPosition properties on the data sources. 

D. Set the IsSorted property on both data sources. 

Answer: C,D