Free Microsoft 070-463 Exam Dumps Questions & Answers

You have a server named SQL1 that has SQL Server Integration Services (SSIS) installed. SQL1 has eight CPUs, 8 GB of RAM, RAID-10 storage, and a 10-gigabit Ethernet connection.
A package named Package1 runs on SQL1. Package1 contains 10 data tasks. Package1 queries 3 GB of data from the source system.
You review the performance statistics on SQL1 and discover that Package1 executes slower than expected.
You need to identify the problem that is causing Package1 to execute slowly.
Which performance monitor counter data should you review?

• A.  SQLServer:SSIS Pipeline 10.0: Flat butter memory
• B.  Memory\Pages/sec
• C.  SQLServer:SSIS Pipeline 10.0: Buffers in use
• D.  SQLServer: SSIS Pipeline 10.0:Private buffer memory

NO: 204
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.
What should you do?

• A.  Open a command prompt and run the dtutil/copy command.
• B.  Open a command prompt and run the gacutil command.
• C.  Use an msi file to deploy the package on the server.
• D.  Add an OnError event handler to the SSIS project.

You are designing a data warehouse that uses SQL Server 2012.
The data warehouse contains a table named factSales that stores product sales. The table has a clustered index on the primary key, four foreign keys to dimension tables, and an aggregate column for sales totals. All key columns use the INT data type, and the aggregate column uses the MONEY data type.
You need to increase the speed of data retrieval from the factSales table.
Which index type should you add to the table?

• A.  Full text
• B.  Spatial
• C.  Non-clustered
• D.  Clustered

You are using the Master Data Services (MDS) Add-in for Excel to configure the entities in a model. The model consists of two entities: one named Customer and one named State. You open the Customer entity.
Currently, data stewards can enter any text value in the Customer entity's State attribute. You must restrict the entry of values in the State attribute to members defined in the State entity.
You need to configure the State attribute of the Customer entity.
Which option should you use? (To answer, select the appropriate area in the answer area.)

Correct Answer:

Explanation

You administer a Microsoft SQL Server database. Service accounts for SQL Agents are configured to use a local user. A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server Agent job. The SSIS package accesses a network share when exporting data from a SQL Server database.
When you execute the SQL Server Agent job, it fails due to a permissions failure on a share on a remote server. You need to ensure that the SQL Server Agent job can execute the SSIS package. Which four 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.)

Correct Answer:

Explanation

References:
http://msdn.microsoft.com/en-us/library/ms175834.aspx
http://msdn.microsoft.com/en-us/library/ms189522.aspx
http://msdn.microsoft.com/en-us/library/ms190703.aspx
http://msdn.microsoft.com/en-us/library/ms161950.aspx