Practical 70-768 Exam Questions and Answers 2019

70-768 Royal Pack Testengine pdf

100% Actual & Verified — 100% PASS

Unlimited access to the world's largest Dumps library!

https://www.2passeasy.com/dumps/70-768/

70-768 dumps for Microsoft certification, Real Success Guaranteed with Updated 70-768 exam. 100% PASS 70-768 Developing SQL Data Models (beta) exam Today!

Free 70-768 Demo Online For Microsoft Certifitcation:

NEW QUESTION 1
You are troubleshooting query performance for a SQL Server Analysis Services (SSAS) cube.
A user reports that a Multidimensional Expressions (MDX) query is very slow.
You need to identify the MDX query statement in a trace by using SQL Server Profiler. Which event class should you use?

  • A. Get Data From Aggregation
  • B. Query Subcube
  • C. Query Begin
  • D. Progress Report Begin
  • E. Calculate Non Empty Begin
  • F. Execute MDX Script Begin

Answer: C

NEW QUESTION 2
DRAG DROP
You are writing a MDX query to retrieve data from a Microsoft SQL Server Analysis Services (SSAS) cube named Channel Sales. The cube defines two measures named Sales and Cost. The cube also defines a Date dimension and a Product dimension.
You need to retrieve profit values for a year named CY2016.
How should you complete the MDX statement? To answer, drag the appropriate MDX segment to the correct locations. Each MDX segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
70-768 dumps exhibit

    Answer:

    Explanation: Box 1:WITH MEMBER…
    Box 2:WHERE ([Date].[Year].[CY2016])
    References: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/mdx/working-with-members-tuples-and-sets-mdx

    NEW QUESTION 3
    DRAG DROP
    You install a SQL Server Analysis Services (SSAS) instance in tabular mode on a server.
    While processing a very large tabular model, you receive an out-of-memory error. You identify that the amount of physical memory in the server is insufficient. Additional physical memory cannot be installed in the server.
    You need to configure the server to allow paging to disk by using the operating system page file (pagefile.sys).
    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.)
    70-768 dumps exhibit

      Answer:

      Explanation: Box 1:
      70-768 dumps exhibit
      Box 2:
      70-768 dumps exhibit
      Box 3:
      70-768 dumps exhibit
      Box 4:
      70-768 dumps exhibit
      Note:
      * View or set configuration properties in Management Studio
      ✑ In SQL Server Management Studio, connect to an Analysis Services instance. In Object Explorer, right-click the Analysis Services instance, and then clickProperties. The General page appears, displaying the more commonly used properties.
      ✑ To view additional properties, click theShow Advanced (All) Propertiescheckbox at the bottom of the page.
      Modifying server properties is supported only for tabular mode and multidimensional mode servers. If you installed PowerPivot for SharePoint, always use the default values unless you are directed otherwise by a Microsoft product support engineer.
      * VertiPaqPagingPolicy
      Specifies the paging behavior in the event the server runs low on memory. Valid values are as follows:
      Zero (0) is the default. No paging is allowed. If memory is insufficient, processing fails with an out-of-memory error.
      1 enables paging to disk using the operating system page file (pagefile.sys).
      When VertiPaqPagingPolicy is set to 1, processing is less likely to fail due to memory constraints because the server will try to page to disk using the method that you specified. Setting the VertiPaqPagingPolicy property does not guarantee that memory errors will never happen. Out of memory errors can still occur under the following conditions:
      There is not enough memory for all dictionaries. During processing, Analysis Services locks the dictionaries for each column in memory, and all of these together cannot be more than the value specified for VertiPaqMemoryLimit.
      There is insufficient virtual address space to accommodate the process.
      To resolve persistent out of memory errors, you can either try to redesign the model to reduce the amount of data that needs processing, or you can add more physical memory to the computer.
      Applies to tabular server mode only
      * Incorrect: VertiPaqMemoryLimit
      If paging to disk is allowed, this property specifies the level of memory consumption (as a percentage of total memory) at which paging starts. The default is 60. If memory
      consumption is less than 60 percent, the server will not page to disk.
      This property depends on the VertiPaqPagingPolicyProperty, which must be set to 1 in order for paging to occur.
      Applies to tabular server mode only.

      NEW QUESTION 4
      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 the stated goals.
      You deploy a tabular data model to an instance of Microsoft SQL Server Analysis Services (SSAS). The model uses an in-memory cache to store and query data. The data set is already the same size as the available RAM on the server. Data volumes are likely to continue to increase rapidly.
      Your data model contains multiple calculated tables.
      The data model must begin processing each day at 2:00 and processing should be complete by 4:00 the same day. You observe that the data processing operation often does not complete before 7:00. This is adversely affecting team members.
      You need to improve the performance. Solution: Enable Buffer Cache Extensions. Does the solution meet the goal?

      • A. Yes
      • B. No

      Answer: B

      Explanation: In this scenario we would need both Buffer Cache Extensions and SSD.
      The buffer pool extension provides the seamless integration of a nonvolatile random access memory (that is, solid-state drive) extension to the Database Engine buffer pool to significantly improve I/O throughput.
      References:https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/buffer-pool-extension

      NEW QUESTION 5
      HOTSPOT
      You are deploying a multidimensional Microsoft SQL Server Analysis Services (SSAS) project. You add two new role-playing dimensions named Picker and Salesperson to the cube. Both of the cube dimensions are based upon the underlying dimension named Employee in the data source view.
      Users report that they are unable to differentiate the Salesperson attributes from the Picker attributes.
      You need to ensure that the Salesperson and Picker attributes in each dimension use unique names.
      In the table below, identify an option that you would use as part of the process to alter the names of the attributes for each of the dimensions.
      NOTE: Make only one selection in each column.
      70-768 dumps exhibit

        Answer:

        Explanation: A named query is a SQL expression represented as a table. In a named query, you can specify an SQL expression to select rows and columns returned from one or more tables in one or more data sources. A named query is like any other table in a data source view (DSV) with rows and relationships, except that the named query is based on an expression.
        A named query lets you extend the relational schema of existing tables in DSV without modifying the underlying data source.
        References: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/define-named-queries-in-a-data-source-view-analysis-services

        NEW QUESTION 6
        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 have a Microsoft SQL Server Analysis Services (SSAS) instance that is configured to use multidimensional mode. You create the following cube:
        70-768 dumps exhibit
        You need to create a new dimension that allows users to list shipments by the country where the product is shipped.
        Which relationship type should you use between the Shipment table and the new dimension?

        • A. no relationship
        • B. regular
        • C. fact
        • D. referenced
        • E. many-to-many
        • F. data mining

        Answer: E

        Explanation: Many to Many Dimension Relationships.
        In most dimensions, each fact joins to one and only one dimension member, and a single dimension member can be associated with multiple facts. In relational database terminology, this is referred to as a one-to-many relationship. However, it is frequently useful to join a single fact to multiple dimension members. For example, a bank customer might have multiple accounts (checking, saving, credit card, and investment accounts), and
        an account can also have joint or multiple owners. The Customer dimension constructed from such relationships would then have multiple members that relate to a single account transaction.
        70-768 dumps exhibit
        References:https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models-olap-logical-cube-objects/dimension-relationships

        NEW QUESTION 7
        You are developing a tabular Business Intelligence Semantic Model (BISM) database based on a SQL Server database.
        In the data source, the FactInternetSales table is partitioned by month. Data from the current month has been updated and new data has been inserted in the FactInternetSales table, in the DimProduct table, and in the DimCustomer table.
        In the model, the FactInternetSales table is also partitioned by month.
        You need to ensure that the model has the most recent data while minimizing the processing time.
        What should you do?

        • A. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing optio
        • B. Then process the database with the Process Data processing option.
        • C. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing optio
        • D. Then process the database with the Process Full processing option.
        • E. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Defrag processing optio
        • F. Then process the database with the Process Recalc processing option.
        • G. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing optio
        • H. Then process the database with the Process Defrag processing option.
        • I. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing optio
        • J. Then process the database with the Process Recalc processing option.

        Answer: D

        NEW QUESTION 8
        HOTSPOT
        A company has a multidimensional cube that is used for analyzing sales data. You add a new measure named Transaction – Total Including Tax and include the Supplier, Payment Method, and Transaction Type dimensions in the data model. The Transaction – Total Including Tax measure uses the existing Customer and Date dimensions.
        When users have queried the new measure in the past, they saw results as shown in the existing query output exhibit. (Click the Exhibit button.)
        70-768 dumps exhibit
        The overall total is incorrectly displayed on every row. In addition, the results are no longer formatted correctly.
        The query result should appear as shown in the desired query output exhibit. (Click the Exhibit button.)
        70-768 dumps exhibit
        You need to ensure the table is displayed correctly.
        What should you do? Use drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.
        NOTE: Each correct selection is worth one point.
        70-768 dumps exhibit

          Answer:

          Explanation: Box 1: Enter a custom MeasureExpression property on the measure
          Calculated measures use MDX expressions to supply their values, instead of binding to columns in a data source. The Expression property contains the MDX expression used to supply the values for a Measure only if the Measure is a calculated measure. Otherwise, this property contains an empty string ("").

          NEW QUESTION 9
          DRAG DROP
          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.
          70-768 dumps exhibit

            Answer:

            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.
            References:https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models-olap-logical-cube-objects/partitions-partition-storage-modes-and-processing

            NEW 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 the stated goals.
            You have an existing multidimensional cube that provides sales analysis. The users can slice by date, product, location, customer, and employee.
            The management team plans to evaluate sales employee performance relative to sales targets. You identify the following metrics for employees:
            You need to implement the KPI based on the Status expression. Solution: You design the following solution:
            70-768 dumps exhibit
            Does the solution meet the goal?

            • A. Yes
            • B. No

            Answer: B

            NEW QUESTION 11
            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 one tabular instance of SSAS and enable the Data Mining Extensions.
            • B. Install one multidimensional instance of SSAS.
            • C. Install one tabular instance of SSAS.
            • D. Install a multidimensional instance and a Power Pivot instance of SSAS on the same server.
            • E. Install two separate tabular instances of SSAS.

            Answer: BC

            Explanation: Analysis Services can be installed in one of three server modes: Multidimensional and Data Mining (default), Power Pivot for SharePoint, and Tabular.
            References:https://docs.microsoft.com/en-us/sql/analysis-services/comparing-tabular-and-multidimensional-solutions-ssas

            NEW 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 the stated goals.
            You have a Microsoft SQL Server Analysis Services (SSAS) multidimensional database that stores customer and order data for customers in the United States only. The database contains the following objects:
            70-768 dumps exhibit
            You must create a KPI named Large Sales Target that uses the Traffic Light indicator to display status. The KPI must contain:
            70-768 dumps exhibit
            You need to create the KPI.
            Solution: You set the value of the Status expression to:
            70-768 dumps exhibit
            Does the solution meet the goal?

            • A. Yes
            • B. No

            Answer: A

            NEW 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 the stated goals.
            You have an existing multidimensional cube that provides sales analysis. The users can slice by date, product, location, customer, and employee.
            The management team plans to evaluate sales employee performance relative to sales targets. You identify the following metrics for employees:
            You need to implement the KPI based on the Status expression. Solution: You design the following solution:
            70-768 dumps exhibit
            Does the solution meet the goal?

            • A. Yes
            • B. No

            Answer: B

            NEW QUESTION 14
            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 administer a Microsoft SQL Server Analysis Services (SSAS) tabular model for a retail company. The model is the basis for reports on inventory levels, popular products, and regional store performance.
            The company recently split up into multiple companies based on product lines. Each company starts with a copy of the database and tabular model that contains data for a specific product line.
            You need to optimize performance of queries that use the copied tabular models while minimizing downtime.
            What should you do?

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

            Answer: C

            Explanation: The Transactional Deployment setting controls whether the deployment of metadata changes and process commands occurs in a single transaction or in separate transactions. If this option is True (default), Analysis Services deploys all metadata changes and all process commands within a single transaction.
            If this option is False, Analysis Services deploys the metadata changes in a single transaction, and deploys each processing command in its own transaction.
            References:https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/deployment-script-files-specifying-processing-options

            NEW QUESTION 15
            You are administrating a SQL Server Analysis Services (SSAS) tabular database.
            You need to create a new role that allows its members to query data and to refresh data in the model.
            Which permission should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

            • A. Browse and Manage
            • B. Administrator
            • C. Read and Process
            • D. Explore and Manage

            Answer: C

            Explanation: * Giving a database role permission to process an Analysis Services database means that the role has permission to perform all processing options on the database. This includes the processing of all cubes, dimensions, mining structures, and mining models in the database. However, the role does not have permission to read database metadata or access any data in the database itself.

            NEW QUESTION 16
            You are a business analyst for a retail company that uses a Microsoft SQL Server Analysis Services (SSAS) multidimensional database for reporting. The database contains the following objects:
            70-768 dumps exhibit
            You must create a report that shows, for each month, the Internet sales for that month and the total Internet sales for the calendar year up to and including the current month.
            You create the following MDX statement (Line numbers are included for reference only.):
            70-768 dumps exhibit
            You need to complete the MDX statement to return data for the report. Which MDX segment should you use in line 01?

            • A. [MISSING]
            • B. [MISSING]
            • C. [MISSING]
            • D. [MISSING]

            Answer: B

            Explanation: The following example returns the sum of the Measures. [Order Quantity] member, aggregated over the first eight months of calendar year 2003 that are contained in the Date dimension, from the Adventure Works cube.
            Copy
            WITH MEMBER [Date].[Calendar].[First8Months2003] AS Aggregate(
            PeriodsToDate( [Date].[Calendar].[Calendar Year], [Date].[Calendar].[Month].[August 2003]
            )
            ) SELECT
            [Date].[Calendar].[First8Months2003] ON COLUMNS, [Product].[Category].Children ON ROWS
            FROM
            [Adventure Works] WHERE
            [Measures].[Order Quantity] References:https://docs.microsoft.com/en-us/sql/mdx/aggregate-mdx

            NEW QUESTION 17
            HOTSPOT
            A database named DB2 uses the InMemory query mode. Users frequently run the following
            query:
            70-768 dumps exhibit
            You need to configure SQL Server Profiler to determine why the query is performing poorly. Which three event should you monitor on the SQL Server Profiler trace events
            configuration page? To answer, select the appropriate options in the answer area.
            70-768 dumps exhibit

              Answer:

              Explanation: By using SQL Profiler, you can intercept two classes of trace events from Analysis Services, DAX Query Plan and DirectQuery events, both generated by the DirectQuery engine. Here, in this scenario we have a DAX Query.
              DAX Query Plan events are generated by the DAX formula.
              By using the In-Memory mode, you store a copy of data in the xVelocity (VertiPaq) storage engine.
              Figure: This is how a query is executed by using In-Memory mode.
              70-768 dumps exhibit
              References: Microsoft SQL Server 2012 Analysis Services, The BISM Tabular Model, Microsoft Press (July 2012), page 331
              From Scenario: Users report that the query takes a long time to complete.

              NEW 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 the stated goals.
              You have a Microsoft SQL Server Analysis Services (SSAS) multidimensional database that stores customer and order data for customers in the United States only. The database contains the following objects:
              70-768 dumps exhibit
              You must create a KPI named Large Sales Target that uses the Traffic Light indicator to display status. The KPI must contain:
              70-768 dumps exhibit
              You need to create the KPI.
              Solution: You set the value of the Status expression to:
              70-768 dumps exhibit
              Does the solution meet the goal?

              • A. Yes
              • B. No

              Answer: B

              Recommend!! Get the Full 70-768 dumps in VCE and PDF From 2passeasy, Welcome to Download: https://www.2passeasy.com/dumps/70-768/ (New 50 Q&As Version)