You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant 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.
D18912E1457D5D1DDCBD40AB3BF70D5D
What should you do?

• A.Change the data type of the Logged column to
• B.Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
• C.Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
  .
• D.Apply a transform to extract the first 11 characters of the Logged column.

Comment: *

Name: *

Email: *

Verification: *

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

• A.Q&A
• B.Key influences
• C.Line and clustered column chart
• D.Funnel chart

Comment: *

Name: *

Email: *

Verification: *

You have a sales system that contains the tables shown in the following table.

The Date table is marked as a date table.
DatelD is the date data type. You need to create an annual sales growth percentage measure.
Which DAX expression should you use?

• A.CALCULATE(SUH(sales[sales_araount]), SAMEPERIODLASTYEAR('Date'[DatelD])
• B.CALCULATE(SUM(sales[sales_amount]), DATESYTD('Date'[DatelD]))
• C.SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]),
  SAMEPERIODLASTYEAR('Date'[DatelD])
• D.(SUN(sales[sales_araount]) - CALCULATE(SUM(sales[sales_amount]),
  SAHEPERIOOLASTYEAR('Date'[DatelD]))/ CALCULATE(SUM(sales[sales_amount]), SAMEPERIOOLASTYEAR ('Date'[DateID])

Comment: *

Name: *

Email: *

Verification: *

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.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/power-query/append-queries

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Yes
• B.No

Comment: *

Name: *

Email: *

Verification: *