اختبار شهادة مايكروسوفت Microsoft Power BI Data Analyst

السؤال 66 من 66

كل الأسئلة

You are creating a sales report in Power BI for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:
The report will facilitate the following analysis:
The count of orders and the sum of total sales by OrderDate
The count of customers who placed an order
The average quantity per order
You need to reduce data refresh duration and report query duration.
Which two actions should you perform?

الخيارات

  • A Filter the data to only the NorthWest region sales territory.
  • B Remove the TaxAmount and Freight columns.
  • C Set the data type for SalesOrderNumber to Decimal Number.
  • D Remove the CustomerKey and ProductKey columns.

النقاشات

لا توجد نقاشات منشورة لهذا السؤال حالياً.