In this blog, we are going to cover Microsoft Azure Data Analyst Associate DA-100 Exam Questions that give you an idea and understanding that generally what type of questions are asked in the DA-100 Associate level exam.
The DA-100 is a great path to take in order to learn data visualization as well as Power BI in order to help the business visualize its data. Since the exam is headed toward a more rule-oriented path, it also touches on higher-level concepts important to Power BI but not all specific to it.
Data Analysts enable businesses to maximize the value of their data assets by using Microsoft Power BI. As subject matter experts, Data Analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations.
If you are preparing for the Microsoft Azure Data Analyst Associate Certification [DA-100] Exam. Then check your readiness by attending to these questions for Azure Data Analyst Associate Certification.
Let’s Discuss the questions:
Azure Data Analyst DA-100 Exam Questions
Q1. Which of the following types of explanations can be used to query the data from Azure Analysis Services cubes? (Select Multiple Options)
A. Transact-SQL (T-SQL)
B. Multidimensional Expressions (MDX)
C. Data Analysis Expressions (DAX)
D. PL/SQL
E. Tabular Model
Explanation:
Correct Answers: B and C
Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) are the explanations that are used to query the data from Azure Analysis Services cubes.
- Option A is incorrect as Transact-SQL (T-SQL) is the expression that is used to query the data from Microsoft SQL Server; not Azure Analysis Services cubes.
- Option B is correct as MDX expressions can be used to query the data from Azure Analysis Services cubes.
- Option C is correct as DAX MDX expressions can be used to query the data from Azure Analysis Services cubes.
- Option D is incorrect as PL/SQL is the block-structured language that combines SQL with the features of procedural languages.
- Option E is incorrect as Tabular data, along with DAX is used by Azure Analytics Services to build calculations, similar to Power Bl.
Read: Microsoft Azure Certification Path
Q2. For the query opened in Power Query Editor, you are interested in finding out the percentage of empty cells or values in each column as soon as possible. Which of the following data Preview Options would you select?
A. Column profile
B. Show Whitespaces
C. Column quality
D. Column distribution
Explanation:
Correct Answer: C
In Power Query Editor, Column Quality, Column distribution, and Column Profile are data profiling functionalities under the View tab in Data Preview Section. These functionalities help in understanding the data anomalies and statistics. Out of these three functionalities, Column quality is the one that can be used to show the percentages of data that is in error, empty and valid.
- Option A is incorrect. The Column profile provides a deeper look into the statistics within the column. This column can be used to provide many different values like the count of rows but it does not help in identifying the percentage of empty cells in the column.
- Option B is incorrect. Using Column Quality, not Show Whitespaces, is the correct option.
- Option C is correct. Column quality is the data preview option that is used to show the percentages of data that is in error, empty and valid.
- Option D is incorrect. Column distribution displays the data distribution within the column and the counts of unique and distinct values. It is not the right choice for the target goal.
Q3. Consider that you want to split your query into two parts. Which of the following options would you use in Power BI?
A. Format Query
B. Split Query
C. Extract previous
D. Mark Query
Explanation:
Correct Answer: C
Extract Previous is the option that helps in splitting the query into parts. If you want to split a query, right-click an applied step (as per desire or requirements) to the query and choose the exact previous option. It will split the query into 2 parts by making a new query consisting of all the steps before the selected step.
- Option A is incorrect. It is the Extract Previous option, not Format Query, that is used to split the query in Power BI.
- Option B is incorrect. It is the Extract Previous option, not Split Query, that is used to split the query in Power BI.
- Option C is correct. Extract Previous is the option that helps in splitting the query into parts in Power BI.
- Option D is incorrect. It is the Extract Previous option, not Mark Query, that is used to split the query in Power BI.
Q4. What is the use of Row Level Security (RLS) in Power BI?
A. Assigning the security permissions for the underlying Power BI Azure SQL Database
B. Adding the ability to link Power BI Log-in to organizational Active Directory or Window Login through Single Sign On (SSO)
C. Restricting data access for the given users ( By assigning users to roles)
D. Restrictions to specific measures within Power BI reports to some specific users
E. All the above
Explanation:
Correct Answer: C
The use of Row Level Security in Power BI is to restrict or limit the data access for the specified users. The Filters restrict the data access at row-level and filters can be defined within roles. In the Power BI service, the members can access the datasets in the workspace. Row Level security does not put restrictions on this data access.
- Option A is incorrect. RLS does not assign the security permissions for the underlying Power BI Azure SQL Database.
- Option B is incorrect. RLS does not add the ability to link Power BI Log-in to organizational Active Directory or Window Login through Single Sign On (SSO) is not the use of RLS in Power BI.
- Option C is correct. The use of RLS is to restrict data access for the given users ( By assigning users to roles).
- Option D is incorrect. RLS does not make restrictions to specific measures within Power BI reports to some specific users.
- Option E is incorrect. The given option is not the right choice.
Q5. Which of the following Azure Cognitive Services models can be called through the AI insights feature in Power BI Desktop? (Select Multiple Options)
A. Sentiment Analysis
B. Key Phrase Extraction
C. K-mean Clustering
D. Language Detection
E. Binary Classification
F. All of the above
Explanation:
Correct Answers: A, B, and D
AI Insights option in Power BI Desktop includes Azure Cognitive Services models -Sentiment Analysis, Key Phrase Extraction, and Language Detection. These models help derive the meaning or specific pieces of language from text data. For example, the Sentiment Analysis or Key Phrase Extraction option can be used to know the customer sentiments in the Help tickets and visually demonstrate the results in Power BI.
- Option A is correct as Sentiment analysis is an Azure cognitive services model that can be called through the AI insights feature of Power BI Desktop.
- Option B is correct as Key Phrase Extraction is an Azure cognitive services model that can be called through the AI insights feature of Power BI Desktop.
- Option C is incorrect as the K-mean clustering model is not available through AI insights to feature in Power BI Desktop.
- Option D is correct as Language Detection is an Azure cognitive services model that can be called through the AI insights feature of Power BI Desktop.
- Option E is incorrect as the Binary Classification model is not available through the AI insights to feature in Power BI Desktop.
- Option F is incorrect as K-mean clustering and Binary classification models are not available through the AI Insights feature.
Q6. Your team manager has given you a task to create a Power BI dashboard consisting of visualizations for sales data. You have been asked to add some questions that can be asked by the users while using the Q&A option. To enable the questions, what will you modify in the settings of Power BI?
A. Dashboards
B. Reports
C. Datasets
D. Workbooks
Explanation:
Correct Answer: C
To enable the questions for the users, it is the datasets that should be modified in Power BI settings.
- Option A is incorrect. It is the datasets, not the dashboards, that should be modified in Power BI settings.
- Option B is incorrect. It is the datasets, not the Reports, that should be modified in Power BI settings.
- Option C is correct. Datasets should be modified in Power BI settings to enable the questions for the users in Q&A analysis.
- Option D is incorrect. It is the datasets, not the workbooks, that should be modified in Power BI settings.
Q7. Which of the following tasks can be done only by the workspace admin, not by the users with lesser authorities and privileges?
A. Creating, editing, or deleting the content in the workspace
B. Publishing workspace content in the app
C. Adding or removing the other users from the workspace
D. Creating a report in another workspace depending upon the dataset of this workspace
E. Scheduling the data refreshes
Explanation:
Correct Answer: C
Out of the given tasks, only adding or removing the other users is the only task that can be performed only by the workspace admin. All other given tasks can be performed even by the members of the workspace.
- Option A is incorrect. Admin is not the only workspace role that can create, edit or delete the content in the workspace. Even the workspace members are able to do this.
- Option B is incorrect. Admin is not the only workspace role that can publish the content to an app. Even the workspace members are able to do this.
- Option C is correct. Only the workspace admin has the authority of adding or deleting other users from the workspace.
- Option D is incorrect. Creating a report in another workspace depending upon the dataset of this workspace is not the privilege of the admin only. Even the workspace members can do this.
- Option E is incorrect. Scheduling the refreshes is not the privilege of the admin only. Even the workspace members can do this.
Q8. Which of the following elements can you set in a bookmark? (Select Multiple Options)
A. The visibility property of some selected visuals in the selection pane
B. The visibility property of all visuals in the selection pane
C. The visibility properties of fields in the report pane
D. The list of visual types available in the visualization pane
E. The sort order on any visualizations that have been set
Explanation:
Correct Answers: A, B, and E
In a bookmark, you can set the visibility property of all visuals or the selected visuals in the selection panel as well as the sort order on any visualizations that have been set.
Bookmarks don’t capture the list of visuals available in the visualization pane as well as the visibility property of the fields in the report pane.
- Option A is correct. It is possible to set the visibility property of some selected visuals in the selection pane.
- Option B is correct. It is also possible to set the visibility property of all visuals in the selection pane.
- Option C is incorrect. Bookmarks don’t capture the visibility property of the fields in the report pane.
- Option D is incorrect. Bookmarks don’t capture the list of visuals available in the visualization pane.
- Option E is correct. It is possible to set the sort order on any visualizations that have been set.
Download the Complete DA-100 Exam Questions
When you have tested your knowledge by answering these DA-100 exam questions, I hope you have a clear stand in terms of your DA-100 exam preparation.
Note: K21Academy also offers a complete DA-100 Exam Questions Prep Guide where learners get to practice questions to test their Azure DA-100 exam preparation before the actual exam.
To download the complete DA-100 Azure Data Analyst Associate Exam Questions guide click here.
Related/References
- Microsoft Certified Data Analyst Associate [DA-100] step By step Activity Guides (Hands-on labs)
- Exam DA-100: Analysing Data With Power BI | Microsoft Data Analyst Associate
- Data Analysis in Power Bi for Beginners
- Introduction to Data Modelling In Power BI
Next Task For You
In our Azure Data Analyst Associate training program, we will cover 13 modules with 30+ lessons, 100+ Questions, and 12 Hands-On Labs. If you want to begin your journey towards becoming a Microsoft Certified: Azure Data Analyst Associate Then click here to Register for our Free Class
Leave a Reply