Free Azure Data Analyst Associate Questions and Answers

Question 1

The data from Azure Analysis Services cubes can be queried using which of the subsequent types of explanations? (Choose two correct answers)

Accepted Answer

Data Analysis Expressions (DAX)

Answer

Azure Analysis Services (AAS) supports two primary query languages for interacting with its analytical models. Multidimensional Expressions (MDX) is the traditional language used for querying multidimensional cubes, while Data Analysis Expressions (DAX) is used for querying tabular models. Both are powerful functional languages specifically designed for data analysis and are essential for extracting insights and performing calculations on data within AAS cubes.

Question 2

You want to learn as soon as possible the percentage of empty cells or values in each column for the query that was opened in Power Query Editor. Which data preview option from the list below would you choose?

Accepted Answer

Column quality

Answer

Column quality in Power Query Editor provides a quick visual summary of each column's data, including the percentage of valid, error, and empty values. This feature is designed for rapid assessment of data completeness and quality directly within the data preview. By enabling it, you can instantly see the percentage of empty cells for every column.

Question 3

Think about dividing your query into two pieces. Which options from the list below would you utilize in Power BI?

Accepted Answer

Extract previous

Answer

In Power Query Editor, the 'Extract previous' option (specifically 'Extract Previous' when right-clicking a step) allows you to refactor a query by creating a new query from a selected step and all preceding steps. This effectively divides the original query's logic into two parts: the extracted portion becomes a new query, and the original query then references this new query, enabling modularity and reuse of common transformation steps.

Question 4

What function does Power BI's Row Level Security (RLS) serve?

Accepted Answer

Restricting data access for the given users ( By assigning users to roles)

Answer

Row-Level Security (RLS) in Power BI is designed to restrict data access at the row level based on the user executing the report. It works by defining roles and rules within Power BI Desktop, which are then applied to users or groups in the Power BI service, ensuring they only see the data they are authorized for. This prevents unauthorized users from viewing sensitive data rows.

Question 5

Your team manager has assigned you the responsibility of building a Power BI dashboard with sales data visualizations. In order for users to use the Q&A option, you must post some questions for them to ask.  What will you do in Power BI's settings so that the questions can be enabled?

Accepted Answer

Datasets

Answer

The Q&A feature in Power BI, which allows users to ask natural language questions about their data, is enabled and configured at the dataset level. To post suggested questions for users, you interact with the dataset settings in the Power BI service, where you can define featured Q&A questions that guide users on what to ask. This makes the Q&A experience more intuitive and useful.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Free Azure Data Analyst Associate Questions and Answers