CFI Exam Questions with Complete Answers

What are the responsibilities of a data analyst? Correct Answer -Extract, transform, and load data into models. -Set up automated refreshes for data models. -Document metric definitions related to the model using a data dictionary. -Create robust metrics that can be re-used across multiple reports What are the key benefits of Power Pivot? Correct Answer -It allows the user to create pivot tables & data models that connect related data. -It helps eliminate intensive formulas like VLOOKUP. -It can help us perform powerful time-period comparison functions. What are the key benefits of Power Query? Correct Answer -It remembers the steps for data transformation and automates the process. -It can help combine data from several workbooks or sources. Which of the following are true regarding SQL? Correct Answer -SQL is a universal language used by most of the BI roles. -SQL is a query language used to obtain data from a database. -SQL allows us to join many tables together into one query. What are the top 3 most commonly used data visualization tools? Some may not be dedicated visualization tools, but they're still popular and widely used. Correct Answer Tableau, Power BI, and Excel Here are a selection of questions