FREE Azure Data Analyst Associate Questions and Answers
The data from Azure Analysis Services cubes can be queried using which of the subsequent types of explanations? (Choose two correct answers)
Please select 2 correct answers
Explanation:
The explanations that are used to query the data from Azure Analysis Services cubes are Multidimensional Expressions (MDX) and Data Analysis
Expressions (DAX).
To query the data from Azure Analysis Services cubes, utilize MDX expressions.
To query the data from Azure Analysis Services cubes, use DAX MDX expressions.
Automatically scaling a program to make sure it has the resources required to satisfy user demands is an example of .
Explanation:
Elasticity is the capacity to adjust resources as required, such as increasing them during peak business hours to make sure an application can meet demand and then lowering them during off-peak hours. The capacity to quickly implement new apps and services is referred to as agility. In the event of a failure, a service or application can still be accessed because to high availability. A service or program is made available through geo-distribution in a number of areas, usually close to your users.
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?
Explanation:
Column Quality, Column Distribution, and Column Profile are data profiling features found in the Data Preview Section of the Power Query Editor's
View tab. Understanding data anomalies and statistics is made easier by these functionalities. Column quality is the only one of these three
functionalities that may be used to display the percentages of incorrect, empty, and valid data.
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?
Explanation:
Datasets in Power BI should be changed so that users may access the questions in Q&A analysis.
What among the following can you include in a bookmark? (Choose Three Responses)
Please select 3 correct answers
Explanation:
- Some selected visuals in the selection pane can have their visibility properties changed.
- All graphics in the selection pane can have their visibility properties set.
- Any previously set visualizations can have their sort order changed.
The term "_______________" refers to the process of quickly deploying and configuring cloud-based services as business requirements alter.
Explanation:
When you're agile, you can swiftly deploy and adjust cloud-based resources as your app's needs change. Scalability refers to the ability to modify a configuration by adding RAM, CPU, or complete virtual machines. Because cloud-based apps are elastic, you can set them up to use autoscaling so they always have the resources they require. Cloud-based apps with high availability can continue to offer a seamless user experience with no discernible downtime even when anything goes wrong.
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.
Please select 2 correct answers
Explanation:
When using IaaS or an on-premises implementation, clients are responsible for managing the operating systems. In PaaS and SaaS implementations, access to the operating systems is not possible.
Think about dividing your query into two pieces. Which options from the list below would you utilize in Power BI?
Explanation:
The option that aids in segmenting the query is called Extract Previous. If you wish to split a query, right-click a step that has been applied to the
query (according to your preferences or requirements) and select the identical previous choice. By creating a new query that includes all the stages
prior to the specified step, it will divide the original query into two halves.
What benefit does cloud computing offer over on-premises deployments?
Explanation:
Scaling more fast is made possible by cloud computing. Cloud computing does not include characteristics like owning your own CPUs or having complete access in the event of an internet outage. Unlike an on-premises implementation, working from numerous workstations is not unique to cloud computing.
What are the public cloud deployment model's two distinguishing features? Each accurate response offers an entire resolution. Select each appropriate response.
Please select 2 correct answers
Explanation:
In a public cloud, services are sold online and can be obtained by anybody who is interested. There can only be one organization using a private cloud. A third-party cloud service provider owns and manages cloud resources, such as servers and storage, which are then supplied over the internet. Computing resources utilized only by users from a single company or organization make up a private cloud.
You can deploy apps to local datacenters all over the world using ______________ in cloud computing.
Explanation:
To guarantee that your consumers always receive the greatest performance in their region, you can deploy apps and data to regional datacenters all over the world. This is known as geo-distribution.
What two traits do consumption-based models have? Each accurate response offers an entire resolution. Select each appropriate response.
Please select 2 correct answers
Explanation:
In a consumption-based model, you only pay for the resources you really use and are utilizing at the time. You no longer pay for a resource if you cease utilizing it. The purchase of physical infrastructure, which is not required in a consumption-based approach, is typically associated with high costs.
Why does cloud computing frequently cost less than on-site datacenters?
Explanation:
Operating costs can frequently be reduced by renting computing and storage resources and paying just for what you use. Charges may apply depending on the service and the type of network bandwidth. In particular for smaller enterprises, cloud service solutions frequently offer features that can be difficult or expensive to develop on-premises. Large cloud companies provide services globally. facilitating the quick and affordable deployment of services close to your users' locations.
Which of the following responsibilities can only be carried out by the workspace administrator and not by users with lower rights and privileges?
Explanation:
The only person with the power to add or remove users from the workplace is the workspace administrator.
What function does Power BI's Row Level Security (RLS) serve?
Explanation:
Row Level Security in Power BI is used to restrict or limit the users' access to the data. Row-level data access is restricted via filters, and roles can define
filters. The workspace's datasets are accessible to members of the Power BI service. This data access is not restricted by row level security.
Which type of cloud service gives you the most control over the equipment used to run applications?
Explanation:
The most adaptable group of cloud services is IaaS. It seeks to provide you total control over the computing resources used by programs. In PaaS, users are not in charge of the operating system or the servers that it runs on. Instead of building a platform to host software yourself, SaaS allows you to use software that is already hosted in the cloud.