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

You develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is regularly executed within a multi-step SQL Server Agent job.
You make changes to the package that should improve performance.
You need to establish if there is a trend in the durations of the next 10 successful executions of the package.
You need to use the least amount of administrative effort to achieve this goal.
What should you do?

• A.Enable logging to an XML file in the package control flow for the Onlnformation event. After 10 executions, view the XML file.
• B.After 10 executions, view the job history for the SQL Server Agent job.
• C.After 10 executions, in SQL Server Management Studio, view the Execution Performance subsection of the All Executions report for the package.
• D.Enable logging to an XML file in the package control flow for the OnPostExecute event. After 10 executions, view the XML file.

You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day.
Referential integrity must be enforced declaratively.
You need to design a solution that can join a single time dimension to both fact tables.
What should you do?

• A.Change the level of granularity in both fact tables to be the same.
• B.Merge the fact tables.
• C.Create a view on the sales table.
• D.Create a time mapping table.

You plan to deploy a package to a server that has SQL Server installed. The server contains a SQL Server Integration Services (SSIS) catalog.
You need to ensure that the package credentials are encrypted.
Which protection level should you set for the package?

• A.EncryptSensitivewithUserKey
• B.EncryptSensitivewithPassword
• C.ServerStorage
• D.EncryptAllWithUserKey

NO: 210
In your ETL process, there are three external processes that need to be executed in sequence, but you do not want to stop execution if any of them fails.
Can this be achieved by using precedence constraints? If so, which precedence constraints can be used?

• A.No, this cannot be achieved just by using precedence constraints.
• B.Yes, this can be achieved by using completion precedence constraints between the first and the second and between the second and the third Execute Process tasks, and by using a success precedence constraint between the third Execute Process task and the following task.
• C.Yes, this can be achieved by using completion precedence constraints between the first and the second, between the second and the third, and between the third Execute Process task and the following task.
• D.Yes, this can be achieved by using failure precedence constraints between the first and the second, and between the second and the third Execute Process tasks, and by using a completion precedence constraint between the third Execute Process task and the following task.

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?

• A.Design a table to hold the surrogate key for each customer and its attributes as well as additional columns to store the original attributes.
• B.Design 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.
• C.Design 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.
• D.Design 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.