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

You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to update only the Products dimension while processing the cube by using an XML for Analysis
(XMLA) script.
You need to ensure that only the dimensions are updated.
What should you do?

• A.Execute a processIndex command.
• B.Execute a processUpdate command.
• C.Execute a processStructure command.
• D.Execute a processDefault command.

You plan to use SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover cluster.
You have a complex package that takes a long time to run.
You need to ensure that if the package executes during a failover, the package can be resumed at the point
of failure.
What should you do?

• A.Cluster the SSIS service. Add the SSIS service to the SQL Server cluster resource group.
• B.Implement transactions within your package. Restart the package whenever a failover occurs.
• C.Implement checkpoints within your package. Restart the package whenever a failover occurs.
• D.Cluster the SSIS service. Add the SSIS service to its own cluster resource group.

You maintain a SQL Server Analysis Services (SSAS) database. The database is configured by using
multiple security roles.
The database is accessed by a Microsoft ASP.NET application that runs on a remote computer. The
application is configured to use Windows Authentication.
You need to ensure that the users of the application can successfully access the SSAS database. You also
need to ensure that security restrictions of the roles are applied.
What should you do?

• A.Set the AnonymousConnectionsEnabled policy to True.
• B.Configure Kerberos authentication.
• C.Configure Analysis Services for HTTP authentication.
• D.Set the Security\RequireClientAuthentication property to True.

You have a SQL Server 2008 R2 Analysis Services (SSAS) solution.
You add a new Data Source View (DSV) to the solution. The DSV includes a SalesOrder table with columns for OrderTotal and CostTotal.
You need to derive the profit for each order without modifying the underlying data.
What should you do?

• A.Add a Named Calculation to the SalesOrder table, using OrderTotal CostTotal as the expression.
• B.Add a Named Calculation to the SalesOrder table, using OrderTotal + CostTotal as the expression.
• C.Create a view, SalesProfit, as Select * from SalesOrder.
• D.Add a Named Query to the DSV, using Select *,OrderTotal CostTotal from SalesOrder as the expression.
• E.Create a view, SalesProfit, as Select *, OrderTotal CostTotal as Profit from SalesOrder.
• F.Add a Named Query to the DSV and then ass a Named Calculation to that query, using OrderTotal -CostTotal as the expression.
• G.Add a Named Query to the DSV, using Select * from SalesOrder as the expression.
• H.Add a Named Calculation to the SalesOrder table, using OrderTotal,CostTotal as the expression.

You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a Product dimension.
The dimension contains the Category and Subcategory attributes.
The attributes have a Rigid relationship typE.The data source for the Product dimension changes the
relationship between the Category and Subcategory values.
You need to execute an XML for Analysis (XMLA) command to process the dimension to successfully
reflect the changE.What should you do?

• A.Use the ProcessUpdate command.
• B.Use the ProcessAdd command.
• C.Use the ProcessIndexes command.
• D.Use the ProcessClear and the ProcessDefault commands.