Microsoft 70-463 Exam Questions Instant Access

Question 1

A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database database.

To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP website instead of from a weekly flat file. The public website hosts a comma-separated values (CSV) file that contains one row per currency.

You need to download the CSV file to the environment.

What should you use to retrieve the document from the website?

Aa Script component

Ba Web Service task

Ca Web Service source

Da Script task

Answer : A

Question 2

Answer : B

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

Question 3

You are designing a SQL Server Integration Services (SS1S) package that uploads a file to a table named Orders in a SQL Azure database.

The company's auditing policies have the following requirements:

* An entry must be written to a dedicated SQL Server log table named OrderLog.

* The entry must be written as soon as the file upload task completes.

You need to meet the company's policy requirements. Which event handler should you use?

AOnProgress

BOnlnformation

COnPostExecute

DOnComplete

Answer : C

Question 4

You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted on Windows Azure SQL Database. The package contains a data flow task that has 10 source-to-destination execution trees.

Only five of the source-to-destination execution trees are running in parallel.

You need to ensure that all the execution trees run in parallel.

What should you do?

AAdd OnError and OnWarning event handlers.

BCreate a new project and add the package to the project.

CQuery the ExecutionLog table.

DAdd an Execute SQL task to the event handlers.

Answer : A

Question 5

You are developing a SQL Server Integration Services (SSIS) package that imports data from a relational database to a data warehouse.

You are importing data from a relational table named Projects. The table has change data capture enabled on all columns.

You need to process only the most recent values from rows that have been inserted or updated since the previous execution of the package.

Which query should you use as the data source?

AOption A

BOption B

COption C

DOption D

Answer : D

Question 6

You are designing a data warehouse that contains a customer dimension.

The customer dimension contains the original customer attributes as well as the most recent set of updated attributes. When a customer is updated, the original customer attributes must be preserved.

The customer dimension design must:

Support a Type 3 Slowly Changing Dimension (SCD) process

Minimize the total storage consumed

You need to design a solution that meets these requirements.

What should you do?

ADesign two tables. One table will hold the original customer surrogate key and attributes. The other table will hold the most recent customer surrogate key and attributes.

BDesign a table as a Type 2 SCD dimension that holds the surrogate key for each customer and its attributes. Limit the number of records per customer within the table to two.

CDesign a table to hold the surrogate key for each customer and its attributes. Add a column to store an indicator that identifies the record as original data or recent data.

DDesign a table to hold the surrogate key for each customer and its attributes as well as additional columns to store the original attributes.

Answer : D

Question 7

Which of the following T-SQL functions is not very useful for capturing lineage information?

AAPP_NAME()

BUSER_NAME()

CDEVICE_STATUS()

DSUSER_SNAME()

Answer : C

Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 70-463 Exam Questions