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

You need to configure the SSRS data source.
What should you do?

• A.Store the credentials.
• B.Create a .NET form to enable users to enter their credentials.
• C.Configure Kerberos authentication.
• D.In the data source configuration window, select the Prompt for credentials option.

You are developing a SQL Server Analysis Services (SSAS) multidimensional database.
The underlying data source does not have a time dimension table. You need to implement a time dimension.
What should you do?

• A.Use the SQL Server Data Tools Dimension Wizard and generate a time dimension by using the Use an existing table option.
• B.Use the SQL Server Data Tools Dimension Wizard and generate a time table on the server.
• C.Create a CSV file with time data and use the DMX IMPORT statement to import data from the CSV file.
• D.Create a time dimension by using the Define dimension intelligence option in the Business Intelligence Wizard.
• E.Create a time dimension by using the Define time intelligence option in the Business Intelligence Wizard.
• F.Add an existing SSAS database time dimension as a cube dimension.
• G.Create a script by using a sample time dimension from a different multidimensional database. Then create a new dimension in an existing multidimensional database by executing the script.
• H.Use the SQL Server Data Tools Dimension Wizard and generate a time table in the data source.

You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a data model.
Which role permission should you use?

• A.Administrator
• B.select
• C.Process
• D.Explorer
• E.Read
• F.Browser

You need to create the calculation for SalespersonName.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)

• A.Create a view in the data warehouse that defines a derived column based on the DimSalesperson table. Base the Sales Reporting model's Salesperson table on the view. Include the column in the Sales Reporting model's Salesperson table.
• B.Create a computed column in the data warehouse's DimSalesperson table. Include the column in the Sales Reporting model's Salesperson table.
• C.Modify the data warehouse's DimSalesperson table and add a new column. Use an UPDATE statement to populate the new column with values. Update the SSIS package developed to populate the data warehouse's DimSalesperson table to use a Derived Column transformation to produce the calculation.
• D.Configure the Sales Reporting model's Salesperson table properties to be based on a query. Define a derived column in the query.
• E.Add a calculated column to the Sales Reporting model's Salesperson table by using the Data Analysis Expressions (DAX) language CONCATENATE function.
• F.Add a calculated column to the Sales Reporting model's Salesperson table by using the Data Analysis Expressions (DAX) language ADDCOLUMNS function.

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations.
You need to hide the tables and columns.
What should you do?

• A.Right-click the applicable tables and columns and select the Hide from Client Tools option.
• B.in the Properties window for the applicable tables and columns, set the Enabled property to False.
• C.Right-click the applicable tables and columns and select the Hide option.
• D.in the Properties window for the applicable tables and columns, set the Visible property to True.