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 has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the 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 implement the Power BI model.
You need to edit the Product Category table query to match the desired Power BI model.
How should you complete the advanced query? 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 frag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation
Graphical user interface, application Description automatically generated

References:
https://msdn.microsoft.com/en-us/library/mt260776.aspx
https://msdn.microsoft.com/en-us/library/mt260808.aspx

Comment: *

Name: *

Email: *

Verification: *

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?

• A.Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
• B.Change the data type of the Logged column to Date.
• C.Split the Logged column by using at as the delimiter.
• D.Apply a transformation to extract the first 11 characters of the Logged column.

Comment: *

Name: *

Email: *

Verification: *

You have a Microsoft SharePoint Online site that contains several document libraries.
One of the document libraries contains manufactunng reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to use Power Bl Desktop to load only the manufacturing reports to a table for analysis.
What should you do?

• A.Get data from a SharePoint list enter the site URL and then select Combine & Load
• B.Get data from a SharePoint folder and enter the site URL. Select Transform, then filter by the folder path to the manufacturing reports library,
• C.Get data from a SharePoint folder, enter the site URL and then select Combine & Load
• D.Get data from a SharePoint list and enter the site URL Select Combine & Transform, then filter by the folder path to the manufacturing reports library.

Comment: *

Name: *

Email: *

Verification: *

You need to create a solution to meet the notification requirements of the warehouse shipping department.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct select is worth one point:

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.
For each of the following statement, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Comment: *

Name: *

Email: *

Verification: *