Hub for All Education Needs
Correct Answer for the Question – What should you do in the Power BI service? is given below You create a report in the Power BI service.You plan to provide external users with access to the report in the blog post will be updated as the data is refreshed.What should you do in the Power BI … Read more
Correct Answer for the Question – How should you configure the connection to the data source? is given below You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be shared between the users in your organization.The … Read more
Correct Answer for the Question – What should you include in the recommendation? is given below Your company has a security policy stating that proprietary data must not be transferred over the Internet.During a security audit, auditors discover that executives use the Power BI service for reporting.You need to recommend a solution to ensure that the … Read more
Correct Answer for the Question – What should you do in the model before you create the relationship? is given below You plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart.The date value in ActivityDate is a number column named … Read more
Correct Answer for the Question – Which DAX formula should you use? is given below You have a Power BI model that contains the following two tables:Assets (AssetID, AssetName, Purchase_DateID, Value) Date (DateID, Date, Month, Week, Year)The tables have a relationship. Date is marked as a date table in the Power BI model.You need to create … Read more
Correct Answer for the Question – What should you install first? is given below You need to create a custom visualization for Power BI.What should you install first?References: https://docs.microsoft.com/en-us/power-bi/service-custom-visuals-getting-started-with-developer-tools jQuery Node.js Microsoft Azure PowerShell Microsoft.NET Correct Answer The Correct Answer for this Question is Node.js Explanation The Question – What should you install first? has been … Read more
Correct Answer for the Question – Which DAX function should you use? is given below You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales.You need to compare the year-to-date sales with the previous year for the same time period.Which DAX function should you use?References:https://powerpivotpro.com/2016/01/year-to-date-in-previousprior-year/ DATEADD TOTALYTD DATESYTD … Read more
Correct Answer for the Question – What should you do before you publish the report? is given below You are creating a Power BI Desktop report that has several bar charts and a date slicer.You need to create a slide show that can be viewed from the Power BI service. Each slide must display the charts … Read more
Correct Answer for the Question – What should you do to resolve the issue? is given below You have a Power BI Desktop project that uses DirectQuery to access an on-premises Microsoft SQL Server database.From Power BI Desktop, you can query the database.When you publish the Power BI Desktop project to the Power BI service, the … Read more
Correct Answer for the Question – Which command should you use? is given below You have the following two queries in Power BI Desktop:• A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database• A query named Query2 that retrieves a table named Enterprise_Customers from an Oracle Server databaseBoth tables … Read more
