DA-100 Exam Question 116

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
* First name
* Last name
* Email address
* State/Region
* Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
  • DA-100 Exam Question 117

    You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.

    Sales contains only the data shown in the following table.

    For each of the following statements, select Yes if the statement is true. Otherwise, select No.
    NOTE: Each correct selection is worth one point.

    DA-100 Exam Question 118

    You have a report page that contains the visuals shown in the following 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.

    DA-100 Exam Question 119

    You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?
  • DA-100 Exam Question 120

    You are creating a column chart visualization.
    You configure groups as shown in the Groups exhibit. {Click the Groups tab.)

    The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)

    For each of the following statements, select Yes if the statement is true. Otherwise, select No.
    NOTE: Each correct selection is worth one point.