Power bi certification - Study guides, Class notes & Summaries

Role Hierarchy ADMN, Member, Contributor, Viewer Admin Role All responsibilities Member Role Same as Admin but cannot assign roles, delete workspaces, or change metadata Contributor Role Can create, update, and publish and set refreshes for content and reports but cannot publish apps, delete reports change metadata or assign roles Viewer Role Can only view information Auto Date Hierarchy Day, Month, Quarter, Year Lineage View Shows last refresh and can identi...

You have a Power Bl workspace that contains several reports. You need to provide a user with the ability to create a dashboard that will use the visuals from the reports. What should you do? A. Grant the Read permission for the datasets to the user. B. Add the user as a Viewer of the workspace. C. Share the reports with the user. D. Create a row-level security (RLS) role and add the user to the role. E. Add the user as a member of the workspace. B You have a Power Bl workspace named...

Power BI Certification | Exam Questions & Answers (100% Correct) Power BI Certification | Exam Questions & Answers (100% Correct) When getting started with Power BI, what are the most commonly used versions? - ANSWER - Web and Desktop - While it's best to work with Power BI desktop, you can also follow along using the web version. True or False: When getting started with Power BI, scripting and test are the most commonly used versions. - ANSWER - False - It is best to use the graphical i...

You have a custom connector that returns ID, From, To, Subject, Body, and Attachments for every email sent during the past year. More than 10 million records are returned.You build a report analyzing the internal networks of employees based on whom they send emails to.You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.What should you do? A. Implement row-level security (RLS) so that the report recipients can only see results based o...

Power BI Certification Exam - DAX Formulas (2023-2024) | Questions & Answers (100% Verified) Power BI Certification Exam - DAX Formulas (2023-2024) | Questions & Answers (100% Verified) CALENDAR - ANSWER - Syntax: CALENDAR(<start_date>, <end_date>) Parameters: start_date - any DAX expression that returns a datetime value end_date - any DAX expression that returns a datetime value Return Value: Returns a table with a single column named "Date" containing a contiguous s...

Power BI Certification (2023-2024) | Questions & Answers (100% Correct) Power BI Certification (2023-2024) | Questions & Answers (100% Correct) What lets you connect data to other business applications? - ANSWER - Microsoft Dataverse What lets users connect to pre-wired connections? - ANSWER - PBIDS files What contains sites, document libraries, and folders? - ANSWER - Sharepoint Online What must be used to publish SSAS Tabular live connection data to Power BI Service? - ANSWER - Da...

Power BI Certification Test | Questions & Answers (100% Verified- Rated A+) Power BI Certification Test | Questions & Answers (100% Verified- Rated A+) What are the parts of Microsoft self-service business intelligence solution ? - ANSWER - A) Excel BI Toolkit - It allows user to create interactive report by importing data from different sources and model data according to requirement. B) Power BI - it is the online solution that enables you to share the interactive reports an queries tha...

Power BI Certification Exam Review | With Questions & Answers (Rated 100%) Power BI Certification Exam Review | With Questions & Answers (Rated 100%) 1. A data model has a fact table that has over 15 million rows. There is a date/time column called DateTime, which contains both date and time. You need to reduce the size of the data model. Your solution must preserve as much of the original data as possible. Which solution should you implement? A. Change the data type of the DateTime column t...

Power BI PL-300 Certification Exam Questions and Answers 100% CorrectPower BI PL-300 Certification Exam Questions and Answers 100% CorrectPower BI PL-300 Certification Exam Questions and Answers 100% CorrectPower BI PL-300 Certification Exam Questions and Answers 100% Correct There is a matrix using a standard date hierarchy. It is currently showing a range of years. How do you display just a specific year and that year's quarters? - ANSWER-Select 'Drill Down', and then the preferred data po...

Power BI Pl300 Certification Test | Complete Questions & Answers (100% Correct) Power BI Pl300 Certification Test | Complete Questions & Answers (100% Correct) You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.) The data has the following refresh requirements: Customer must be refreshed daily. Date must be refreshed once every three years. Sales must be refreshed in near real time . SalesAggregate must be refreshed once per week. You need to select th...