High value 70-778 Free Practice Questions 2019

It is impossible to pass Microsoft 70-778 exam without any help in the short term. Come to us soon and find the most advanced, correct and guaranteed . You will get a surprising result by our .

Online 70-778 free questions and answers of New Version:

NEW QUESTION 1
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario.
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button.)
70-778 dumps exhibit
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.)
70-778 dumps exhibit
You plan to use Power BI to import data from 2013 to 2015. Product Subcategory[Subcategory] contains NULL values. End of Repeated Scenario.
You need to create a measure of Sales[SalesAmount] where Product[Color] is Red or Product[Size] is 50. Which DAX formula should you use?
70-778 dumps exhibit
70-778 dumps exhibit

  • A. Option A
  • B. Option B
  • C. Option C
  • D. Option D

Answer: C

NEW QUESTION 2
You have a Power BI model that has the following tables:
Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
Salesperson (Salesperson_id, Salesperson_name, address)
Product (Product_id, Product_Name)
You need to create the following relationships:
Sales to Product
Sales to Sales person
You need to ensure that you can create a report that displays the count of products sold by each salesperson. How should you configure the relationships? To answer, drag the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
70-778 dumps exhibit

    Answer:

    Explanation: References: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

    NEW QUESTION 3
    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
    After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    You have a user named User1. User1 is a member of a security group named Contoso PowerBI. User1 has access to a workspace named Contoso Workspace.
    You need to prevent User1 from exporting data from the visualizations in Contoso Workspace. Solution: From the Microsoft Office 365 Admin center, you modify the properties of Contoso PowerBI. Does this meet the goal?

    • A. Yes
    • B. No

    Answer: A

    Explanation: References:
    https://docs.microsoft.com/en-us/power-bi/service-manage-app-workspace-in-power-bi-and-office-365

    NEW QUESTION 4
    You create a report in the Power BI service that displays the following visualizations:
    A KPI that displays the count of customers
    A table that displays the count of customers by country
    A line chart that displays the count of customers by year
    You need to receive an alert when the total number of customers reaches 10,000. What should you do first?

    • A. Pin the line chart to a dashboard.
    • B. Pin the KPI to a dashboard.
    • C. Embed the report into a Microsoft SharePoint page.
    • D. Pin the report to a dashboard.

    Answer: D

    NEW QUESTION 5
    Note: This question is a part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
    After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    You have a query for a table named Sales. Sales has a column named CustomerID. The Data type of CustomerID is Whole Number.
    You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.
    You need to ensure that nonnumeric values in the CustomerID column are set to 0. Solution: From Query Editor, select the CustomerID column and click Replace Values… Does this meet the goal?

    • A. Yes
    • B. No

    Answer: B

    NEW QUESTION 6
    You have a Power BI report that is configured to use row-level security (RLS).
    You have the following roles:
    A manager role that limits managers to see only the sales data from the stores they manage.
    A region role that limits users to see only the data from their respective region
    You plan to use Power BU Embedded to embed the report into an application. The application will authenticate the users.
    You need to ensure that RLS is enforced when accessing the embedded report. What should you do?

    • A. In the access token for the application, include the user name and the role name.
    • B. In the access token for the application, include the report URL and the Microsoft Azure Active Directory Domain name.
    • C. From dev.powerbi.com/apps, register the new application and enable the Read All Reports API access.
    • D. From dev.powerbi.com/apps, register the new application and enable the Read All Groups API access.

    Answer: A

    Explanation: References: https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security

    NEW QUESTION 7
    You have a Microsoft SharePoint Online site named Sales.
    Your company has 1,000 sales users. All the sales users can access Sales.
    You create a report in an app workspace in the Power BI service. You embed the report into a page on the Sales site by using the Power BI web part.
    You need to ensure that all the sales can view the report from the Sales site. What should you do?

    • A. Configure the app workspace for Premium capacity.
    • B. Enable anonymous access for the Sales site.
    • C. Configure the Portal Site Connection for the Sales site.
    • D. Disable the Embed content in apps setting from the Tenant settings in Power BI.

    Answer: A

    Explanation: References: https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo

    NEW QUESTION 8
    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
    After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    You have a user named User1. User1 is a member of a security group named Contoso PowerBI. User1 has access to a workspace named Contoso Workspace.
    You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.
    Solution: From the Microsoft Office 365 Admin center, you remove User1 from the All Users security group. Does this meet the goal?

    • A. Yes
    • B. No

    Answer: B

    NEW QUESTION 9
    You are importing sales data from a Microsoft Excel file named Sales.xlsx into Power BI Desktop. You need to create a bar chart showing the total sales amount by region.
    When you create the bar chart, the regions appear as expected, but the sales amount value displays the count of sales amount instead of the sum of sales amount each region.
    You need to modify the query to ensure that the data appears correctly. What should you do?

    • A. Delete the query, import the data into Microsoft SQL Server, and then import the data from SQL Server.
    • B. In Query Editor, add a calculated column that totals the sales amount column.
    • C. Change the Data Type of sales amount column to Numeric.
    • D. Refresh the data model.

    Answer: B

    NEW QUESTION 10
    You have a Power BI model that contains a table named Sales. Sales contains columns named SalesAmount, OrderDate, SalesPerson, and OrderID.
    You need to create a measure to calculate the last 12 months of sales. You must start from the last date a sale was made and ignore any filters set on the report.
    How should you complete the DAX formula? To answer, drag the appropriate values to the correct targets. Each value 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.
    NOTE: Each correct selection is worth one point.
    70-778 dumps exhibit

      Answer:

      Explanation: References:
      https://msdn.microsoft.com/en-us/library/ee634380.aspx https://msdn.microsoft.com/en-us/library/ee634795.aspx

      NEW QUESTION 11
      You have a query that retrieves sales data. A sample of the data is shown in the following table.
      70-778 dumps exhibit
      You need to ensure that the values in the Date column contain a date. Null values must be replaced with the date from the previous row.
      What should you click on the Transform tab in Query Editor?

      • A. Format, and then Clean
      • B. Date, and then Earliest
      • C. Fill, and then Down
      • D. Replace Values, and then Replace Errors

      Answer: C

      Explanation: References:
      https://www.excelcampus.com/library/fill-down-blank-null-cells-power-query/

      NEW QUESTION 12
      You have the following two queries in Power BI Desktop:
      A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database
      A query named Query2 that retrieves a table named Enterprise_Customers from an Oracle database Both tables have the same columns.
      You need to combine the data from SMB_Customers and Enterprise_Customers. Which command should you use?

      • A. Combine Files
      • B. Merge Columns
      • C. Merge Queries
      • D. Append Queries

      Answer: D

      Explanation: References:
      http://radacad.com/append-vs-merge-in-power-bi-and-power-query

      NEW QUESTION 13
      You have the report shown in the following exhibit.
      70-778 dumps exhibit
      Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
      NOTE: Each correct selection is worth one point.
      70-778 dumps exhibit

        Answer:

        Explanation: 70-778 dumps exhibit

        NEW QUESTION 14
        You have the following tables.
        70-778 dumps exhibit
        You need to create a new table that displays the top 10 customers by the total of SalesAmount.
        How should you complete the DAX formula? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
        70-778 dumps exhibit

          Answer:

          Explanation: References: https://msdn.microsoft.com/en-us/library/gg492198.aspx

          NEW QUESTION 15
          Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
          Access a published Power BI app
          Modify reports in an app workspace
          Share dashboards created in My Workspace
          You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.
          Which license should you identify for each task? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
          70-778 dumps exhibit

            Answer:

            Explanation: References:
            https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace

            NEW QUESTION 16
            You need to create a dashboard in the Power BI service to display data from a PubNub source. What should you do?

            • A. Add a Microsoft SQL Server Analysis Services (SSAS) data source that uses Connect live and create a repor
            • B. Pin the report to a dashboard.
            • C. Create an app workspace and publish the workspace to a dashboard.
            • D. Add a Microsoft Azure SQL database data source that uses DirectQuery and create a repor
            • E. Pin the report to a dashboard.
            • F. Add a custom streaming data tile to a dashboard.

            Answer: D

            Explanation: References:
            https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming#set-up-your-real-time-streaming-dataset-

            NEW 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 that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
            After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
            You have an app workspace that contains a report. The report contains sensitive data.
            You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses.
            Solution: From Publish to web, generate an iFrame. Does this meet the goal?

            • A. Yes
            • B. No

            Answer: B

            NEW QUESTION 18
            You have a Microsoft Excel workbook that contains two tables.
            From Power BI, you create a dashboard that displays data from the tables. You update the tables each day.
            You need to ensure that the virtualizations in the dashboard are updated daily.
            Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to answer area and arrange them in the correct order.
            70-778 dumps exhibit

              Answer:

              Explanation: References: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

              NEW QUESTION 19
              Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
              You have a Microsoft SQL Server database that contains the following tables.
              70-778 dumps exhibit
              The following columns contain date information:
              - Date[Month] in the mmyyyy format
              - Date[Date_ID] in the ddmmyyyy format
              - Date[Date_name] in the mm/dd/yyyy format
              - Monthly_returns[Month_ID] in the mmyyyy format The Order table contains more than one million rows.
              The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
              You plan to use Power BI Desktop to create an analytics solution for the data.
              You need to create a relationship between the Monthly_returns table and Date[Date_ID]. What should you do before you create the relationship?

              • A. In the Date table, create a new calculated column named MonthJD that uses the yyyydd format.
              • B. In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.
              • C. To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.
              • D. To the Date table, add a calculated column that uses the RE LATE D(Monthly_ret urns [MonthJD]) DAX formula.

              Answer: B

              Explanation:
              References:
              https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

              100% Valid and Newest Version 70-778 Questions & Answers shared by 2passeasy, Get Full Dumps HERE: https://www.2passeasy.com/dumps/70-778/ (New 144 Q&As)