Download POWER BI DA-100 CERTIFICATION | QUESTIONS AND COMPLETE ANSWERS (LATEST UODATE 2024/2025) and more Exams Information Technology in PDF only on Docsity!
If you want your data to automa.cally refresh as you interact with visualiza.ons, which op.on should you choose? A) Import B) directquery B) directquery Explana.on: When you use directquery, no data is imported into Power BI Desktop. As you create or interact with a visualiza.on, powerbi Desktop queries the underlying data source, i.e. You're always viewing current data. How do you connect to Excel files that contain target figures? The solu.on should involve minimum manual work when new Excel files are created. A) Connect to the files with Folder connector and use the Combine Binaries func.onality. B) Connect to a new file each month, perform transforma.ons, and use Append func.on in Power Query Editor to combine all targets in the same table. A) Connect to the files with Folder connector and use the Combine Binaries func.onality.
POWER BI DA- 100
CERTIFICATION | QUESTIONS
AND COMPLETE ANSWERS
(LATEST UODATE 2024/2025)
Explana.on: Connec.ng to files separately will take .me if there are lots of files in the folder. Its always bePer to connect to folder if files have same structure. If you copy new files in that folder with same structure, that file will be loaded automa.cally without doing any change to data sources. Imagine that you have created a query named "Customers" in a powerbi Desktop to append the rowss from three external tables with customer data into a single output table named "Customers". What would be the best approach to add a new fabricated ID column to the Customers table to ensure that every row in the "Customers" table contains a unique ID value? A) Modify the Customer query by adding a counter column. B) Modify the data model by extending the Customers table with a Counter column. C) Modify the customers query by adding an index column. D) Modify the data model by extending the Customers table with an index column. C) Modify the Customers query by adding an index column. Explana.on: Index column op.on is available in query editor to add indexed column star.ng from 0, 1, or custom number.
C) You cannot convert column data types when edi.ng a query. D) You cannot add measures to the data model. B) No support for parent-child func.ons. Explana.on: When in directquery mode, it is not possible to use the family of 'DAX PATH( )' func.ons that generally handle parent-child structures, such as chart of accounts, or employee hierarchies. Which three transforma.ons are available when you right-click a column header in the Query Editor window? A) Remove B) Duplicate Column C) Change Type D) Count Rows A) Remove B) Duplicate Column C) Change Type D) Count Rows Answer: Count Rows op.on is not there when you right click on column. When using the "Split Column by Delimiter" transforma.on, which op.on may result in more than two columns?
A) At the le^-most delimiter. B) At each occurrence of the delimiter. C) At the right-most delimiter. D) None of the Above. B) At each occurrence of the delimiter. Explana.on: Using "At each occurrence of the delimiter", number of columns will depend on number of .mes a delimiter is used in string/text. Select the feature that allows you to navigate through HTML tags to get the data from website? A) Get JSON Data. B) Web Scraping. C) Scaffolding. B) Web Scraping Explana.on: Web Scraping is the new feature of powerbi that allows you to navigate through HTML tags to get data from website. Client provides you with SQL Server Analysis Service database connec.vity with Mul.dimensional database structure. To import data use Get Data - > SQL Server Analysis Service and data will be
C) It will import tables that have physical rela.onship with selected table. Explana.on: "Select Related Tables" will import all other tables that have rela.on with this table. What happens to the data types of Query Editor that are not available in data model while loading data? A) Tables with not supported types will throw an error. B) Data with these types will not load into data model. C) These types will be converted to related data types. C) These types will be converted to related data types. Which view shows the graphical representa.on of data tables structure in query editor? A) Advance Editor B) Manage Data-Source C) Query Dependency C) Query Dependency Explana.on: Query Dependency reflects the structure and hierarchy of tables in graphical format. What is the purpose of TRIM func.on?
A) It will remove white space from a string. B) It trims a specific character from string. C) It will remove white space from start and end of a string. C) It will remove white space from start and end of a string. A large corporate project requires the data team to create a number of different Power BI reports for the company's internet sales data. You need to create a measure that es.mates the variance of the salesamount_USD column from your internetsales_USD table, for the en.re popula.on. The mathema.cal formula for this calcula.on should follow the agreed standard: ∑(x - x̃)²/n Which DAX formula should you use? A) VAR.S B) VAR.P B) VAR.P Explana.on: "VAR.P" assumes that the column refers to the en.re popula.on. If your data represents a sample of the popula.on, then compute the variance by using "VAR.S". Power BI comes with a range of visualiza.ons to portray any data story you wish. There is one par.cular visual that's perfect to help users understand and analyze cash-flow during the ups and downs of all months in a financial year. Which visualiza.on is this?
D) Use the TREATAS func.on. B To create a column chart that displays Quan.ty by Color and can be drillled down to show Quan.ty by Stock Item. Which of the following solves the problem? More than one answer can be correct. A) Put Color on Axis and Stock Item on tool.ps. B) Create a Stock Item hierarchy that includes Color and Stock Item and use the hierarchy on axis. C) Put Color and Stock Item on axis. D) Put Color on axis and Stock Item on legend. B) Create a Stock Item hierarchy that includes Color and Stock Item and use the hierarchy on axis. C) Put Color and Stock Item on axis. Explana.on: With either op.on, you will be able to drill down in the hierarchy. Answer D is wrong because you cannot use the legend to drill down. If you follow op.on A, you will not see stock item names in the visual. Using the bookmarking features in the report designer in Power BI Desktop, there is a limita.on of crea.ng only one bookmark per page in a report. Is this statement correct?
A) True B) False B) False Explana.on: You are allowed to create mul.ple bookmarks. Which of the following statements are true with regard to using the Slicer visual in a Power BI report? A) A slicer visual is used on Power BI reports to provide the report consumer with interac.ve filtering behavior. B) A slicer visual from a power BI report can be pinned to a dashboard to make the dashboard interac.ve. C) A Slicer visual based on a date column can be configured to use slider controls. D) When adding a field to the Field well of a Slicer visual, you can use either a column or a measure. A) A Slicer visual is used on Power BI reports to provide the report consumer with interac.ve filtering behavior. C) A Slicer visual based on a Date column can be configured to use slider controls. Explana.on: Slicer cannot be pinned to dashboard because dashboards are not interac.ve. Measures are not allowed to be used in Slicer.
B) Select the Sales table in the Fields list, and then click New Measure in the Modeling ribbon. C) On the Fields list, click the ellipsis next to the Sales table or right click any field in the Sales table, and then click New Measure. D) Click New Measure, and then type in the formula Home Table = Sales. A) Create the measure from any table, and then set the Home Table proper.es to Sales. B) Select the Sales table in the Fields list, and then click New Measure in the Modeling ribbon. C) On the Fields list, click the ellipsis next to the Sales table or right click any field in the Sales table, and then click New Measure. Explana.on: Op.on two and three allow you to create a measure directly in the Sales table. Op.on one allows you to create a measure in any table, and then move it to the Sales table. What are the three reasons for which you might use calculated tables? A) To improve the speed and performance of an exis.ng table. B) To create a table based on the result of a func.on or formula. C) To union tables.
D) To perform different types of merge join. B) To create a table based on the result of a func.on or formula. C) To union tables. D) To perform different types of merge join. Explana.on: You can use calculated tables to create a table based on the result of a func.on/formula. For example, you can use calculated tables to union tables and perform different types of merge join. Which three fields are available when crea.ng a Pie chart visualiza.on? A) Group B) Legend C) Details D) Value B) Legend C) Details D) Value By default, which filter level behaves the same as a slicer in a report in Power BI Desktop?
A) Click on the ellipses on Right Top Corner of Visual --> Sort by - monthnumber B) Right click on field in report view and select sort by, then select monthnumber. C) Modeling --> Select Month Column --> Sort By - monthnumber C) Modeling --> Select Month Column --> Sort By - monthnumber What is true about using variables in DAX? A) Variables are created only one .me in the current context. B) Maximum of 5 variables can be created per formula. C) Variables must be defined inside return. A) Variables are created only one .me in the current context. How can you make sure that each category manager can see sales of their category only and CEO to see all sales in the same report? Your solu.on must involve minimal effort. A) Create one report for each category manager, with a different category filter in each report, and a separate report for the CEO. B) Implement Dynamic row-level security. C) Create a category slicer in the report. B) Implement Dynamic row-level security.
Explana.on: Crea.ng separate reports for each manager will duplicate the reports and make it difficult to maintain them. Crea.ng a slicer in the report is not going to secure data at all. Dynamic row-level security is the most appropriate choice given that there is a table that can be used to filter categories based on the ac.ve username. The CEO can have a separate role to view everything. In order to use the powerbi web part in sharepoint Online, the report author as well as all the report consumers require a Power BI Pro license. Is this statement true? A) True B) False A) True Explana.on: All sharepoint report viewers must have powerbi pro license. Which of the following types of real-.me data set in Power BI always store their data in Azure SQL Database? A) Streaming Datasets B) Push Datasets C) Hybrid Datasets B) Push Datasets C) Hybrid Datasets
C) Reports provide a bePer real-.me experience when displaying data from a streaming dataset. D) Report defini.ons can be saved using an external file format (PBIX) and checked into source control. A) Reports provide a bePer interac.ve filtering and drilldown experience. B) Reports provide story telling capabili.es using bookmarks. D) Report defini.ons can be saved using an external file format (PBIX) and checked into source control. Explana.on: Reports don't support streaming datasets. This feature is available in dashboard .les. Which three proper.es of a .le can be edited in the Power BI dashboard from the Tile details window? A) Title B) Sub.tle C) Des.na.on link D) Color Scheme A) Title
B) Sub.tle C) Des.na.on link What do you need to append to the URL of a Power BI Dashboard in order to open it with the naviga.on pane collapsed by default? A) ?Naviga.onpane=false B) ?Naviga.onpane=collapsed C) ?Collapsenaviga.on=true D) ?Collapsenaviga.on=collapsed C) ?Collapsenaviga.on=true Which feature is used to create alterna.ve name for fields in tables. It will make it much easier for users to ask ques.ons on dashboards? A) Duplicate Name B) Alterna.ve C) Synonyms C) Synonyms Which page view types are available in Power BI Report View? A)Full Screen
