Your company wants you to prepare a dashboard that shows the reports for 10 years of sales data. These reports will be used by company directors to see the monthly sales performance. You need to get data of 10 years from SQL server database. Is Direct Query best option to use in this scenario?

Which command in the Power BI Desktop query editor is used to create a new query that uses the output of another query as its input source?

The management requested two Power BI reports to be produced: one that shows all sales data, including transactions that happened in the past 10 minutes, and another report that tracks historical targets versus actual figures for the past 12 months. Historical report is prepared at the beginning of every month. Based on background information and business requirements, answer the following questions: Which data connectivity mode should you use for each report?

What is it called when multiple records in one table are associated with multiple records in another table?

You work as an analyst at Cat Slacks and you've just been handed a csv file with yearly sales by department. After connecting to it in Power BI, you notice that each year has its own column. Which Power Query tool can you use to turn the multiple "Year" columns into rows?

You are the BI developer at Adventure Works responsible for enabling report creation and sharing by business users. Currently, there is an on-premises data warehouse built with SQL Server 2017, and there are some files stored on a shared drive that contain sales targets. The files are updated manually on a weekly basis. All reports need to be refreshed automatically at-least once a day. Everyone in the organization has a Power BI Pro license. Adventure Works has a hot-desking policy, and all employees must lock their laptops in allocated cabinets. Some business users would like to be able to create their own reports and share them internally. Only a select group of users must have the rights to share reports externally. Adventure Works has a separate manager for each product category. One of the reports must be secured in such a way that each manager must be able to see the products of the category they manage only, while the CEO must be able to see all sales. An HR analyst maintains a table that maps the category name to the manager email address. The management requested your assistance in making sure that business users can create and share their Power BI reports within the organization. Based on background information and business requirements, answer the following question Business users ask your guidance on how they should configure automatic refresh. Which gateway installation mode is appropriate for Adventure Works?

When would you use a tool from the Transform tab over the Add Column tab?

To create a DAX formula that automatically calculates the previous month number as calculated column, for example if the month is 6 then formula should return 5. Month columns is calculated from date with formula below. Month = MONTH (Sales [Date]), Which of the following DAX formulas returns correct number for previous month?

Which of these is NOT a data model best practice?

Which of the following report page details are not recorded when you create a bookmark?