question A - If I have a table that shows the data of a product for each record (row), and I have a field that identifies the type of product, what aggregation function combined with what statement should I use to be able to group the data in a summarized table , so that for each type of product, I am left with the number of products that the table has?*
• SUM + GROUP BY
• DISTINCT COUNT + ORDER BY
• COUNT + ORDER BY
• COUNT + GROUP BY
question B -Power BI is a cloud-based business analytics service that provides a single view of a business's most critical data and metrics. *
• Provides a single view of business data and metrics but is not a cloud-based business analytics service
• It is a cloud service but it only allows data transformation
• Fake
• TRUE