Business Intelligence Foundation Professional Certification Exam Answers – Certiprof

Related Articles

Information Technology Management Professional Certification

2 weeks ago

Kotlin Professional Certification

3 weeks ago

International Business Professional Certification

August 11, 2024

Business Intelligence Foundation Professional Certification Exam Answers – Certiprof

Question 1: It is the attribute of an entity that exists as a dependency on another entity, whose values must match values of a key that must be primary to another relationship:

• Foreign Key.
• Composite Primary Key.
• Primary Key.

Question 2: A foreign key must correspond to a primary key of another table.

• True.
• False.

Question 3: What is a data source in general?

• It is the location where the data being used comes from.
• A BI software.
• A Data Mining Platform.

Question 4: One of the difficulties in implementing BI solutions is the diversity of data sources you may have, what would be a solution to this?

• Perform analysis for each source.
• Data integration.
• Request to unify data sources.
• Export data.

Question 5: Data relationships and constraints are a concept of:

• Data relationship model.
• Qlik Sense.
• Power BI.
• Primary key.

Question 6: Transformation is part of:

• ETL.
• Descriptive analysis.
• Prescriptive Analysis.
• Predictive analytics.

Question 7: Full extraction is performed only with the data that have changed since a given event.

• True.
• False.

Question 8: Incremental extraction is performed only on data that has changed since a given event.

• True.
• False.

Question 9: Use of historical data analysis to identify trends and relationships:

• Historical Analysis.
• Descriptive Analysis.
• Referential analysis.

Question 10: Identify the likelihood of future outcomes based on historical data:

• Descriptive Analytics.
• Historical Analytics.
• Predictive Analytics.
• Prescriptive Analytics.

Question 11: Discovering patterns and forecasting future patterns, using advanced statistics and predictive analytics is the definition of:

• Advanced programmer.
• BI Developer.
• Data science.
• BI Analysis.

Question 12: What is happening? This question should be asked in the phase:

• Observe.
• Understand.
• Predict.
• Decide.

Question 13: Processes that read the data from the different sources, transform and adapt them to the model we have defined, debug and clean them, and introduce them into the target database:

• Transformation Processes.
• Extraction Processes.
• Data Loading Processes.

Question 14: Why does it happen? It is a question of the phase of:

• Predict.
• Collaborate.
• Observe.
• Understand.

Question 15: What does the acronym BI stand for?

• Business Improve.
• Business Impact.
• Business Intelligence.
• Business Insider.

Question 16: What is a real and measurable advantage of using BI?

• Time increase.
• Reduction of information security.
• Identification of new business opportunities.
• Expand the company’s value chain.

Question 17: Some of these are sources of data collection:

• Databases.
• Flat files.
• Registration data.
• All of the above.

Question 18: Depending on the requirement of the organization the data upload can have a variety of different actions.

• True.
• False.

Question 19: “What is most likely to happen in the future based on historical trends?” the type of analysis that can help me answer the above question is:

• Prescriptive Analytics.
• Predictive Analytics.
• Descriptive Analytics.
• Historical Analytics.

Question 20: Which of the following options are part of the BI strategy?

• Identify key stakeholders.
• Failure to define the scope.
• Have a roadmap.
• A and B are correct.
• A and C are correct.
• None is correct.
• All are correct.

Question 21: What is a Business Intelligence platform for?

• As an Internet browser.
• As Software to create reports and analyze data.
• To Generate Graphics.
• As a Spreadsheet.

Question 22: The model showing the limitations of data storage is called:

• Transformation model.
• Data relationship model.
• ETL Model.
• Granularity model.

Question 23: To be able to add a row with a specific foreign key value, there must be a row in the related table with the same primary key value.

• True.
• False.

Question 24: What is a Primary Key?

• It is a single field within a table and is used to establish relationships between tables.
• It’s to make my Tablet look pretty.
• It is any field in the table.
• It is a field used to protect my database.

Question 25: The word ETL stands for the acronym in English:

• External, Transform, Load.
• Extract, Transform, Load.
• Extract, Transaction, Loading.
• Extract, Transform, Loop.

Question 26: The name used to uniquely identify each record within a database table.

• Database
• Entity.
• Foreign key
• Primary key.

Question 27: A column or set of columns in a table whose values uniquely identify a row in the table. It is a_____________ key:

• External.
• Internal.
• Foreign.
• Primary.

Question 28: In a BI project it is important:

• Identify the tools to be used.
• Identify key stakeholders.
• To have external expert advisors.

Question 29: The definition “data coming from the previous phase (transformation phase) are loaded in the target system” corresponds to:

• Data extraction.
• Data transformation.
• Data deletion.
• Data upload.

Question 30: What are the phases of BI implementation?

• Observing, Compiling, Predicting, Collaborating, Deciding.
• Observing, Understanding, Programming, Collaborating, Deciding.
• Observing, Understanding, Predicting, Collaborating, Dialoguing.
• Observing, Understanding, Predicting, Collaborating, Deciding.

Question 31: During this process, data is taken (extracted) from a source system, converted (transformed) into a format that can be stored and stored (loaded) in a data warehouse or other system, is the definition of:

• Datawarehouse.
• Accumulation.
• ETL.
• Rolling.

Question 32: The types of relationships between tables are:

• 1-to-1, 1-to-Many, many-to-one, many-to-many, many-to-many relationships.
• Many-to-many relationships.
• No relationships between tables are established.
• 1 to 1 ratio.

Question 33: When we refer to the set of strategies and tools focused on the data analysis of a company through the analysis of existing data we talk about:

• Data Science.
• Business intelligence.
• Data Analytics.
• Data Information.

Question 34: Using the current data to identify data relationships is a ___________ analysis.

• Recurring.
• Predictive.
• Prescriptive.
• Descriptive.

Question 35: By having only internal data, is it possible to have a complete view of the business?

• True.
• False.

Question 36: The Entity Relationship diagram is used as:

• Analysis to establish relationships between tables.
• It is a diagram where data are related by their shapes.
• Both of the above.
• None of the above.

Question 37: What are the extraction techniques?

• Simple extraction.
• Complete Extraction.
• Incremental Extraction.
• All are correct.
• A and B are correct.
• A and C are correct.
• B and C are correct.
• None of the above.

Question 38: Scheme in which a central information table is connected to multiple dimensional tables.

• Inverted.
• Star.
• Objects.
• Structured.

Question 39: Identifying key trends is part of the____________ analysis.

• Predictive.
• Descriptive.
• Recurring.
• Prescriptive.

Question 40: In recent years, processes have been added to business intelligence software to improve performance. These include:

• Data Visualization.
• Data quality management and monitoring.
• Dynamic Report Generation.
• All of the above.

Question 41: Effectively aggregating as much data as possible and making it easy to interpret can support increased productivity and efficiency.

• True.
• False.

Question 42: We would like to estimate how many sales there will be in the month of August

• Predictive Analytics.
• Diagnostic Analysis.
• Descriptive Analytics.
• Prescriptive Analytics.

Question 43: Load is part of:

• ETL.
• Predictive analytics.
• Prescriptive Analysis.
• Descriptive analysis.

Question 44: Extraction is part of:

• Prescriptive Analysis.
• Predictive analytics.
• Descriptive analysis.
• ETL.

Question 45: A foreign key is a column or set of columns in a table whose values uniquely identify a row or record in a table.

• True.
• False.

Question 46: What do you see as the purpose of business intelligence solutions in organizations?

• Data integration.
• Promote business sales.
• Facilitate and improve decision making.
• Facilitate data collection.

Question 47: What data integration is used to blend data from multiple sources?

• Saas.
• Extract, Re-engineer, Programming.
• Extract, Transform, Load.
• Extract, Program, Load.

Question 48: The main benefits of Business Intelligence are as follows.

• Organization, Budget and Administration.
• Decisions, Analysis and Proposals.
• Decisions, Big Data Consumption and Proposals.
• Time savings, data clarity and customizable reporting.

Question 49: “The combination of technology, tools and processes that allow me to transform my stored data into information, this information into knowledge and this knowledge directed to a business plan or strategy. The above is the definition of:”

• Business intelligence.
• Business intelligence.
• Production intelligence.
• Management intelligence.

Question 50: Considerations for choosing data visualization software

• Integration of different data sources and with other platforms.
• Variety of languages.
• Free.
• Multiplatform.

Question 51: Easily accessible data repository that draws from multiple data sources

• ETL.
• Datawarehouse.
• Data mining.
• Analysis.

Question 52: Which of the following is part of the challenges in data mining?

• Compatibility problems.
• Unstructured data correctly.
• Data security.
• All of the above.

Question 53: Key that provides a unique value for each row in a table.

• Foreign key.
• Primary key.
• Secondary key.
• None of the above.

Question 54: Select those necessary to complete the structured business intelligence architecture.

• Data Sources.
• ETL.
• Data Repository.
• Access Interface.
• All of the above.

Question 55: Recommending possible actions is part of the_______________ analysis.

• Prescriptive.
• Recurring.
• Predictive.
• Descriptive.

Question 56: If you want to know how many new customers there will be next year, you can use:

• Descriptive Analytics.
• Predictive Analytics.
• Diagnostic Analysis.
• Prescriptive Analytics.

Question 57: Claiming that the primary and foreign key are the same is:

• True.
• False.

Question 58: It is mainly used for filtering data, merging fields and deleting or correcting erroneous fields:

• SAAS.
• ETL.
• Transformation.
• Load.

Question 59: The process of converting data or information from one format to another, usually from the format of a source system to the required format of a new target system:

• Data Transformation.
• Data Extraction.
• Data Modeling.
• Data Loading.

Question 60: The logical structure of how data is related and stored is a concept of:

• ETL.
• Primary key.
• Data relationship model.
• Power BI.

Question 61: Data quality and security is a challenge of:

• Data loading.
• Data extraction.
• Data transformation.
• All of the above.

Question 62: Drawing conclusions from data analysis using statistical analysis is the concept of:

• Data analysis.
• Data science.
• BI Analysis.
• None of the above.

Question 63: Joining different fields to obtain a consolidated view is part of the process:

• Data loading.
• Data extraction.
• Data transformation.
• All of the above.

Question 64: How data is stored and accessed is a concept of:

• Primary key.
• Secondary key.
• Data relationship model.
• Data extraction.

Question 65: What is granularity?

• Organized collection of information.
• Confirmation of data upload.
• Existence of business data.
• Level of detail at which business information is stored.

Question 66: Why is it important to find the right enterprise BI platform?

• To save costs in the company.
• To adapt to the market.
• To achieve the necessary agility without sacrificing data security.
• To forecast data.

Question 67: Data transformation helps in the process of:

• Extract information and analyze it.
• Storing data in a data warehouse.
• Load the information in a new destination.
• Convert data from one format to a more user-friendly format.

Question 68: What is a common form of Entity-Relationship Diagram (ERD)?

• Objects.
• Structured.
• Star.
• Inverted.

Question 69: Databases are an organized collection of data

• True.
• False.

Question 70: When I generate a data load where only data that has been updated or changed since a discrete past event is extracted. This is a type extraction:

• Incremental.
• Complete.
• Progressive.
• Closed.

Question 71: One data is:

• Concrete information about facts, elements, etc., that allows them to be studied, analyzed or known.
• The registration of an event.
• One variable.
• A numeric value, generated by a transaction.

Question 72: What does KPI stand for?

• Knowledge Panning Indicator.
• Key Planning Indicator.
• Key Performance Indicator.
• None of the above.

Question 73: Column or a set of columns in a table whose values correspond to the values of the primary key of another table, this concept refers to:

• Common key.
• Structured key.
• Primary key.
• Foreign key.

Question 74: Which path should be followed? This is a question from the phase of:

• Collaborate.
• Observe.
• Decide.
• Predict.

Question 75: The advance from the early Business Intelligence tools to today’s tools has been driven by making them more:

• Specialized programming and high cost.
• Larger data repository size.
• Intuitive, easy to use, higher processing data loading.

Question 76: What is ETL?

• It is the process for moving data from multiple sources.
• A Data connection protocol.
• A tool for importing and transforming data.
• None of the above.

Question 77: It is part of the ETL Process (Select all that apply) Choose all of the correct answers (multiple possibilities).

• Extract data.
• Transform data.
• Create data.
• Load data.
• All of the above.

Question 78: What is a Database?

• It is an organized collection of structured information or data, usually stored electronically in a computer system.
• Repository where all the transactional information of a company is transferred.
• Data Warehouse.
• All of the above.

Question 79: It is a collection of data describing the activities of an organization.

• File System.
• Entity – Relationship Diagram.
• Database.

Question 80: What is ETL?

• Extraction, Transformation and Cleaning.
• Extraction, Transformation and Load.
• Extraction, Transformation and Transportation.

Important Keys to Remember:

• Observe: What is happening?
• Understand: Why it happens?
• Predict: What would happen?
• Collaborate: What should the team do?
• Decide: Which way to go?