Microsoft Power BI Test - 14 Welcome to your Microsoft Power BI – Test-14 Name Email Phone Q1. You create a quick measure Sales Amount MTD to display the Month-to-date total of Sales Amount values using Order Date (see the below representation). In the visual, the Order Date in the Values well uses the Power BI auto date/time generated hierarchy (Year, Quarter, Month, and Day). You have to replace the Year, Quarter, Month & Day columns with a single Date column without breaking the visual.Which of the following solutions would you use?Select 1 option(s): From the Order Date hierarchy in the Values well, you use the context menu to switch from the date hierarchy to the date column (Order Date). Turn off the auto date/time option for the current .pbix file. Create a separate Date table and slice the quick measure using the date column from the Date table. Create a quick measure using the date column in the Date table. None Q2. This question is part of repeated scenario questions that contain the same stem but with a different solution for each question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario questions might contain either none, one, or many solutions. You have a list of customers in an Excel spreadsheet and a Sales table in on-premises SQL Server. You need to combine the two into a single table of only the customers who have not purchased any product. Finally, load this data into Power BI. Ensure that you minimize the size of the data model.Based on the given scenario, choose the correct set of options:How do you combine the Customer & the Sales table? What join kind would you perform? (Assume Sales is the right table) What would you do to the original two queries? You choose Append Queries as New, Right Anti, & Delete themDoes the solution solve the problem?Select 1 option(s): Yes No None Q3. This question is part of repeated scenario questions that contain the same stem but with a different solution for each question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario questions might contain either none, one, or many solutions. You have a list of customers in an Excel spreadsheet and a Sales table in on-premises SQL Server. You need to combine the two into a single table of only the customers who have not purchased any product. Finally, load this data into Power BI. Ensure that you minimize the size of the data model.Based on the given scenario, choose the correct set of options:How do you combine the Customer & the Sales table? What join kind would you perform? (Assume Sales is the right table) What would you do to the original two queries? You choose Merge Queries, Left Outer, & Leave them untouchedDoes the solution solve the problem?Select 1 option(s): Yes No None Q4. This question is part of repeated scenario questions that contain the same stem but with a different solution for each question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario questions might contain either none, one, or many solutions. You have a list of customers in an Excel spreadsheet and a Sales table in on-premises SQL Server. You need to combine the two into a single table of only the customers who have not purchased any product. Finally, load this data into Power BI. Ensure that you minimize the size of the data model.Based on the given scenario, choose the correct set of options:How do you combine the Customer & the Sales table? What join kind would you perform? (Assume Sales is the right table) What would you do to the original two queries? You choose Merge Queries as New, Left Anti, & Disable Enable LoadDoes the solution solve the problem?Select 1 option(s): Yes No None Q5. This question is part of repeated scenario questions that contain the same stem but with a different solution for each question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario questions might contain either none, one, or many solutions. You have a list of customers in an Excel spreadsheet and a Sales table in on-premises SQL Server. You need to combine the two into a single table of only the customers who have not purchased any product. Finally, load this data into Power BI. Ensure that you minimize the size of the data model.Based on the given scenario, choose the correct set of options:How do you combine the Customer & the Sales table? What join kind would you perform? (Assume Sales is the right table) What would you do to the original two queries? You choose Merge Queries as New, Left Anti, & Disable Include in report refreshDoes the solution solve the problem?Select 1 option(s): Yes No None Q6. While importing data into Power BI, you have to remove columns with column names that start with the prefix Test_ as shown below (Not all columns displayed). Given below is an incomplete M query. Choose the correct options that complete the M query to accomplish the required task. Select 1 option(s): Table.ColumnNames, List.First, Table.RemoveColumns Table.ColumnNames, List.FindText, Table.RemoveColumns Table.Column, List.First, List.RemoveItems Table.Column, List.FindText, List.RemoveItems None Q7. Below is an imported table in Power Query. There is a project requirement to extract and modify the above column names (in camel case) as shown in the table below. Select and reorder the steps you would perform that meet the requirement. Select 1 option(s): Split column by uppercase to lowercaseConvert the list to a tableExtract column names using Table.ColumnNamesConvert the table to a list Extract column names using Table.ColumnNamesConvert the list to a tableSplit column by uppercase to lowercaseConvert the table to a list Split column by uppercase to lowercaseExtract column names using Table.ColumnNamesConvert the table to a listConcatenate columns Extract column names using Table.ColumnNamesConvert the list to a tableSplit column by lowercase to uppercaseConcatenate columns Convert the list to a tableExtract column names using Table.ColumnNamesSplit column by lowercase to uppercaseConvert the list to a table None Q8. In the Promotion dimension table, there are two columns Promotion Category and Maximum Quantity. The column Maximum Quantity has four distinct whole number values and 12 null values. For the following scenarios, choose the correct number of rows displayed in the visual (including null values). Select 1 option(s): a -> 1; b -> 6 a -> 2; b -> 7 a -> 1; b -> 16 a -> 1; b -> 7 a -> 2; b -> 6 None Q9. AI Rudder Case Study Overview:AI Rudder is an AI startup that develops AI-powered voice solutions to improve B2C communications. The company has just received its Series B funding and is poised for growth.The company uses its database of customers to target high-income earners in the US. It plans to understand the factors of high incomes and use these attributes to target potential customers.Below is the data model created by the companys data warehouse engineers that you import from SQL Server into Power BI.Q] To find the drivers of high incomes for your customers, you create the below key influencer chart in Power BI. In this visual, you:1. Move Yearly Income field into the Analyze well2. Move Education field into the Explain by wellHowever, you get the below warning message.How would you fix this warning?Select 1 option(s): Change the data type of Yearly Income to the whole number Change the Analysis type from Categorical to Continuous Reduce the number of unique values for Yearly Income to less than 5 Move Yearly Income field into the Explain by well None Q10. AI Rudder Case Study Overview:AI Rudder is an AI startup that develops AI-powered voice solutions to improve B2C communications. The company has just received its Series B funding and is poised for growth.The company uses its database of customers to target high-income earners in the US. It plans to understand the factors of high incomes and use these attributes to target potential customers.Below is the data model created by the companys data warehouse engineers that you import from SQL Server into Power BI.Q] To find the drivers of high incomes for your customers, you create the below key influencer chart in Power BI.How would you configure the above key influencer visualization in each of the three wells?Select 1 option(s): Analyze -> Yearly IncomeExplain by -> EducationExpand by -> Occupation Analyze -> Yearly IncomeExplain by -> Education, OccupationExpand by -> Education, Occupation Analyze -> Yearly IncomeExplain by -> Education, OccupationExpand by -> None Analyze -> Yearly IncomeExplain by -> OccupationExpand by -> Education None Q11. AI Rudder Case Study Overview:AI Rudder is an AI startup that develops AI-powered voice solutions to improve B2C communications. The company has just received its Series B funding and is poised for growth.The company uses its database of customers to target high-income earners in the US. It plans to understand the factors of high incomes and use these attributes to target potential customers.Below is the data model created by the companys data warehouse engineers that you import from SQL Server into Power BI.Q] From your data analysis, you find that the employees in AI Rudder interact with more male customers than female customers. So, to know the drivers of high incomes for male customers, you create the below measure:Yearly Income (Male) =CALCULATE ( SUM ( Customer[Yearly Income] ), Customer[Gender] = “M“ )And, use this measure in the Analyze well.But the Key influencers visual doesnt find any influencer. How would you fix this issue?Select 1 option(s): Move the Customer Key field into the Explain by well Add more fields to the Explain by well Apply default summarization to the existing fields in the Explain by well Move the Customer Key field into the Expand by well None Q12. AI Rudder Case Study Overview:AI Rudder is an AI startup that develops AI-powered voice solutions to improve B2C communications. The company has just received its Series B funding and is poised for growth.The company uses its database of customers to target high-income earners in the US. It plans to understand the factors of high incomes and use these attributes to target potential customers.Below is the data model created by the companys data warehouse engineers that you import from SQL Server into Power BI.Q] To find the drivers of high incomes for your customers, you create the below key influencer chart in Power BI.In the above chart, Australia comes next to the US in terms of Average of Yearly Income and has a much higher average income than the average income of other countries.What could be the reason behind Australia not being considered a key influencer?Select 1 option(s): The visualization considers only the first data point as an influencer within a category The visualization considers the number of data points before determining an influencer The visualization considers only the data point with the highest Average of Yearly Income A configuration setting guides the visual to find the number of influencers None Q13. AI Rudder Case Study Overview:AI Rudder is an AI startup that develops AI-powered voice solutions to improve B2C communications. The company has just received its Series B funding and is poised for growth.The company uses its database of customers to target high-income earners in the US. It plans to understand the factors of high incomes and use these attributes to target potential customers.Below is the data model created by the companys data warehouse engineers that you import from SQL Server into Power BI.Q] To find the drivers of high incomes for your customers, you create the below key influencer chart in Power BI.You want to analyze how the number of customer purchases/orders influence their Yearly Income. What would you do?Select 1 option(s): Move the Customer Key from the Customer table to the Explain by well Move the Customer Key from the Internet Sales table to the Explain by well and aggregate it Move the Customer Key from the Internet Sales table to the Explain by well Move the Customer Key from the Customer table to the Explain by well and aggregate it None Q14. AI Rudder Case Study Overview:AI Rudder is an AI startup that develops AI-powered voice solutions to improve B2C communications. The company has just received its Series B funding and is poised for growth.The company uses its database of customers to target high-income earners in the US. It plans to understand the factors of high incomes and use these attributes to target potential customers.Below is the data model created by the companys data warehouse engineers that you import from SQL Server into Power BI.Q] To find the drivers of high incomes for your customers, you create the below key influencer chart in Power BI.What does $44.29K in the blue circle indicate?Select 1 option(s): The ratio of the average of yearly income for customers whose occupation is Management to the average of yearly income for customers with other occupations Difference between the average of yearly income for customers whose occupation is Management and the average of yearly income for customers with other occupations The ratio of the average of yearly income for customers whose occupation is Management to the average of yearly income for all customers Difference between the average of yearly income for customers whose occupation is Management and the average of yearly income for all customers None Q15. AI Rudder Case Study Overview:AI Rudder is an AI startup that develops AI-powered voice solutions to improve B2C communications. The company has just received its Series B funding and is poised for growth.The company uses its database of customers to target high-income earners in the US. It plans to understand the factors of high incomes and use these attributes to target potential customers.Below is the data model created by the companys data warehouse engineers that you import from SQL Server into Power BI.Q] You analyze how the number of cars owned by the customer influences their Yearly Income. The below chart indicates that as the number of cars owned goes up by 0.78, the average income goes up by 6.8K.What does 0.78 indicate?Select 1 option(s): The mean of the number of cars owned The variance of the number of cars owned The standard error of the number of cars owned The standard deviation of the number of cars owned None Q16. Which Power BI license type enables Power BI content to be hosted on a custom application outside the Power BI web portal? Select 1 option(s): Pro Premium Per User Premium Per Capacity Embedded None Q17. Which of the following statements are true for dashboards and reports? Select 2 option(s): Reports can have only a single page while Dashboards can have multiple pages. Both Dashboards and Reports can have multiple pages. Both reports and dashboards can be refreshed to display the latest data. None of these statements are true Dashboards can have only a single page while reports can have multiple pages. Q18. Which of the following Azure Cognitive Services models can be called through the AI insights feature in Power BI Desktop? Select 3 option(s): Key Phrase Extraction Sentiment Analysis K-mean Clustering Language Detection Q19. Which of the following is not a core component of Q&A Visualization? Select 1 option(s): An icon that can be selected by the users to automatically create a custom tooltip An icon that users can select to convert the Q&A visual into a standard visual. A pre-populated list of suggested questions. The question box, where users enter their question and are shown suggestions to help them complete the question. None Q20. Microsoft Information Protection sensitivity labels allow users to classify sensitive/critical content in Power BI without impacting productivity or interoperability. These sensitivity labels can be applied to which of the following elements of the Power BI service? Select 1 option(s): All of these reports dataflows datasets dashboards None Q21. In Power BI, the _____ number refers to how many different values there are in a column, once duplicates are excluded. Select 1 option(s): special distinct cardinality regression None Q22. Which of the following statements about data models in Power BI is false? Select 1 option(s): Too many tables can sometimes cause functional issues. Data models that have more tables are easier to navigate. Every column that isn‘t needed should be removed from your data model. Too many tables can sometimes lead to report inaccuracies. None Q23. Which of the following data sources can be connected through the “Get Data“ option in the Power BI Desktop? Select 1 option(s): All of them Power BI datasets Power BI Template Apps Power BI dataflows None Q24. Which of the following elements are saved when you create a bookmark? (Choose four answers) Name of the display folders that are being used to organize the fieldsSelect 4 option(s): Current Page DAX measures Slicers with slicer type and slicer state Drill location Sort order Q25. Which type of Power BI workspace should only be used for ad hoc reporting and projects that aren‘t intended for any kind of distribution? Select 1 option(s): My Workspace App workspaces Development workspaces Dashboard workspaces None Q26. What is the second parameter in the DAX function PATHITEM? Select 1 option(s): the name of the field you‘re interested in type the level you want to be returned the text path describing the hierarchy None Q27. Which of the following are the right contexts for using the Funnel charts in Power BI? (Choose three answers) Select 3 option(s): To show the beginning and ending headcount for the organization in a year. To reveal bottlenecks in a linear process. When there are at least 4 stages and data flows among them sequentially. To calculate a possible outcome like revenue, sales, deals, etc by stages. Q28. Promotion and certification are two ways to endorse dataset. Which of the following statements are true about Promotion and Certification? Select 2 option(s): Promotion is the ideal way to endorse the dataset when the dataset is ready for broad usage. Promotion does not require specific permissions from the admin, whereas Certification needs permission from the dataset owner or admin to access the dataset. Certification is the ideal way to endorse the dataset when the dataset is ready for broad usage. None of the statements are true Q29. In Power BI, _____ show the shape of the data whether the distribution of values is uniform, or if some values appear more frequently than others. Select 1 option(s): cardinality indicators query maps column charts column profiles None Q30. Choose the correct statements regarding setting a cross filter direction property for many to one relationship between two tables. (Choose three answers) Select 3 option(s): If you define the cross filter direction to both, the context filter will be propagated by the tabular database engine in both directions. In some cases, you can set cross filter direction to single only as setting direction to both might create an ambiguity that cant be resolved. If you define the cross filter direction to single, the context filter will be propagated by the tabular database engine in only one direction i.e from one-sided to the many-sided table. If you set the direction of the crossfilter to single, the context filter will be passed by the spreadsheet database engine in only one direction, i.e. from multi-sided tables to single-sided tables. Q31. Which of the following chart is the great choice to identify or display the outliers? Select 1 option(s): None of these Bar chart Line Chart Scatter Chart None Q32. True or False: Row-level security (RLS) cannot be applied in Power BI Desktop when connecting via a live connection to Analysis Services; this must be set within the AS model. Select 1 option(s): TRUE FALSE None Q33. You are the sales team leader and have set up a workspace to work with the product team. Depending on your requirements, you have assigned different workspace roles such as administrator, member, contributor and presenter to different members of the product team. Which of the following actions can be performed by workspace contributors? (Choose all that apply) Select 4 option(s): Publish an app within the workspace but only after given the ability by the admin or members Update the content and reports within the workspace Schedule the data refreshes Create and Publish the reports within the workspace Unattempted Q34. You have a 4-page report. Each page consists of slicers applied to the same 4 fields. Users find that selecting a slicer value on one page does not update the display on all pages. You need to add the functionality to filter the result on all pages after users have selected a value. Which of the following solutions is possible in this scenario? Select 2 option(s): Sync the slicers across all the pages Use page level filters instead of slicers Use visual level filters instead of slicers Use report level filters instead of slicers Q35. Your team leader has commissioned you to create a Power BI dashboard with visualisations of sales data. You have been asked to add some sample questions that users can ask when using the Questions option. What do you need to change in Power BI settings to enable sample questions? Select 1 option(s): None of these Reports Dashboards Datasets None Q36. EMPLOYEES is the table with the following columns: Employee_id, Department_id, Department_name, Payment.Created a report with a stacked bar chart showing the number of employees by department name.Now you want to customize the information in the chart visualization tooltip.In this case, what is the first step you need to take?Select 1 option(s): Set either Employee_id or Department_name as Tooltip field. Set column Department_name as Tooltip field. Set column Employee_id as Tooltip field. Create a new report page and set this report page as Tooltip. None Q37. Which of the following statements are true about data granularity? (Choose two) Select 2 option(s): Data granularity represents the type of values contained by the data Higher data granularity, greater the level of detail within the data Data granularity represents the level of the details represented within the data Data granularity represents the relationships among the various data entities Q38. Which of the following statements are true for Power BI paginated reports? (Choose two) Select 2 option(s): Power BI paginated reports are created using Power BI Report Builder Power BI paginated reports are created using Power BI Service Power BI paginated reports are created using Power BI Desktop Power BI paginated reports are descendants of SQL Server Reporting Services Q39. The data profiling feature of Power BI Desktop sits in the _____ function. Select 1 option(s): Power Map Power View Power Query Power Pivot None Q40. Anomaly Detector with Multivariate Anomaly Detection (MVAD) is an advanced AI tool for detecting anomalies from a group of metrics in an unsupervised manner. In general you could take the following steps to use MVAD. Put the steps in the right order! 1. Train an MVAD model.2. Create an Anomaly Detector resource that supports MVAD on Azure.3. Query the status of your model.4. Prepare your data.5. Retrieve and interpret the inference results.6. Detect anomalies with the trained MVAD model.Select 1 option(s): 4-2-5-2-1-6 3-4-1-2-5-6 2-4-1-3-6-5 2-3-5-4-6-1 None Q41. In Power BI, the _____ number refers to how many values occur exactly once. Select 1 option(s): regression unique cardinality distinct None Q42. Fill in the blanks: In a Power BI table column, the _____ distinct and _____ unique items are in a column, the higher the cardinality. Select 1 option(s): more, more fewer, more fewer, fewer more, fewer None Q43. You need to import a large data set into the Power Query editor. You want to check whether a column consists only of unique values. Which of the data preview options listed below can be used for your purpose? (Choose two answers) Select 2 option(s): Monospaced Show Whitespaces Column Profile Column Distribution Q44. Which of the following statements is true? Select 1 option(s): Dimension tables store information about business entities and fact tables store observation data, i.e. information about business events. Fact tables and dimensional tables are just like synonyms. They represent the same thing. Fact tables store information about business entities and dimension tables store observation data, i.e. information about business events. None of these None Q45. Consider a scenario with two tables. One table is EMPLOYEES, which contains employee details in the columns emp_name, address, emp_id and joining_date. The other table is PROJECTS with emp_id, project_id and start_date columns. The HR department is now interested in having the data of the employees and the projects they work on in a single table. Which of the following operations would you perform? Select 1 option(s): Union Merge Combine Column Combine Row None Q46. Which of the following types of declarations can be used to query data from Azure Analysis Services cubes? (Choose two answers) Select 2 option(s): Transact-SQL (T-SQL) Multidimensional Expressions (MDX) Data Analysis Expressions (DAX) PL/SQL Q47. When opening a query in Power Query Editor, you want to know the percentage of empty cells or values in each column as soon as possible. Which of the following data preview options would you choose? Select 1 option(s): Column profile Column quality Column distribution Show Whitespaces None Q48. You want to create a metric that always calculates the total sales for the year 2022, regardless of which year is selected on another chart in Power BI. Which of the following is the correct way to create such a metric?Select 1 option(s): Total Sales for 2022= CALCULATE(SUM(‘Sales OrderDetails‘[Total Price]), YEAR(‘Sales OrderDetails‘[orderdate]) = 2022) None of these Total Sales for 2022= SUM(CALCULATE(‘Sales OrderDetails‘[Total Price]), YEAR(‘Sales OrderDetails‘[orderdate]) = 2022) Total Sales for 2022= TOTAL(SUM(‘Sales OrderDetails‘[Total Price]), YEAR(‘Sales OrderDetails‘[orderdate]) = 2022) None Q49. True or False: The data model affects the time required to update the model, but once the model is loaded into memory, it has no effect on the performance of the reports. Select 1 option(s): TRUE FALSE None Q50. What is the most efficient way to manage your assets across multiple regions? Select 1 option(s): Use Azure Traffic Manager Use Azure Load Balancer Use Azure Application Gateway Use Azure Front Door None Q51. You build a report to help the sales team understand its performance and the drivers of sales.The team needs to have a single visualization to identify which factors affect success.Which type of visualization should you use? Select 1 option(s): A. Key influencers B. Line and clustered column chart C. Q&A D. Funnel chart None Q52. You have a report in Power BI named report1 that is based on a shared dataset.You need to minimize the risk of data exfiltration for report. The solution must prevent other reports from being affected.What should you do? Select 1 option(s): A. Clear Allow recipients to share your dashboard and Allow users to build new content using the underlying datasets for the dataset. B. Apply row-level security (RLS) to the shared dataset. C. Select the Allow end users to export both summarized and underlying data from the service or Report Server Export data option for the report. D. Select the Don‘t allow end users to export any data from the service or Report Server Export data option for the report. None Q53. You have a report that contains three pages. One of the pages contains a KPI visualization.You need to filter all the visualizations in the report except for the KPI visualization.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. Select 2 option(s): A. Edit the interactions of the KPI visualization. B. Add the same slicer to each page and configure Sync slicers. C. Edit the interactions of the slicer that is on the same page as the KPI visualization. D. Configure a page-level filter. E. Configure a report-level filter. Q54. You want to show the percentage breakdown of different product categories in a sales report. Which chart type would be best to use? Select 1 option(s): A. Pie chart B. Bar chart C. Line chart D. Scatter chart None Q55. What is the difference between a workspace and a dataset in Power BI? Select 1 option(s): A. Workspaces contain reports, datasets contain data B. Workspaces contain data, datasets contain reports C. Workspaces and datasets are the same thing D. Workspaces contain dashboards, datasets contain reports None Time's up
Important Notice— Our url is www.synergisticit.com and for emails @synergisticit.com any emails received from any other domain or url implies that the email is not from Synergisticit.
