070-467 무료 덤프문제 온라인 액세스

You need to create the factCustomerContact table.
Which type of table should you create?

• A.A factless fact table
• B.A fact table with a non-additive measure
• C.A fact table with an additive measure
• D.A periodic snapshot fact table

You are creating a product dimension table and a SQL Server Integration Services (SSIS) package that will load the table.
You need to keep a history in the table of changes to the names of products.
Which three actions should you perform? Each correct answer presents part of the solution.

• A.Create an end date column in the table.
• B.Create an inferred member column in the table.
• C.Create a start date column in the table.
• D.Enable Change Data Capture for the table.
• E.From the Slowly Changing Dimension Wizard, set the name column to Type 3.
• F.Add a Slowly Changing Dimension transformation to the package.

You need to configure the LoadFactFreightCosts package to address the data integrity issues.
Which data flow component should you use?
To answer, drag the appropriate data flow component to the answer area.

정답:

Explanation

You need to restrict access to data in the tables in the data warehouse.
What should you do?

• A.Create views and grant permissions to the views.
• B.Configure column-level permissions.
• C.Configure database roles.
• D.Configure application roles.

You need to implement the Customer Sales and Manufacturing data models.
What should you do? (Each correct answer presents a partial solution. Choose all that apply.)

• A.Use SQL Server Integration Services (SSIS) to copy the database design to the SSAS instance, and specify tabular mode as the destination.
• B.Use SQL Server Data Tools (SSDT) to redevelop and deploy the projects.
• C.Install a new instance of SSAS in tabular mode.
• D.Use the current SSAS instance.
• E.Use the Database Synchronization Wizard to upgrade the database to tabular mode.