70-768 Exam Questions

You need to configure the server to optimize the afternoon report generation based on the OrderAnalysis cube. Which property should you configure?

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

How can you enhance the model to support analysis by date?

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...

How do you support the profit percentage in your solution design?

What type of partitioning strategy should you implement to support the analysis of hourly Internet sales transactions?

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...

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...

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...

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...

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...

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...

What property do you set for each measure to improve the legibility of values in a client application?

You are designing a SQL Server Analysis Services (SSAS) cube.You need to create a measure to count unique customers.What should you do?

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,...

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...

Which is the easiest option for configuring and maintaining security for each salesperson?

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...

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...

Which of the following object types do you add to the cube?

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...

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...

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...

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...

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...