70-463 무료 덤프문제 온라인 액세스

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 developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on ServerA. The package includes a data flow and is executed on ServerB. The destination table has its own identity column.
The destination data load has the following requirements:
* The identity values from the source table must be used.
* Default constraints on the destination table must be ignored.
* Batch size must be 100,000 rows.
You need to add a destination and configure it to meet the requirements.
Which destination should you use?

• A.OLE DB Destination without Fast Load
• B.ADO NET Destination without Bulk Insert
• C.OLE DB Destination with Fast Load
• D.ADO NET Destination with Bulk Insert
• E.SQL Server Destination

You are designing an enterprise star schema that will consolidate data from three independent data marts. One of the data marts is hosted on SQL Azure.
Most of the dimensions have the same structure and content. However, the geography dimension is slightly different in each data mart.
You need to design a consolidated dimensional structure that will be easy to maintain while ensuring that all dimensional data from the three original solutions is represented.
What should you do?

• A.Create three geography dimensions.
• B.Create a junk dimension for the geography dimension.
• C.Implement change data capture.
• D.Create a conformed dimension for the geography dimension.

You are developing a SQL Server Integration Services (SSIS) project to read and write data from a Windows Azure SQL Database database to a server that runs SQL Server 2012.
The connection will be used by data flow tasks in multiple SSIS packages. The address of the target Windows Azure SQL Database database will be provided by a project parameter.
You need to create a solution to meet the requirements by using the least amount of administrative effort and maximizing data flow performance.
What should you do?

• A.Create a SQL Common Language Runtime (SQLCLR) function that uses the custom assembly to parse the text data, deploy it in the Windows Azure SQL Database database, and use it when inserting data.
• B.Create a SQL Common Language Runtime (SQLCLR) stored procedure that uses the custom assembly to parse the text data, deploy it in the Windows Azure SQL Database database, and use it when inserting data.
• C.Use an SSIS Script task that uses the custom assembly to parse the text data when inserting it.
• D.Use an SSIS Script transformation that uses the custom assembly to parse the text data when inserting it.

You use SQL Server Integration Services (SSIS) for extract, transformation, load (ETL) processing.
Issues concerning addresses are discovered in the data warehouse that you manage. Validation must separate the addresses into three categories:
* Valid addresses
* Autocorrected addresses
* Invalid addresses
You need to enhance the SSIS packages to perform address validation by using an external service.
Which transformation should you use? (To answer, drag the appropriate transformation from the list of options to the correct location or locations in the answer area.)

정답:

Explanation