14. You are working with a data set including order records and their ID numbers. While profiling the data, you noticed that there are duplicate values in the "ID" field for each order. You need to create a data set that only shows one record per order, which would create a data set with distinct orders. What keyword can you include in the query to provide a unique list of orders?

Select an answer:

REMOVE DUPLICATES

DELETE

DISTINCT

15.A company is looking into increasing their margins on a product. Which variable(s) could be taken into consideration? A) Product Cost B) Product Retail Price C) Customer Location

Select an answer:

customer location only

product retail price only

product cost and product retail price

product cost only

16.An organization has a table visual with customer and total sales data. They want to be able to see each product ordered by the customers, as well as expand/collapse various customers when using the visual. Which process would provide this solution?

Select an answer:

Add a second sales field to the values section.

Ensure that the sales field is above the customer field in the values section.

Add a second table with the same fields.

Convert the visual to a matrix with the product transactions field in both the rows and values.

17. you have a quarterly sales data set that contains a date field, with each business day written as a value for orders placed on that day. You need to find the days on which sales did not occur, and you do not have every day of the time period in your data. What should you introduce into your model?

Select an answer:

Add a date table joined to the data set. The join should provide all dates in the time period and the associated records.

Create calculations that look for dates that don't exist, and then provide the next date needed.

Inform the leadership that this report is not possible.

Open the data set and add records that represent the dates that are not present in the data set.

18. When data in a software system is considered the most valid record and represents the truth of data, how would you classify that data?

Select an answer:

none of these answers

data warehouse

system of record

source record

19. Which visual in Power BI is good for displaying a single aggregated data point?

Select an answer:

table

matrix

pie chart

card