Microsoft Power BI Test - 6 Welcome to your Microsoft Power BI - Test-6 Name Email Phone Q1. You have a Power BI model that contains the following tables: Consider a new table named SchoolYearDate which has the same columns schema as the Date table. You want to create a report that shows the total Enrollments by SchoolYearDate and Calendar Month.How can you achieve the task?Select 1 option(s): Add SchoolYearDate to the model and create a one-to-many relationship with the Enrollments Table. Append SchoolYearDate into the Date table. Union SchoolYearDate and Date as one table. Delete Date Table and use SchoolYearDate as the main Date table. None Q2. Consider two Microsoft SQL Server databases named SQLtest and SQLlive. Both the server databases contain the same tables. You create a new Power BI Desktop project based on 50 tables from SQLTest. Before publishing the report to Power BI Service, you need to connect the project to tables in SQLlive.What should you do in the Query Editor, with a low administrative effort, in order to meet the goal?Select 1 option(s): Edit the on-premises gateway settings. Configure the Data source settings. Change manually the data source for each table. Copy the model into another PowerBI Project. None Q3. Consider the table shown in the picture: All cells in the date column must contain a date. You want to replace null values with the date from the previous row.Which command should you run in Power Query?Select 1 option(s): Fill, and then Down. Replace Errors. Remove errors. Date, and then Earliest. None Q4. Your colleague has shared with you a file containing a dataset about global market sales. After importing it inside your Power BI Desktop, you want to get a quality profile of the dataset. How can you achieve this task?Select 1 option(s): From Power Query, check the data profiling functionalities. Create a table visual which contains all the dataset columns, then order columns by errors and blank values. Create a DAX calculated column that uses the FILTER function. From Power BI Desktop, set a Page Filter that includes only errors and blank rows. None Q5. Consider two tables named Tab1 and Tab2 that retrieve data from an Oracle database. Both tables have the same data structure. You plan to combine the data from Tab1 and Tab2. Select the right command to use.Select 1 option(s): Append Queries. Combine Files. Merge Queries. Merge Rows. None Q6. Consider the tables shown in the picture: The tables come from a Microsoft SQL Server database.The Enrollments table contains more than two million rows. You plan to import a sample of data from the Enrollments table in Power BI Desktop.There are two ways to achieve the goal from the following options, select them.Select 2 option(s): From Query Editor, create a column by using Custom Column command From Query Editor, filter the table by Enrollment_date. From Query Editor, add a SELECT statement that uses a WHERE clause. In the Power BI Service, create a calculated table. From Query Editor, create a custom column that SAMPLE Function. Q7. Consider the table shown in picture 1: You want to configure the table as shown in picture 2: Which command should you use?Select 1 option(s): From the Split Column menu, click By Delimiter. From the Extract menu, click Text After Delimiter. From the Format menu, click Trim. From the Extract menu, click Last Characters. None Q8. You have imported a data source in Power BI Desktop, now you plan to use Power Query to add some data transformations. You notice that the data model presents a huge list of queries that make it difficult to organize the transformation steps.Which best practice can you adopt in Power Query to solve this issue?Select 1 option(s): Append queries when it is possible. Reduce the list of queries by importing small parts of the original dataset. Create a group of queries to classify the data-transformations. Re-name all the queries with a classification syntax. None Q9. Consider the table shown in the picture: You want to replace the ”-” value in the DISCOUNT_CODE column with the text ”NO_DISCOUNT”.Which M function completes the following formula?Select 1 option(s): Text.Replace Column.ReplaceValue Text.Clean Table.ReplaceValue None Q10. Consider a Power BI Model containing the tables shown in the picture. Course[CourseName] contains NULL values. You plan to add a new column to the Course table that uses the following formula:=if [CourseName]=null then “NA” else [CourseName]Select the option available in the Query Editor to meet the goal.Select 1 option(s): Index Column. Column From Examples. Conditional Column. Pivot Column. None Q11. You are working on the Contoso Sales report in Power BI. It relies on a large dataset. The Sales[DateKey] column is in the Date/time format as shown: What can you do to improve performance when you are getting data in Power BI?Select 1 option(s): Compress the databes into a zip file. Use the CALENDARAUTO function in DAX. Separate date and time into two distinct columns before importing them into Power BI. Delete the Sales[DateKey] column. None Q12. In your Power BI report, you have the Sales table that has the following column: The Sales table contains one million records per month. You want to minimize the data model size. Plus, you want to count sales by Date and Store. How can you meet the two goals?Select 1 option(s): Create a calculated measures with the COUNTROWS function. Create a calculated table with the SalesAmount column. Use the Group by function in Power Query, aggregating sales by DateKey and StoreKey using Sum as operation. Use the Group by function in Power Query, aggregating sales by DateKey and StoreKey using Count Rows as operation. None Q13. You want to import 50 Microsoft Excel files to Power BI Desktop. All the files share the same structure and are they stored in a unique desktop local folder. You plan to import all Excel files into one table. How can you achieve the goal?Select 1 option(s): Add a Microsoft Excel data source and select all the files in the folder Add every single file to the model and then use the Merge Queries command. Add a folder data source and use the Combine Files command. Add a folder data source and use the Append Queries command. None Q14. Consider the table shown in the picture: You want to create a custom column that hides the first seven digits of the NationalCode. The values in the new column should be displayed in the following format: xxx-xx-0000Select the proper order of targets to complete the formula:Select 1 option(s): Text.Insert - Text.Start Text.Insert - Text.Replace Text.Replace -Text.Start Text.Insert - Text.end None Q15. You have connected a Microsoft SQL Server Analysis Services (SSAS) cube to Power BI Desktop, generating the following query: The query retrieves 10,200 records. After checking the data source, you discover that there are 21,300 records.How can you ensure that the query retrieves all 21,300 records?Select 1 option(s): Delete the Remove Duplicates steps. Change the query to use Direct Query mode. Change the query to use Import connection mode. From Power Query, select Unpivot Columns command. None Q16. You have created a query to append the rows of three different tables that contains product data into one table named Products. Now you need to set-up a new ID Column to be sure that every row in the Products table contains a unique value.How can you meet the goal?Select 2 option(s): Add an Index Column to Products Table. Select a Product Table Column and click Remove Duplicates. Add a Column from Examples to Products Table. Add a counter column to Products Table. Q17. Consider the following tables: You plan to create a relationship between the Enrollments table and the Courses table on the Course _ ID column.What task do you need to perform before creating the relationship?Select 1 option(s): In the Courses table query, use the Table.TrasformColumnTypes function. In the Course table query, use the Table.TrasformRows function. In the Enrollments table query, use the Tables.GetRelationships function. In the Enrollments table query, use the Table.TrasformRows function. None Q18. You have the tables shown in the picture: There is a relationship between tables, you want to create a report in Power BI Service that shows TotalPaid by EnrollmentDate and by CourseName.N.B. Only the required columns must be shown in the report.Select the right configuration of EnrollmentID column and TeacherID column.Select 1 option(s): From Query Editor, click on "Choose Columns" and remove the TeacherID column, then in the report view hide the EnrollmentID column. From Query Editor, select EnrollmentID and click Remove other Columns then select TeacherID and click Hide. From Query Editor, select EnrollmentID and click Remove Columns then select TeacherID and click Hide. None Q19. Consider two tables named Course and Teacher. In the picture, you can find a sample of data for the tables. You want to know which Teacher is responsible for which course.Which kind of Join should you use?Select 1 option(s): Left Join. Right Join. Outer Join. Inner Join. None Q20. You have imported a dataset in Power BI Desktop from an Excel File. During the tables profiling, you discover two columns that need to be fixed: – ColumnA presents several values starting with space;– ColumnB contains several non-printable characters.Which couple of commands should you use to fix the above column errors?Select 1 option(s): ColumnA: TRIM - ColumnB: CLEAN ColumnA: LENGHT - ColumnB: TRIM ColumnA: CLEAN WHITE SPACES - ColumnB: TRIM ColumnA: CAPITALIZE EACH WORD - ColumnB: CLEAN None Q21. Consider the table named Courses shown in the picture: You plan to create a relationship between the Courses table and another table called Enrollments.Which function let you optimize the query for Courses before creating the relationship?Select 1 option(s): Table.IsDistinct Table.Join Table.Group Table.Distinct None Q22. Consider a column named Product_SKU. The values in the column have the following format: • 7271-1123×998• 7271-1123×945• 7271-1123×924The values after x in the Product_SKU column indicate the SKU extension. You plan to create a custom column in Query Editor that contains only the SKU extensions.Select the right order of functions to complete the following formula:Select 1 option(s): AFTERDELIMITER - REMOVERANGE POSITIONOF - REMOVERANGE POSITIONOF - TRIMEND AFTERDELIMITER - RELATIVEPOSITION None Q23. How do you know that the TotalCost column has 0% of empty rows? Select 1 option(s): Thank to the DAX PERCENTAGES formula. Thanks to the column quality tool in Power Query. Thanks to the column distribution tool in Power Query. Thanks to the column profile tool in Power Query. None Q24. Consider a table named Enrollments that contains a column named StudentID. The Data Type of StudentID is ”whole number”. After you have imported tables in Power BI Desktop, you discover that the StudentID column contains several non-numeric values. You want the non-numeric values in the StudentID column set to 0. How can you achieve the goal?Select 1 option(s): The solution must request a low transformation effort. From Query Editor, open Advanced Editor and use Text.Remove function. From Query Editor, select the StudentID column and click Remove Errors. From Query Editor, select the StudentID column. Click Replace Errors and set a value of 0. From Query Editor, open Advanced Editor and use Text.Format function. None Q25. Consider a Power BI report that contains a Pie chart and a Line chart on the same page. The Line chart displays the total Enrollments by Year, while the Pie chart displays the total Enrollments by course. You want to ensure that when you select a year on the Line chart, the Pie chart remains unchanged.How can you perform this task?Select 1 option(s): Edit the interactions from the Format menu. Delete the relationship between the Enrollments table and the Date table. Set a visual level filter on the report page. Set a visual level filter on the Pie chart. None Q26. You are configuring a Gauge Chart. Where do you set the Goal? Select 1 option(s): Power Query. Calculated column. Format settings. DAX Formula. None Q27. Consider a table that contains the last two years of sales data. You want to identify the outliers. Which type of visual best fits your needs?Select 1 option(s): Key Influencers. Bar chart. Scatter plot. Area chart. None Q28. You plan to use R Scripting in Power BI Desktop to create several visualizations. Which actions should you perform to use R scripting in Power BI Desktop?Select 1 option(s): You don't need to perform any action: R scripting is available in Power BI Desktop by default. Download and install RStudio on the computer that has Power BI Desktop installed. Download and install R plug-in for Power BI Desktop. Download and install Microsoft R on the computer that has Power BI Desktop installed. None Q29. Consider a report in Power BI Desktop that contains several donut charts and a date slicer. You plan to create a slide show that displays the donut charts filtered by different years. You want that the slide show can be used from Power BI Service.What should you do before publishing the report?Select 1 option(s): Filter the donut charts by using the slicer, then create bookmarks. Configure page level filters, and then create groups that use the Bin group type. Configure drillthrough filters for each bar chart, and then select Selection Pane. Configure report level filters, and then create groups that use the List group type. None Q30. Your workspace contains 10 dashboards. You want to allow users to find data by using natural language queries. What should you do to meet the goal?Select 1 option(s): From the properties of the dashboard, modify the Q&A settings. From the Power BI Desktop disallow Q&A option to the reports. From the properties of the datasets, modify the Q&A settings. Pin a Q&A tile into the dashboards. None Q31. Consider the following table scheme: Note that in the Date table, the date_id column has a format of yyyymmdd and the month column has a format of yyyymm.The week column in the Date table and the week_id column in the Weekly_Returns table have a format of yyyyww.You are in charge of building a Power BI report following these requirements:The Enrollments managers ask for a visual to analyze enrollment performance versus enrollment targets. You must include in the visualization a time trend across months.Which visualization object should you select?Select 1 option(s): Multi row card. KPI. Gauge. Key Influencers. None Q32. You want to use Python Scripting in Power BI Desktop in order to create several visualizations. After you have installed and configured Python for Power BI Desktop, you try to run the following code: from matplotlib import pyplot;ax = pyplot.gca();dataset.plot.line(x = ‘Courses’, y = ‘Total Enrollments’, color = ‘green’, ax = ax)Power BI Desktop returns the following error message: How can you fix the issue?Select 1 option(s): You should add the following command to the script: pyplot.show(); You must enable the Pyhton Visuals before running code. You need to refresh the IDE settings. You must refresh the dataset origin connection. None Q33. You have a table named Enrollments with the following columns: – StudentID;– CourseID;– Date;– CourseName;– FeePaid.You create a report that contains a Stacked Column Chart that shows the count of Students by CourseName, then you want to customize the information placed in the visualization tooltip for the chart.What should you do first?Select 1 option(s): Create a new report page and set it as Tooltip. Disable the tooltip option from the Format pane of the Stacked Column Chart. Set the CourseName column as Tooltip field. Set the StudentID column as Tooltip Field. None Q34. You create a Power BI Desktop project named Enrollments_BI that contains a table with the following columns: – StudentID;– StudentName;– City;– ProvState;– Country.You configure a bar chart to display the number of students by Country, and drill down to ProvState, and in the end to City.You publish the Enrollments_BI project to Power BI Service and plan to share it with your colleagues: how could you share it?N.B. Your colleagues must be able to use the Drill Down feature.Solution: You create a dashboard and pin the Bar Chart visualization to it, then share the dashboard with your team.Does this solution meet the goal?Select 1 option(s): No Yes None Q35. Consider a table containing the following columns. – Date;– Funds;– Expenses.You configure a Line and Clustered Column Chart as the following:– Date Column as Shared Axis– Funds Column as Line Values– Expenses Column as Column ValuesYou notice that the Line Values doesn’t’ match the correspondent Y-axis Values and it is set on the top of the chart by default as shown in the picture: How can you fix the visualization?Select 1 option(s): Set to Auto the Y-axis 'start' and 'end' settings. Remove the Default Summarization from the Funds column. Remove the Default Summarization from the Expenses column. Edit the data type of Funds column as a Whole Number. None Q36. You have created a Power BI dashboard that contains visualizations of sales data. You want to enable sample questions that users can ask when using the Q&A option.What do you need to modify in the Power BI Settings?Select 1 option(s): Reports. Dashboards. Datasets. Workbooks. None Q37. You plan to create a Corporate Power BI Desktop Project that will be shared with the entire organization. You need to customize the report with both the corporate colors of your organization and a set of custom icons.How can you meet the goal?Select 1 option(s): The solution must request the lowest administrative effort. Select the visualization you want to add to the report, then edit their color properties from the Format Pane. Configure an XML file and then import it in Power BI Desktop as Custom Theme. Configure a JSON file and then import it in Power BI Desktop as Custom Theme. Access to Power BI Theme Gallery and import a blank theme, then customize it. None Q38. Your Power BI report contains a clustered bar chart that has Sales[ReturnAmount] as the value and Product[ProductKey] as the axis. You want to improve the visual by adding a horizontal line that shows which products have a return amount above the median amount.How could you reach the goal?Select 1 option(s): In the Analitycs pane for the clustered bar chart, add a Percentile line set to 50%. In the Format pane for the clustered bar chart, add a Constant line and set it to 0.5. In the Analitycs pane for the clustered bar chart, add a Constant line and set it to 0.5. In the Analitycs pane for the clustered bar chart, add a Trend line. None Q39. You have a dashboard named Sales_01. Q&A is enabled on the dashboard. When users try to get the count of clients, the query fails. Instead, when users ask for the count of subscribers, they receive the expected results. You want to ensure that both queries will return the same results. Which action should you perform?Select 1 option(s): Edit Synonyms from Power BI Desktop. Edit tables from Power Query in Power BI Desktop. Edit Relationships from Power BI Desktop. Edit Synonyms from Power BI Service. None Q40. Consider a table named Students with the following columns: – StudentID;– StudentName;– City;– ProvState;– Country.You are creating a Power BI report that includes a bar chart to display the number of students by location. You want that the report will show the number of students by Country, and drill down to ProvState, and in the end to City.Select the right configuration of the drill down in the bar chart.Select 1 option(s): In the Legend field, add ProvState. In the Axis field, add Country and City. In the Value field add all the columns in the following order: Country, ProvState, City. In the Value field, add Country. In the Axis field, add ProvState and City. In the Axis field, add all the columns in the following order: Country at the top, followed by ProvState and City. None Q41. You are building a complex report in Power BI, full of visuals. You want to be sure that the user will read it in a logical way when he/she uses the keyboard.On what should you have to work on?Select 1 option(s): Filters hierarchy. Tab order. Page order. Layer order. None Q42. Consider a table named Enrollments that contains enrollments data for Europe. Check the sample dataset in the picture: You try to create a map to show Enrollments by Area, but you find out that the map doesn’t work.What can you do to fix the map visualization?Select 1 option(s): Add a column that contains latitude and longitude. Create a table named Country and create a relationship with the Enrollments table. Select the Area field. From the Modeling tab, change the Data Category. Select the Area field. From the Modeling tab, change the Data Type. None Q43. You have a Microsoft Excel file named Enrollments.csv that contains data about Student Enrollments by Region. After you have imported the Excel file to Power BI Desktop, you create a bar chart showing the Enrollments amount by region.Unfortunately, the Enrollments amount value appears as the count of Enrollments amount instead of the sum of Enrollments amount for each region.You need to modify the query to ensure that the data appears correctly.How can you fix the issue?Select 1 option(s): Change the Data Type of Enrollments amount column to Whole Number. Create a calculated column that use the SUM function. Delete the query, import the data into Microsoft One Drive for Business, and then from Power BI Service connect to the Enrollments.csv by clicking import. Create a calculated measure that uses the SUMX function. None Q44. Your Power BI model contains two tables named StoreVisits and Date. After you have created a measure to calculate the number of Store Visits, you use it in a report visualization as shown in the picture. You found that the total number of customer visits was 60,000 and that there were only 5,000 customer visits in August. You check that the total number of visits was 90,000 and that there were only 10,000 visits in October.How can you fix the report visualization?Select 1 option(s): Disable the default Summarization to the Number of visits column. Modify the measure to use the sum DAX function. Create a relationship between the StoreVisits and the Date table. Modify the measure to use the Count function. None Q45. An area chart shows the discount quantity over years. Therefore, when you hover the mouse over a data point, you will see the discount quantity at a certain year: How could you provide additional information about the discount amount, on the black label?The result should be as the following picture:Select 1 option(s): Add the DiscountAmount column on the secondary values. Add the DiscountAmount column on the tooltip. Set a drillthrough option for the visual. By right-clicking on the visual, select Analyze. None Q46. Your principal asks you to print some Power BI reports in order to physically share them with the other colleagues during the next meeting. When you start to print the reports, you notice that some tables show less rows than they really have.How can you solve this issue?Select 1 option(s): Change the table visual to a matrix visual. Group the rows of the table to reduce its size. Extend table visual to the whole page. Create a Paginated Report. None Q47. Consider a table named Enrollments containing the sample data shown in the picture. After you have created a stacked bar chart to display CourseName by StartingDate, you notice that the axis shows all the individual dates. You want to set the drill down in the chart to display CourseName by year, by week, and day.What is the first task to do?Select 1 option(s): From the Format Pane of the Chart set the type of the Y-Axis to Categorical. Create a new table that has columns for the date, year, week, and day. From the Format Pane of the Chart set the type of the X-Axis to Categorical. None Q48. You plan to create a custom visualization for Power BI. What do you install first? Select 1 option(s): Microsoft Azure PowerShell Node.js Power BI Service JavaScript None Q49. Consider a table named Enrollments that contains the following three measures: – A measure named Total Enrollments Last Year shows the Enrollments from the previous calendar year. The current value is 52,000.– A measure named Total Enrollments This Year shows the Enrollments from the current calendar year. The current value is16,000.– A measure named Total Sales Difference based on the following DAX formula: Enrollments[Last Year] – Enrollments[This Year].You need to create the following visualization. You plan to create a Gauge visualization by using the measures above. Select the right configuration for the visualization.Select 1 option(s): Value: Total Enrollments this Year - Maximum Value: Total Enrollments this Year - Target Value: Total Enrollments Last Year Value: Total Enrollments this Year - Maximum Value: Total Enrollments last Year - Target Value: Total Enrollments Last Year Value: Total Enrollments last Year - Maximum Value: Total Enrollments last Year - Target Value: Total Enrollments this Year Value: Total Enrollments last Year - Maximum Value: Total Enrollments this Year - Target Value: Total Enrollments Last Year None Q50. Consider the table shown in the picture: You add Country and Enrollments columns to a table visualization in Power BI Desktop and the result appears as in the following picture: Why does it show three rows of data instead of six?Select 1 option(s): Data Category of Country is set to Country. The Enrollments column data type is set to text. Because of Default Summarization on Country. Because of Default Summarization on Enrollments. None Q51. You are analyzing the Customer Sales monthly report and you notice that the Churn Rate metric is strangely increased. You want to understand which variables may affect this result.Which solutions can help you to explore the possible causes in Power BI Desktop?Select 2 option(s): Decomposition tree visual. Enable the Auto ML. Use the Gauge visual. Use the Key Influencer visual. Q52. Your Organization plan to create a Power BI App which would include Power BI dashboards and other custom content. The App will be available to all Organization users. You need to be sure that all the PowerBI users will have access to the App.Select 1 option(s): NB The solution must request the lowest administrative effort. Add each user to the app workspace and give him "member" permissions. Create an Office 365 Group named "all organization users" and give it app workspace "member" permissions. Create an Office 365 group named "all organization users" and share the link to get the App. Ask the PowerBI admin for enabling permission to install the app automatically to all users. None Q53. You have an app workspace. You collaborate in the app workspace with a user named User_01. User_01 is a member of the workspace. You plan to create a report that retrieves data from a Microsoft SQL Server database. You want that User_01 can edit the report both from Power BI Desktop and from powerbi.com. Select the right order of the actions to achieve the goal.Select 1 option(s): From Power BI Service, create a report - From Power BI Service share the report in the App Workspace - From the App Workspace settings, allow User_01 to export data from the report. From Power BI Service, create a report - From Power BI Service share the report with User_01. From Power BI Desktop, add a data source - From Power BI Desktop, create a report - From Power BI Desktop, publish the report to the Power BI Service. From Power BI Desktop, create a report - From Power BI Desktop, publish the report to the Power BI Service - Deploy an On-Premises Data Gateway (personal mode). None Q54. You have a report named Sales in an app workspace named Sales_BI. User_01 is a member of the Sales_BI. You have enabled the option ”Allow users to build new content using the underlying dataset” from the report settings.What will happen to the underlying dataset? Select the true statements.Select 2 option(s): Row-level security restrictions on the dataset are in effect. You haven't made a copy of the dataset. The dataset still resides in its original location. You have made a copy of the dataset. The dataset is duplicated in your workspace. Q55. You manage a list of reports for the sales team of your company. The company operates across different regional markets and every region has its sales manager. You need that the sales managers can interact with the data from their region. In addition, you want that sales managers can’t modify the report’s layout.Note that the datasets use row-level security (RLS).How can you meet the goal?Select 1 option(s): Disable Row Level Security. Create a Power BI app that contains all the reports and give access permissions to the sales managers. Create a new workspace, duplicate the datasets and reports, add the sales managers as owners of the workspace. Publish the reports to a workspace and store the datasets in another one. None Q56. You have a Power BI app workspace that contains 30 reports shared with 55 users of your organization. You plan to start a reports maintenance program. You need to know which reports present a critical usage.How can you achieve this task?Select 1 option(s): Check the activity log by using the Power BI Management cmdlets for PowerShell. Request to the Power BI admin enabling usage metrics for content creators. Go to the Health tab in the Capacity settings area in the Admin portal. You can use the Power BI Premium Capacity Metrics App. None Q57. You have a table named ‘Enrollments’ stored on a Microsoft Excel spreadsheet. You want to add the Enrollments table to a Power BI dashboard as a tile.What is the tile configuration?Select 1 option(s): From Excel, import the workbook to PowerBI Desktop, then publish it to PowerBI Service. From the Power BI service, upload the Excel workbook. From the Power BI service, import the data from the Excel workbook. From the Power BI tab in Excel, pin the table. None Q58. You plan to publish a report from Power BI Desktop to Power BI Service. The report retrieves data from an Azure SQL Database. How can you ensure that users of your organization will see the current data when they access the report on the Power BI Service?Select 1 option(s): In the Power BI service's Settings page, select the Datasets tab, choose the dataset that uses DirectQuery, and select Edit credentials. Deploy an on-premises data gateway (personal mode). Connect to the data by using the DirectQuery Data Connectivity mode. Deploy an on-premises data gateway (personal mode). Connect to the data by using the Live Connectivity mode. Deploy an on-premises data gateway. Connect to the data by using the DirectQuery Connectivity mode. None Q59. A Power BI user in your organization has published a report to the Web. The report contained sensitive data. What can you do to prevent the reports from being published on the Web?Select 1 option(s): From Azure AD remove the PowerBI Pro license from the user. From the app workspace settings remove the user as a member. From the Power BI Admin portal, disable the Publish to web setting. From the Power BI Pro, delete the embedded codes. None Q60. Your organization owns a consistent number of dashboards on Power BI. Your goal is to ensure that when users browse the list of the available dashboard, they can see the ones that contain Personal Identifiable Information. Which function best fit your needs?Select 1 option(s): Row Level Security. Tiles. KPIs. Microsoft Information Protection sensitivity labels. None Q61. Your organization plan to use the Power BI Service to get several visualizations from data stored in a custom application. The developers ask for pushing data into the Power BI Service from the custom app.How can you ensure this task?Select 1 option(s): Go to Office 365 Admin portal and register a web app. Go to Tenant Setting from PowerBI admin portal and set the API permissions. Go to app.powerbi.com and create an empty report. Go to dev.powerbi.com/apps and register an application. None Q62. You have a report named Sales_01. You plan to publish Sales_01 to a Blog, but you need to be sure that the report will preserve its size as a set on the report page. Which View Mode should you set for the Sales_01 report?Select 1 option(s): Fit to Width. Custom size. 16:09 Actual Size. None Q63. Your company stores sales data on a Microsoft SQL Server. You are responsible for creating a Power BI report, ensuring the quality and completeness of the sales data. In particular, you must be sure that the report doesn’t show negative amounts for sales data. How can you review data in Power Query before creating the data model?Select 1 option(s): Create a column from examples and fill it with positive values only from the total_sales column. Select Column profile, and then select the total_sales column. Select the total_sales column and filter out negative values. Select the total_sales column and delete all the negative values. None Q64. You create a Power Bl dataset from your organization’s data warehouse using DirectQuery with the tables shown in the below schema exhibit. You create a calculated table named Country from the dataset for unique values of country in the table named Customer.You generate visualizations for the sales data including showing sales by product manager. The product manager data is not in the data warehouse. The product manager data is in an Excel workbook on your local computer as shown in the Workbook exhibit below. You do not have the Power BI On-Premises Gateway installed. You need to explain to the user when the data in the visualizations was last refreshed.Visuals referring to the Product Managers table show the values from..Select 1 option(s): when the user pressed F5 when the workbook was last loaded when the dataset was last refreshed when the user selected Refresh dashboard tiles the latest values in the data warehouse None Q65. How do you connect to Excel files that contain target figures? The solution should involve minimum manual work when new Excel files are created. Select 1 option(s): Connect to the files with Folder connector and use the Combine Binaries functionality Connect to a new file each month, perform transformations, and use Append function in Power Query Editor to combine all targets in the same table None Time's up