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

PL/SQL

Answer

Transact-SQL (T-SQL)

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 distribution

Answer

Column profile

Answer

Show Whitespaces

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

Mark Query

Answer

Format Query

Answer

Split Query

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

Restrictions to specific measures within Power BI reports to some specific users

Answer

Adding the ability to link Power BI Log-in to organizational Active Directory or Window Login through Single Sign On (SSO)

Answer

All the above

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

Workbooks

Answer

Dashboards

Answer

Reports

Question 6

Which of the following responsibilities can only be carried out by the workspace administrator and not by users with lower rights and privileges?

Accepted Answer

Adding or removing the other users from the workspace

Answer

Creating a report in another workspace depending upon the dataset of this workspace

Answer

Scheduling the data refreshes

Answer

Publishing workspace content in the app

Question 7

What among the following can you include in a bookmark? (Choose Three Responses)

Accepted Answer

The sort order on any visualizations that have been set

Answer

The list of visual types available in the visualization pane

Question 8

What are the public cloud deployment model's two distinguishing features? Each accurate response offers an entire resolution. Select each appropriate response.

Accepted Answer

A different cloud service provider owns and manages the servers and storage.

Answer

Users from a single organization use computing resources solely.

Answer

The on-site datacenter of a company is where hardware is actually kept.

Question 9

What two traits do consumption-based models have? Each accurate response offers an entire resolution. Select each appropriate response.

Accepted Answer

No upfront expenses

Answer

Demands the acquisition and administration of the physical infrastructure.

Answer

High capital expenditures.

Question 10

Why does cloud computing frequently cost less than on-site datacenters?

Accepted Answer

You only pay for what you really use.

Answer

It's free to use network bandwidth.

Answer

The functionality of cloud service solutions is constrained.

Answer

Services are only provided in one specific area.