70-768 Exam Questions
54 real 70-768 exam questions with expert-verified answers and explanations. Page 1 of 2.
- Question #2
You need to configure the server to optimize the afternoon report generation based on the OrderAnalysis cube. Which property should you configure?
- Question #7
A database named DB2 uses the InMemory query mode. Users frequently run the following query: You need to ensure no users see the PriorYearSales measure in the field list for the Sa...
- Question #10
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets th...
- Question #11
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets th...
- Question #12
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets th...
- Question #13
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets th...
- Question #14
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets th...
- Question #15
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. Yo...
- Question #16
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets th...
- Question #17
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets th...
- Question #18
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets th...
- Question #19
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 que...
- Question #21
You are building a Microsoft SQL Server Analysis Services multidimensional model over a SQL Server database. In a cube named OrderAnalysis, there is a standard cube dimension named...
- Question #22
You are optimizing a Microsoft SQL Server Analysis Services (SSAS) multidimensional model over a SQL Server database. You have a table named City which has several dimensions that...
- Question #23
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 que...
- Question #25
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 que...
- Question #28
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 que...
- Question #30
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets th...
- Question #32
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets th...
- Question #33
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 que...
- Question #34
You are developing and application to track customer sales. You need to return the sum of orders that have been finalized, given a specified order identifier. This value will be us...
- Question #35
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 que...
- Question #36
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets th...
- Question #37
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets th...
- Question #38
You use Microsoft SQL Server Profile to evaluate a query named Query. The Profiler report indicates the following issues: - At each level of the query plan, a low total number of r...
- Question #41
You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML. The report includes a dataset with fields named Description, Price, and Color. The report lay...
- Question #42
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. Yo...
- Question #43
How can you enhance the model to support analysis by date?
- Question #44
What property do you set to hide the phone number attribute in the customer dimension from slicing and dicing operations, but allows it to be included in the dimension as a member...
- Question #45
How do you support the profit percentage in your solution design?
- Question #46
What type of partitioning strategy should you implement to support the analysis of hourly Internet sales transactions?
- Question #47
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...
- Question #48
You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data relationships will not change. T...
- Question #49
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...
- Question #50
You are developing a SQL Server Analysis Services (SSAS) tabular project. The model includes a table named Sales. The Sales table includes a single date column. The Sales table mus...
- Question #51
You are developing a SQL Server Analysis Services (SSAS) tabular database. To maximize performance, queries must be resolved only by using cache. You need to configure the appropri...
- Question #52
You are developing a SQL Server Analysis Services (SSAS) cube. The data warehouse has a table named FactStock that is used to track movements of stock. A column named MovementQuant...
- Question #53
What property do you set for each measure to improve the legibility of values in a client application?
- Question #54
You are designing a SQL Server Analysis Services (SSAS) cube.You need to create a measure to count unique customers.What should you do?
- Question #55
You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Profit and includes a table named Date. The table includes year, semester,...
- Question #56
You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power View solution. You need to grant permission for salespersons to view only the data based on the...
- Question #57
Which is the easiest option for configuring and maintaining security for each salesperson?
- Question #58
You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a SQL Azure database and an OData data feed. The model will be deployed to a server...
- Question #59
You manage your department's SQL Server Analysis Services (SSAS) projects. The sales department uses a tabular model to analyze sales data. Users report excessive wait times when u...
- Question #60
Which of the following object types do you add to the cube?
- Question #61
You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance, sales, and marketing teams. The sales team reports that the model is too...
- Question #62
You maintain SQL Server Analysis Services (SSAS) instances. You need to configure an installation of PowerPivot for Microsoft SharePoint in a SharePoint farm. Which tool should you...
- Question #63
You are managing a SQL Server Analysis Services (SSAS) tabular database. The database must meet the following requirements: - The processing must load data into partitions or table...
- Question #64
You are developing a SQL Server Analysis Services (SSAS) tabular project. In the data warehouse, a table named Sales Persons and Territories defines a relationship between a salesp...
- Question #65
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 r...