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

You are responsible for installing new database server instances.
You must install Microsoft SQL Server Analysis Services (SSAS) to support deployment of the following projects.
You develop both projects by using SQL Server Data Tools.
You need to install the appropriate services to support both projects.
Which two actions should you perform? Each correct answer presents part of the solution.

• A.Install two separate tabular instances of SSAS.
• B.Install a multidimensional instance and a Power Pivot instance of SSAS on the same server.
• C.Install one tabular instance of SSAS and enable the Data Mining Extensions.
• D.Install one multidimensional instance of SSAS.
• E.Install one tabular instance of SSAS.

You manage an instance of SQL Server Analysis Services (SSAS). Over the last several months, the usage on the server increased by 50% as users begin to create and run more analyses.
Queries are taking longer to run, and processor usage is consistently above 80%.
You predict that query usage will continue to increase at 5% per month. You need to scale SSAS to accommodate the present and future processing load.
Which three actions could you take?
Each correct answer presents a complete solution.

• A.Create a second instance of SSAS on a different server and dedicate this instance to processing queries.
• B.Create a new Network Load Balanced (NLB) cluster.
• C.Create a new remote SSAS partition.
• D.Create a second instance of SSAS on the same server and dedicate this instance to processing queries.
• E.Create a new local SSAS partition.

You are creating a SQL Server Analysis Services (SSAS) cube.
You need to create a time dimension. It must be linked to a measure group named Sales at the day granularity level.
It must also be linked to a measure group named Salary at the month granularity level.
What should you do?

• A.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
• B.Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.
• C.Add a measure group that has one measure that uses the DistinctCount aggregate function
• D.Add a measure that uses the DistinctCount aggregate function to an existing measure group.

Drag and Drop Question
You need to configure the CoffeeSale fact table environment.
Which four 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. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

正解：

Explanation:
Step 1: Partition the CoffeSale facto table.
Step 2: Set the storage mode for all partitions to HOLAP. Partitions stored as HOLAP are smaller than the equivalent MOLAP partitions because they do not contain source data and respond faster than ROLAP partitions for queries involving summary data.
Step 3: Alter the processing job to ensure that it rearranges the partition structure each evening.
Step 4: Test that the cube meets the functional requirement for data currency and query performance.
From scenario:
Data analysts must be able to analyze sales for financial years, financial quarters, months, and days. Many reports are based on analyzing sales by month.
The SalesAnalysis cube contains a fact table named CoffeeSale loaded from a table named FactSale in the data warehouse. The time granularity within the cube is 15 minutes.
The cube is processed every night at 23:00. You determine that the fact table cannot be fully processed in the expected time. Users have reported slow query response times.
https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models-olap-logical- cube-objects/partitions-partition-storage-modes-and-processing

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are developing Microsoft SQL Server Analysis Services (SSAS) tabular model.
The model must meet the following requirements:
You need to configure model.
What should you do?

• A.Process the model in Process Data mode.
• B.Ensure that the Transactional Deployment property is set to True.
• C.Process the model in Process Full mode.
• D.Ensure that DirectQuery is disabled for the model.
• E.Process the model in Process Defrag mode.
• F.Ensure that DirectQuery is enabled for the model.
• G.Ensure that the Transactional Deployment property is set to False.