Exact 70-778 Braindumps 2019

Exam Code: 70-778 (), Exam Name: Analyzing and Visualizing Data with Microsoft Power BI (beta), Certification Provider: Microsoft Certifitcation, Free Today! Guaranteed Training- Pass 70-778 Exam.

Free demo questions for Microsoft 70-778 Exam Dumps Below:

NEW QUESTION 1
You have a Power BI report in an app workspace.
You plan to embed a report from the app workspace into a line-of-business application by using Power BI Embedded.
Which information should you provide to the application developers?

  • A. The application token and the report URL
  • B. The report URL and a user name
  • C. The app workspace name and the access key
  • D. The access key and the report ID

Answer: C

Explanation: References: https://docs.microsoft.com/en-us/power-bi/developer/integrate-report

NEW QUESTION 2
You are creating a work schedule for a retail store.
You have the following data from a query named Schedule.
70-778 dumps exhibit
You need to visualize the data as shown in the following exhibit.
70-778 dumps exhibit
You add a matrix visualization, and then you add Employee to the rows and Scheduled to columns.
Which DAX formula should you use to create the measure that will display the checkboxes? 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: 70-778 dumps exhibit

    NEW QUESTION 3
    Note: This question is a part of a series of questions that present 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 contains the following tables.
    70-778 dumps exhibit
    The following columns contain data 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 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. End of repeated scenario.
    You plan to create a chart that displays total Order [Order_amount] by Store [Name]. You need to modify the model to ensure that you can create the chart.
    Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

    • A. To the Order table, add a column that uses the RELATED(‘Store’ [Store_ID]) DAX formula.
    • B. Create a relationship between the Order table and the Store table.
    • C. To the Order table, add a measure that uses the COUNT (‘Order’[Order_amount]) DAX formula.
    • D. To the order table, add a measure that uses the SUM (‘Order’ [Order_amount]) DAX formula.

    Answer: AD

    Explanation: References:
    https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns

    NEW QUESTION 4
    You plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart The date value in AdivityDate is a number column named DatelD. DatelD is in the YYYYMMDD format.
    What should you do in the model before you create the relationship?

    • A. Change the Data Type of ActivityStart to Date.
    • B. Create a measure in ActivityLog that uses the format DAX function.
    • C. Change the Data Type of DatelD to Date.
    • D. Create a calculated column in ActivityLog that uses the format DAX function.

    Answer: D

    NEW QUESTION 5
    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 visualizations 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 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-778 dumps exhibit

      Answer:

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

      NEW QUESTION 6
      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: Purchase Power BI Premium P1, and then configure the app workspace to run in a dedicated capacity.
      Does this meet the goal?

      • A. Yes
      • B. No

      Answer: A

      Explanation: References:
      https://docs.microsoft.com/en-us/power-bi/developer/embed-sample-for-customers

      NEW QUESTION 7
      You have the following two tables:
      • Subscriber (SubscriberlD, Enroll mentDate, ServicePlan)
      • Date (Date, Month, Week, Year)
      There is a relationship between Subscriber [EnrollmentDate] and Date[Date].
      You plan to create a KPI for the number of subscribers enrolled in the current year.
      You need to create a goal that is five percent more than the number of subscribers enrolled during the previous calendar year.
      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: CALCULATE
        COUNT PREVIOUSYEAR
        References:
        https://msdn.microsoft.com/en-us/library/hh272049(v=sql.110).aspx https://msdn.microsoft.com/en-us/library/ee634770.aspx

        NEW QUESTION 8
        You are creating a report in Power BI Desktop. You are consuming the following tables.
        70-778 dumps exhibit
        You have a new table named Fiscal that has the same schema as the Date table, but contains the fiscal dates of your company.
        You need to create a report that displays the total sales by fiscal month and calendar month. What should you do?

        • A. Union Fiscal and Date as one table.
        • B. Add Fiscal to the model and create a one-to-many relationship by using Date[Year] and Fiscal[Year].
        • C. Add Fiscal to the model and create a one-to-one relationship by using Date[Year] and Fiscal[Year].
        • D. Merge Fiscal into the Date table.

        Answer: D

        Explanation: References: https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

        NEW QUESTION 9
        Your organization has a team of power users who recently created 20 Power BI dashboards. The power users share the dashboards with other users in the organization.
        When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)
        70-778 dumps exhibit
        You need to ensure that all the users can access the dashboards. What should you do first?

        • A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.
        • B. From the Power BI Admin portal, modify the Privacy Settings.
        • C. From the properties of each dashboard, modify the Share dashboard settings.
        • D. Instruct each user to install Microsoft Office 2016.

        Answer: A

        Explanation: References:
        http://www.nubo.eu/en/blog/2016/12/Enable-PowerBI-On-Office-365/

        NEW QUESTION 10
        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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains two columns named Date and Time.
        The tables have the following relationships:
        Sales [DueDate] and Date [Date]
        Sales [ShipDate] and Date [Date]
        Sales [OrderDate] and Date [Date]
        The active relationship is on Sales [DueDate].
        You need to create measures to count the number of orders by [ShipDate] and orders by [OrderDate]. You must meet the goal without loading any additional data.
        Solution: You create two copies of the Date table named ShipDate and OrderDateGet. You create a measure that uses the new tables.
        Does this meet the goal?

        • A. Yes
        • B. No

        Answer: B

        NEW QUESTION 11
        You have a Microsoft Excel 2016 workbook that has a Power Pivot model. The model contains the following tables:
        Product (Product_id, Producct_Name)
        Sales (Order_id, Order_Date, Product_id, Selasperson_id, Sales_Amount)
        Salesperson (Salesperson_id, Salesperson_name, address)
        The model has the following relationships:
        Sales to Product
        Sales to Salesperson
        You create a new Power BI file and import the Power Pivot model.
        You need to ensure that you can generate a report that displays the count of products sold by each salesperson. What should you do before you create the report?

        • A. Create a many-to-one relationship between Product and Salesperson.
        • B. For each relashionship, change the Cardinality to One to One (1:1).
        • C. Create a one-to-one relashionship between Product and Salesporson.
        • D. For each relationship, change the Cross filter direction to Both.

        Answer: D

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

        NEW QUESTION 12
        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 Errors. Does this meet the goal?

        • A. Yes
        • B. No

        Answer: A

        Explanation: References: https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

        NEW QUESTION 13
        You have two tables named CustomerVisits and Date in a Power BI model.
        You create a measure to calculate the number of customer visits. You use the measure in the report shown in the exhibit. (Click the Exhibit.)
        70-778 dumps exhibit
        You discover that the total number of customer visits was 60,000, and that there were only 5,000 customer visits in August.
        You need to fix the report to display the correct data for each month. What should you do?

        • A. Create a relationship between the CustomerVisits table and the Date table.
        • B. Create a hierarchy in the Date table.
        • C. Modify the n=measure to use the CALCULATE DAX function.
        • D. Modify the measure to use the SUM DAX function.

        Answer: A

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

        NEW QUESTION 14
        You have a Power BI app named App1. The privacy for the App1 app workspace is set to Private.
        A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.
        You need to ensure that User1 sees App1 from the My organization AppSource. What should you do?

        • A. From the app workspace, click Update app, configure the Access setting, and then click Update app.
        • B. From the app workspace, share the dashboard.
        • C. From the app workspace settings, add a member.
        • D. From the app workspace, click Update app, configure the Content settings, and then click Update app.

        Answer: A

        NEW QUESTION 15
        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 Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.
        You need to recreate the Power View sheets as reports in the Power BI service.
        Solution: From the Power BI service, get the data from SharePoint Online, and then click Import. Does this meet the goal?

        • A. Yes
        • B. No

        Answer: A

        Explanation: References:
        https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files

        NEW QUESTION 16
        You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server.
        You need to ensure that all the visualization in the report can be consumed by users.
        Which three types of visualizations should you include in the report? Each correct answer presents part of the solution.
        NOTE: Each correct selection is worth one point.

        • A. bubble maps
        • B. custom visuals
        • C. R visuals
        • D. breadcrumbs
        • E. funnel charts

        Answer: ABE

        Explanation: References:
        https://docs.microsoft.com/en-us/power-bi/report-server/install-powerbi-desktop

        NEW QUESTION 17
        You plan to use Power BI Desktop to import 100 CSV files.
        The files contain data from different stores. The files have the same structure and are stored in a network share.
        You need to import the CSV files into one table. The solution must minimize administrative effort. What should you do?

        • A. Add a folder data source and use the Combine Files command.
        • B. Add a folder data source and use the Merge Queries command.
        • C. Add a Microsoft Excel data source and use the Merge Queries command.
        • D. Add text/CSV data sources and use the Append Queries command.

        Answer: A

        Explanation: References: https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries

        NEW QUESTION 18
        You create a report in the Power BI service.
        You plan to provide external users with access to the report in the blog post will be updated as the data is refreshed.
        What should you do in the Power BI service?

        • A. Publish the app workspace to the entire organizatio
        • B. In the blog post, use the URL of the workspace.
        • C. Share the repor
        • D. In the blog post, use the URL of the dashboard.
        • E. Publish the report to the we
        • F. In the blog post, use the embed code URL.
        • G. In the blog post, use the URL of the report.

        Answer: C

        Explanation: References: https://docs.microsoft.com/en-us/power-bi/service-publish-to-web

        NEW QUESTION 19
        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 query for a table named Sales. Sales has a column named CustomerlD. The Data Type of CustomerlD 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 CustomerlD column are set to 0.
        Solution: From Query Editor, select the CustomerlD column. Click Replace Errors... and enter a value of 0 Does this meet the goal?

        • A. Yes
        • B. No

        Answer: A

        Recommend!! Get the Full 70-778 dumps in VCE and PDF From Certleader, Welcome to Download: https://www.certleader.com/70-778-dumps.html (New 144 Q&As Version)