
Ultimate access to all questions.
In your role, you need to implement diagnostic analytics to understand the reasons behind fraudulent transactions in a financial institution. The dataset includes 'TransactionID', 'Amount', 'Date', 'CustomerID', and 'FraudFlag'. Describe how you would use SQL queries and data visualization tools in Microsoft Fabric to identify key factors contributing to fraud. Include the types of analyses you would perform and the visualizations that would best represent these findings.
A
Use SQL to group data by CustomerID and Date, then use pie charts for visualizations.
B
Aggregate data by Amount and FraudFlag, then use bar charts and line charts for visualizations.
C
Filter data by FraudFlag and analyze correlations with other variables using heat maps.
D
Sort data by TransactionID and use scatter plots for visualizations.