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

• Data Analysis Expressions (DAX) (Correct answer)
• PL/SQL
• Transact-SQL (T-SQL)
• Multidimensional Expressions (MDX) (Correct answer)

Correct answer: Data Analysis Expressions (DAX)

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?

• Column quality (Correct answer)
• Column distribution
• Column profile
• Show Whitespaces

Correct answer: Column quality

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?

• Mark Query
• Format Query
• Split Query
• Extract previous (Correct answer)

Correct answer: Extract previous

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?

• Restrictions to specific measures within Power BI reports to some specific users
• Adding the ability to link Power BI Log-in to organizational Active Directory or Window Login through Single Sign On (SSO)
• Restricting data access for the given users ( By assigning users to roles) (Correct answer)
• All the above

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

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?

• Workbooks
• Datasets (Correct answer)
• Dashboards
• Reports

Correct answer: Datasets

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.

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?

• Creating a report in another workspace depending upon the dataset of this workspace
• Scheduling the data refreshes
• Adding or removing the other users from the workspace (Correct answer)
• Publishing workspace content in the app

Correct answer: Adding or removing the other users from the workspace

In Power BI workspaces, the ability to manage user access, specifically adding or removing users and assigning them roles (Admin, Member, Contributor, Viewer), is a privilege reserved for users with the 'Admin' role. Other roles have more limited permissions, such as creating reports or scheduling refreshes, but they cannot control who has access to the workspace itself.

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

• The list of visual types available in the visualization pane
• The sort order on any visualizations that have been set (Correct answer)
• The visibility property of some selected visuals in the selection pane (Correct answer)
• The visibility property of all visuals in the selection pane (Correct answer)

Correct answer: The sort order on any visualizations that have been set

Power BI bookmarks allow you to save the current state of a report page, which includes the sort order applied to any visualizations. Bookmarks also capture the visibility property of visuals, meaning you can show or hide specific visuals or all visuals on a page using the selection pane, and this state will be preserved. This enables dynamic report views and storytelling.

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

• A different cloud service provider owns and manages the servers and storage. (Correct answer)
• Users from a single organization use computing resources solely.
• Anyone who wants to buy services has access to them through the internet. (Correct answer)
• The on-site datacenter of a company is where hardware is actually kept.

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

Public cloud deployment models are characterized by services offered over the public internet to anyone who wants to purchase them. In this model, the underlying hardware, including servers and storage, is owned and managed by a third-party cloud service provider, not the individual users. This makes services broadly accessible and managed externally.

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

• Demands the acquisition and administration of the physical infrastructure.
• High capital expenditures.
• No upfront expenses (Correct answer)
• The capability of ceasing to pay for resources that are no longer required (Correct answer)

Correct answer: No upfront expenses

Consumption-based cloud models are defined by their pay-as-you-go nature, meaning there are typically no upfront capital expenditures for hardware or infrastructure. Users only pay for the resources they actually consume, and they have the flexibility to stop paying for resources once they are no longer needed, aligning costs directly with usage and minimizing waste.

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

• It's free to use network bandwidth.
• You only pay for what you really use. (Correct answer)
• The functionality of cloud service solutions is constrained.
• Services are only provided in one specific area.

Correct answer: You only pay for what you really use.

Cloud computing often costs less than on-site datacenters because it operates on a consumption-based, pay-as-you-go model. This means users only pay for the specific resources and services they actually consume, eliminating the need for large upfront capital investments in hardware and infrastructure that might sit idle. This optimizes resource utilization and reduces overall expenditure.

Question 11: What benefit does cloud computing offer over on-premises deployments?

• You have access to several workstations.

A key benefit of cloud computing over on-premises deployments is its inherent scalability and elasticity. Cloud services allow organizations to rapidly provision or de-provision resources as needed, ensuring applications can handle fluctuating demands without over-provisioning or experiencing performance bottlenecks. This flexibility reduces capital expenditure and operational overhead.

Question 12: The term "_______________" refers to the process of quickly deploying and configuring cloud-based services as business requirements alter.

• Scalability
• Elasticity
• High availability
• Agility (Correct answer)

Correct answer: Agility

Agility in cloud computing refers to the ability to rapidly deploy, configure, and manage cloud-based services and applications in response to changing business needs. This allows organizations to quickly adapt, innovate, and bring new solutions to market without the delays associated with traditional infrastructure provisioning. It emphasizes speed and responsiveness to change.

Question 13: Automatically scaling a program to make sure it has the resources required to satisfy user demands is an example of .

• High availability
• Elasticity (Correct answer)
• Agility
• Geo-distribution

Correct answer: Elasticity

Elasticity in cloud computing is the ability of a system to automatically scale its resources up or down to meet fluctuating demand, ensuring optimal performance and cost efficiency. This automatic scaling ensures that applications always have the necessary resources to handle user demands without manual intervention, preventing both under-provisioning and over-provisioning.

Question 14: You can deploy apps to local datacenters all over the world using ______________ in cloud computing.

• High availability
• Disaster recovery
• Elasticity
• Geo-location (Correct answer)

Correct answer: Geo-location

Geo-location (or geo-distribution) in cloud computing refers to the ability to deploy applications and services to local datacenters across various geographical regions worldwide. This allows organizations to place resources closer to their users, improving performance, reducing latency, and meeting data residency requirements. It enhances global reach and user experience.

Question 15: Which two deployment patterns place management of the operating systems that run the applications on the shoulders of the customers? Each accurate response offers an entire resolution. Select all applicable answers.

• infrastructure as a service (IaaS) (Correct answer)
• on-premises (Correct answer)
• software as a service (SaaS)
• platform as a service (PaaS)

Correct answer: infrastructure as a service (IaaS)

In both Infrastructure as a Service (IaaS) and on-premises deployments, customers retain significant responsibility for managing the operating systems that run their applications. With IaaS, the cloud provider manages the virtualization layer, but the customer is responsible for the OS, middleware, and applications, similar to an on-premises setup where the customer manages everything from the hardware up.

Question 16: Which type of cloud service gives you the most control over the equipment used to run applications?

• Platform as a service (PaaS)
• Infrastructure as a service (IaaS) (Correct answer)
• Software as a service (SaaS)

Correct answer: Infrastructure as a service (IaaS)

Infrastructure as a Service (IaaS) provides the highest level of control over the underlying computing infrastructure compared to Platform as a Service (PaaS) or Software as a Service (SaaS). With IaaS, users manage virtual machines, operating systems, applications, and network configurations, giving them extensive control over the environment where their applications run.