070-463 試験問題を無料オンラインアクセス

NO: 211
Reporting from a Star schema is simpler than reporting from a normalized online transactional processing (OLTP) schema.
What are the reasons for wanting simpler reporting? (Choose all that apply.)

• A.A Star schema is standardized and narrative; you can find the information you need for a report quickly.
• B.A Star schema typically has fewer tables than a normalized schema. Therefore, queries are simpler because they require fewer joins.
• C.A Star schema has better support for numeric data types than a normalized relational schema; therefore, it is easier to create aggregates.
• D.There are specific Transact-SQL expressions that deal with Star schemas.

Your team is creating SQL Server Integration Services (SSIS) packages that have several dependencies. The packages use parameters for configuration purposes.
Your company's IT policies include the following change control requirements:
* After a package is ready for deployment, your team must hand over the process to junior IT personnel.
* The process must guarantee that when a package has been validated, that same package (and all its dependencies) is deployed to production.
* The process must be repeatable and reliable and must be executed with the least administrative and training effort by junior IT personnel.
You need to use the most appropriate deployment unit to satisfy the company policies, while minimizing issues such as incorrect version or configuration.
Which type of deployment unit should you use?

• A.msi
• B.SSIS deployment manifest
• C.dtsx
• D.ispac

You are developing a SQL Server Integration Services (SSIS) package.
The package uses custom functionality that accesses a SQL Server database. The custom functionality must be implemented by using Language Integrated Query (LINQ).
You need to ensure that the LINQ code can be debugged at design time.
What should you select from the SSIS Toolbox? (To answer, drag the appropriate item to the correct location in the answer area.)

正解：

Explanation

You are designing an extract, transform, load (ETL) process for loading data from a SQL Server database into a large fact table in a data warehouse each day with the prior day's sales data.
The ETL process for the fact table must meet the following requirements:
* Load new data in the shortest possible time.
* Remove data that is more than 36 months old.
* Ensure that data loads correctly.
* Minimize record locking.
* Minimize impact on the transaction log.
You need to design an ETL process that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Partition the destination fact table by date. Insert new data directly into the fact table and delete old data directly from the fact table.
• B.Partition the destination fact table by date. Use partition switching and a staging table to remove old data. Insert new data directly into the fact table.
• C.Partition the destination fact table by customer. Use partition switching both to remove old data and to load new data into each partition.
• D.Partition the destination fact table by date. Use partition switching and staging tables both to remove old data and to load new data.

Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does not complete and nothing is processed.
You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts.
What should you do?

• A.Use the dtutil /copy command.
• B.Add a data tap on the output of a component in the package data flow.
• C.Run the package by using the dtexec /dumperror /conn command.
• D.Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.
• E.Run the package by using the dtexecui.exe utility and the SQL Log provider.
• F.Use the gacutil command.
• G.Run the package by using the dtexec /rep /conn command.
• H.Create a reusable custom logging component.
• I.Use the Project Deployment Wizard.
• J.Deploy the package by using an msi file.
• K.Create an OnError event handler.