QUESTION NO: 1
You need to create the Sales Reporting shared SSRS data source.
Which SSRS data connection type should you use?
You need to create the Sales Reporting shared SSRS data source.
Which SSRS data connection type should you use?
Correct Answer: B
Vote an answer
QUESTION NO: 2
You need to select an appropriate tool for creating the Regional Sales report.
Which tool or tools should you use? (Each correct answer presents a complete solution. Choose all that apply.)
You need to select an appropriate tool for creating the Regional Sales report.
Which tool or tools should you use? (Each correct answer presents a complete solution. Choose all that apply.)
Correct Answer: B,C,D
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 3
You are designing a self-service business intelligence and reporting environment.
Business analysts will create and publish PowerPivot for Microsoft Excel workbooks and create reports by using SQL Server Reporting Services (SSRS) and Power View. When the data models become more complex and the data volume increases, the data models will be replaced by IT-hosted server-based models.
You have the following requirements:
* Maintain the self-service nature of the reporting environment.
* Reuse existing reports.
* Add calculated columns to the data models.
You need to create a strategy for implementing this process.
What should you do?
To answer, drag the appropriate term or terms to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)
You are designing a self-service business intelligence and reporting environment.
Business analysts will create and publish PowerPivot for Microsoft Excel workbooks and create reports by using SQL Server Reporting Services (SSRS) and Power View. When the data models become more complex and the data volume increases, the data models will be replaced by IT-hosted server-based models.
You have the following requirements:
* Maintain the self-service nature of the reporting environment.
* Reuse existing reports.
* Add calculated columns to the data models.
You need to create a strategy for implementing this process.
What should you do?
To answer, drag the appropriate term or terms to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)
Correct Answer:
Explanation
Box 1: Import
Box 2: tabular
Box 3: Deploy
Box 4: Modify
You can see that the audiences for these two approaches are different: Tabular models are for IT professionals, while PowerPivot models are for business users. And keep in mind you can import a PowerPivot workbook to create a new tabular product. For example, a business user might create a solution using PowerPivot. By restoring the workbook, IT can add features that are not supported in PowerPivot, such as roles to grant read permission to different groups of users. Additionally, recognition by IT that the model is important to the organization may prompt them to import the workbook into a tabular project and take ongoing responsibility for developing the model.
QUESTION NO: 4
A company maintains separate environments for development, test, and production. The company uses the project deployment model for SQL Server Integration Services (SSIS) deployments.
You create an SSIS project to perform a daily refresh of the data warehouse and data models. The project has five packages.
You need to configure the project to ensure that the development, test, and production teams can run each package without manually adding server-specific information.
Which program should you use?
To answer, select the appropriate program in the answer area.
A company maintains separate environments for development, test, and production. The company uses the project deployment model for SQL Server Integration Services (SSIS) deployments.
You create an SSIS project to perform a daily refresh of the data warehouse and data models. The project has five packages.
You need to configure the project to ensure that the development, test, and production teams can run each package without manually adding server-specific information.
Which program should you use?
To answer, select the appropriate program in the answer area.
Correct Answer:
Explanation
QUESTION NO: 5
You develop a SQL Server Integration Services (SSIS) project named Project1 by using SQL Server Data Tools (SSDT). Project1 contains a package named Package1.
You add a project parameter named EnvironmentText to Project1.
In SQL Server Management Studio (SSMS), you create the SSIS catalog.
You have the following requirements:
* Configure Package1 so it can run within either a development environment or a test environment.
* Pass the value of an SSIS environment variable to the EnvironmentText project parameter.
* The value of the environment variable must be different for each SSIS environment.
You need to deploy the SSIS project and configure the SSIS environment.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
You develop a SQL Server Integration Services (SSIS) project named Project1 by using SQL Server Data Tools (SSDT). Project1 contains a package named Package1.
You add a project parameter named EnvironmentText to Project1.
In SQL Server Management Studio (SSMS), you create the SSIS catalog.
You have the following requirements:
* Configure Package1 so it can run within either a development environment or a test environment.
* Pass the value of an SSIS environment variable to the EnvironmentText project parameter.
* The value of the environment variable must be different for each SSIS environment.
You need to deploy the SSIS project and configure the SSIS environment.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Correct Answer:
Explanation
Box 1:
Box 2:
Box 3:
QUESTION NO: 6
You need to extend the schema design to store the product dimension data.
Which design should you use?
To answer, drag the appropriate table or tables to the correct location or locations in the answer area. (Fill from left to right. Answer choices may be used once, more than once, or not all.)
You need to extend the schema design to store the product dimension data.
Which design should you use?
To answer, drag the appropriate table or tables to the correct location or locations in the answer area. (Fill from left to right. Answer choices may be used once, more than once, or not all.)
Correct Answer:
Explanation
/ The schema design must be extended to include the product dimension data.
* DimProduct table need to contain a foreign key to the DimSubCategory table. No further SubCategory data should be stored in the DimProduct table.
* No time related columns (StartDate, EndDate) should be included in the DimProduct table.
QUESTION NO: 7
You need to design the dimCustomers table.
Which design approach should you use?
You need to design the dimCustomers table.
Which design approach should you use?
Correct Answer: C
Vote an answer
QUESTION NO: 8
You have a nightly process that loads millions of rows from an AS/400 system to a SQL Server Analysis Services (SSAS) cube. You need to design a partitioning strategy to ensure that new information can be added without reprocessing the entire cube. Which processing option should you use?
You have a nightly process that loads millions of rows from an AS/400 system to a SQL Server Analysis Services (SSAS) cube. You need to design a partitioning strategy to ensure that new information can be added without reprocessing the entire cube. Which processing option should you use?
Correct Answer: A
Vote an answer
QUESTION NO: 9
You need to re-establish subscriptions on SSRS01.
What should you do?
You need to re-establish subscriptions on SSRS01.
What should you do?
Correct Answer: C
Vote an answer
QUESTION NO: 10
You need to prepare the infrastructure for the planned implementation of Gallery1.
Which three actions should you perform? Each correct answer presents part of the solution,
You need to prepare the infrastructure for the planned implementation of Gallery1.
Which three actions should you perform? Each correct answer presents part of the solution,
Correct Answer: A,B,F
Vote an answer
QUESTION NO: 11
You need to ensure that the Sales Per Capita calculated measure produces correct results.
What should you do?
You need to ensure that the Sales Per Capita calculated measure produces correct results.
What should you do?
Correct Answer: D
Vote an answer
QUESTION NO: 12
You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic.
You have the following requirements:
* Ensure that queries of the data model correctly display average student age by class and average class level by student.
* Minimize development effort.
You need to design the data model.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic.
You have the following requirements:
* Ensure that queries of the data model correctly display average student age by class and average class level by student.
* Minimize development effort.
You need to design the data model.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Correct Answer: B
Vote an answer
QUESTION NO: 13
You need to design a data warehouse schema to support a multidimensional cube. The fact table will contain multiple columns representing order dates, shipping dates, and billing dates. The cube will contain a measure group based on the fact table.
What is the best design to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.
You need to design a data warehouse schema to support a multidimensional cube. The fact table will contain multiple columns representing order dates, shipping dates, and billing dates. The cube will contain a measure group based on the fact table.
What is the best design to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.
Correct Answer: A
Vote an answer
QUESTION NO: 14
You are validating whether a SQL Server Integration Services (SSIS) package named Master.dtsx in the SSIS catalog is executing correctly.
You need to display the number of rows in each buffer passed between each data flow component of the package.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
You are validating whether a SQL Server Integration Services (SSIS) package named Master.dtsx in the SSIS catalog is executing correctly.
You need to display the number of rows in each buffer passed between each data flow component of the package.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Correct Answer:
Explanation
Box 1:
Box 2:
Box 3:
Note:
* You are going to become very very familiar indeed with [catalog].[executions]. It is a view that provides a record of all package executions on the server and, most importantly, it contains [execution_id] - the identifier for each execution and the field to which all other objects herein will be related.