DA-100 Exam Question 66

You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail dat a. The users require insights on the completeness of the data and the value distributions.
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.

DA-100 Exam Question 67

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 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, open Advanced Editor and add the following query step.

Does this meet the goal?
  • DA-100 Exam Question 68

    You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?
  • DA-100 Exam Question 69

    You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh.
    From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity.
    You discover that the dataset refresh fails after the refresh runs out of resources.
    What is a possible cause of the issue?
  • DA-100 Exam Question 70

    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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    You have several reports and dashboards in a workspace.
    You need to grant all organizational users read access to a dashboard and several reports.
    Solution: You publish an app to the entire organization.
    Does this meet the goal?