Question 156

You are reviewing a query that produces 10,000 rows in the Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
  • Question 157

    You have two Azure SQL databases that contain the same tables and columns.
    For each database, you create a query that retrieves data from a table named Customers.
    You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
    What should you do? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 158

    You use Power Query Editor to preview customer feedback data.
    You need to use Al Insights to add a column of enhanced data based on the customer feedback. The solution must identify the following:
    * What the customers most often provide feedback about
    * Whether the customers like your company's product
    * The language of the feedback
    Which Al Insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service 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.

    Question 159

    You have a Microsoft Exert spreadsheet named Excel1 that contains survey results.
    You have a Power Bl dashboard named DashboardA that has Q&A enabled.
    You need to ensure that users who can access DashboardA can ask Questions based on the contents of Excel 1 and pm visuals based on their queries to DashboardA. The solution must minimize development time.
    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.

    Question 160

    You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.) The data has the following refresh requirements:
    * Customer must be refreshed daily.
    * Date must be refreshed once every three years.
    * Sales must be refreshed in near real time.
    * SalesAggregate must be refreshed once per week.
    You need to select the storage modes for the tables. The solution must meet the following requirements: