70-463 Exam Questions - Online Test

70-463 Premium VCE File

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

Your success in Microsoft exam 70 463 is our sole target and we develop all our 70 463 training kit pdf braindumps in a way that facilitates the attainment of this target. Not only is our exam 70 463 study material the best you can find, it is also the most detailed and the most updated. 70 463 dumps Practice Exams for Microsoft SQL Server 70 463 training kit pdf are written to the highest standards of technical accuracy.

Q31. You are developing a SQL Server Integration Services (SSIS) package. The data source for the data flow task is a table that has been configured as a change data capture (CDC) table. You are using a CDC Source component to obtain the CDC data. 

The data source will be polled once per hour. The data is updated with multiple important status changes per minute. 

For each captured data change, the before and after values must be included. 

You need to configure the CDC Source component. 

Which CDC processing mode should you select? (To answer, configure the appropriate option in the dialog box in the answer area.) 

Answer: 

Q32. You are designing a data warehouse hosted on Windows Azure SQL Database. The data warehouse currently includes the dimUser and dimRegion dimension tables and the factSales fact table. The dimUser table contains records for each user permitted to run reports against the warehouse, and the dimRegion table contains information about sales regions. 

The system is accessed by users from certain regions, as well as by area supervisors and users from the corporate headquarters. 

You need to design a table structure to ensure that certain users can see sales data for only certain regions. Some users must be permitted to see sales data from multiple regions. 

What should you do? 

A. For each region, create a view of the factSales table that includes a WHERE clause for the region. 

B. Create a userRegion table that contains primary key columns from the dimUser and dimRegion tables. 

C. Add a region column to the dimUser table. 

D. Partition the factSales table on the region column. 

Answer: D 

Q33. You are creating a SQL Server Integration Services (SSIS) package that implements a Type 3 Slowly Changing Dimension (SCD). 

You need to add a task or component to the package that allows you to implement the SCD logic. 

What should you use? 

A. a Data Conversion component 

B. an Execute SQL task that executes a MERGE statement on the database 

C. a Merge component 

D. an Expression task 

Answer: C 

Explanation: Note: Type of Slowly Changing Dimensions Slowly Changing Dimensions are categorized into three types named: Type 1, Type 2, and Type3. The Type 1 SCD does not maintain the history of changing attributes, it overwrites values of the attributes. Type 2 maintains historical values for changing attributes. Type 3 that we do not use much maintains separate columns for changed attributes. SSIS SCD wizard supports both Type 1 and Type 2. Using MERGE instead of SCD wizard Replacement of SCD wizard with MERGE is not a straightforward technique. If the SCD has both Type 1 and Type 2 types attributes, they need to be handled separately. 

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

The package sources data from an HTML web page that lists product stock levels. 

You need to implement a data flow task that reads the product stock levels from the HTML web page. 

Which data flow source should you use? 

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

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

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

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

Answer: B 

Q35. 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 Microsoft Internet Explorer 6.0 SP1 or later. 

B. Install SQL Server 2012 Database Engine. 

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

D. Install Microsoft SharePoint Server 2010 Standard Edition. 

Answer: B 

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. 

Q36. You are the data steward for a Business Intelligence project. 

You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been created to support this project. 

You need to produce the CSV file with the least amount of development effort. 

What should you do? 

A. Create an Integration Services package and use a Fuzzy Lookup transform. 

B. Create a Master Data Services (MDS) model. 

C. Create a Data Quality Project. 

D. Create an Integration Services package and use a DQS Cleansing transform. 

E. Create an Integration Services package and use a Fuzzy Grouping transform. 

Answer: D 

Explanation: The DQS Cleansing transformation uses Data Quality Services (DQS) to correct data from a connected data source, by applying approved rules that were created for the connected data source or a similar data source. To determine whether the data has to be corrected, the DQS Cleansing transformation processes data from an input column when the following conditions are true: 

* The column is selected for data correction. 

* The column data type is supported for data correction. 

* The column is mapped a domain that has a compatible data type. 

* The transformation also includes an error output that you configure to handle row-level errors 

Q37. You are creating a sales data warehouse. When a product exists in the product dimension, you update the product name. When a product does not exist, you insert a new record. 

In the current implementation, the DimProduct table must be scanned twice, once for the insert and again for the update. As a result, inserts and updates to the DimProduct table take longer than expected. 

You need to create a solution that uses a single command to perform an update and an insert. 

How should you use a MERGE T-SQL statement to accomplish this goal? (To answer, drag the appropriate answer choice from the list of options to the correct location or locations in the answer area. 

You may need to drag the split bar between panes or scroll to view content.) 

Answer: 

Q38. You are building a fact table in a data warehouse. 

The table must have a columnstore index. The table cannot be partitioned. 

You need to design the fact table and load it with data. 

Which three actions should you perform in sequence? (To answer, move the appropriate 

actions from the list of actions to the answer area and arrange them in the correct order.) 

Answer: 

Q39. You are designing a data warehouse for a software distribution business that stores sales by software title. It stores sales targets by software category. Software titles are classified into subcategories and categories. Each software title is included in only a single software subcategory, and each subcategory is included in only a single category. The data warehouse will be a data source for an Analysis Services cube. 

The data warehouse contains two fact tables: 

. factSales, used to record daily sales by software title 

. factTarget, used to record the monthly sales targets by software category 

Reports must be developed against the warehouse that reports sales by software title, category and subcategory, and sales targets. 

You need to design the software title dimension. The solution should use as few tables as possible while supporting all the requirements. 

What should you do? 

A. Create three software tables, dimSoftware, dimSoftwareCategory, and dimSoftwareSubcategory and a fourth bridge table that joins software titles to their appropriate category and subcategory table records with foreign key constraints. Direct the cube developer to use key granularity attributes. 

B. Create three software tables, dimSoftware, dimSoftwareCategory, and dimSoftwareSubcategory. Connect factSales to all three tables and connect factTarget to dimSoftwareCategory with foreign key constraints. Direct the cube developer to use key granularity attributes. 

C. Create one table, dimSoftware, which contains Software Detail, Category, and Subcategory columns. Connect factSales to dimSoftware with a foreign key constraint. Direct the cube developer to use a non-key granularity attribute for factTarget. 

D. Create two tables, dimSoftware and dimSoftwareCategory. Connect factSales to dimSoftware and factTarget to dimSoftwareCategory with foreign key constraints. Direct the cube developer to use key granularity attributes. 

Answer: C 

Q40. You are validating whether a SQL Server Integration Services (SSIS) package named Master.dtsx in the SSIS catalog is executing correctly. 

You need to display the number of rows in each buffer passed between each data flow component of the package. 

Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.) 

Answer: