Priya Dogra – Certification | Jobs | Internships
Related Articles
Certiprof Business Intelligence Foundatión – BIFPC Exam Answers
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.!
- Closed.
- Complete.
- Progressive.
Use of historical data analysis to identify trends and relationships:
Referential analysis.
Historical Analysis.!
Descriptive Analysis.
The advance from the early Business Intelligence tools to today’s tools has been driven by making them more:
Larger data repository size.
Specialized programming and high cost.
Intuitive, easy to use, higher processing data loading.!
Easily accessible data repository that draws from multiple data sources
ETL.
Data mining.
Analysis.
Datawarehouse.!
The way data is structured and organized so that it can be easily used by databases. It is defined as:
Data Relationship Modeling.!
Data Loading.
Word processing.
Joining different fields to obtain a consolidated view is part of the process:
Data loading.
Data extraction.
Data transformation.!
All of the above.
One of the difficulties in implementing BI solutions is the diversity of data sources you may have, what would be a solution to this?
Data integration.!
Export data.
Perform analysis for each source.
Request to unify data sources.
Load is part of:
Prescriptive Analysis.
Descriptive analysis.
ETL.!
Predictive analytics.
Identifying key trends is part of the____________ analysis.
Prescriptive.
Predictive.
Descriptive.!
Recurring.
Incremental extraction is performed only on data that has changed since a given event.
True.!
False.
Recommending possible actions is part of the_______________ analysis.
Descriptive.
Prescriptive.!
Recurring.
Predictive.
In a BI project it is important:
Identify key stakeholders.!
To have external expert advisors.
Identify the tools to be used.
Databases are not an organized collection of data.
True.
False.!
The main benefits of Business Intelligence are as follows.
Time savings, data clarity and customizable reporting.!
Organization, Budget and Administration.
Decisions, Analysis and Proposals.
Decisions, Big Data Consumption and Proposals.
What is ETL?
Extraction, Transformation and Cleaning.
Extraction, Transformation and Load.!
Extraction, Transformation and Transportation.
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.
Discovering patterns and forecasting future patterns, using advanced statistics and predictive analytics is the definition of:
BI Analysis.
Data science.!
Advanced programmer.
BI Developer.
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.
Considerations for choosing data visualization software
Variety of languages.
Multiplatform.
Free.
Integration of different data sources and with other platforms.!
If you want to know how many new customers there will be next year, you can use:
Predictive Analytics.!
Descriptive Analytics.
Diagnostic Analysis.
Prescriptive Analytics.
It is often used to build a data warehouse.
Data.
ETL.!
IAAS.
PAAS.
What are the phases of BI implementation?
Observing, Understanding, Programming, Collaborating, Deciding.
Observing, Understanding, Predicting, Collaborating, Deciding.!
Observing, Compiling, Predicting, Collaborating, Deciding.
Observing, Understanding, Predicting, Collaborating, Dialoguing.
Extract the data completely from its source and load it into the target location as it is:
Complete Compilation.
Incremental Loading.
Data loss.
Complete extraction.!
Claiming that the primary and foreign key are the same is:
True.
False.!
By having only internal data, is it possible to have a complete view of the business?
True.
False.!
What data integration is used to blend data from multiple sources?
Extract, Transform, Load.!
Extract, Re-engineer, Programming.
Extract, Program, Load.
Saas.
Why does it happen? It is a question of the phase of:
Collaborate.
Predict.
Understand.!
Observe.
Data quality and security is a challenge of:
Data loading.
Data extraction.
Data transformation.
All of the above.!
Drawing conclusions from data analysis using statistical analysis is the concept of:
Data analysis.
Data science.!
BI Analysis.
None of the above.
The word ETL stands for the acronym in English:
Extract, Transform, Loop.
Extract, Transform, Load.!
Extract, Transaction, Loading.
External, Transform, Load.
What is a common form of Entity-Relationship Diagram (ERD)?
Structured.
Objects.
Star.!
Inverted.
What is happening? This question should be asked in the phase:
Observe.!
Understand.
Predict.
Decide.
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.
Which of the following is part of the challenges in data mining?
Compatibility problems.
Unstructured data correctly.
Data security.
All of the above.!
Transformation is part of:
Predictive analytics.
Prescriptive Analysis.
Descriptive analysis.
ETL.!
Full extraction is performed only with the data that have changed since a given event.
True.
False.!
Effectively aggregating as much data as possible and making it easy to interpret can support increased productivity and efficiency.
True.!
False.
We would like to estimate how many sales there will be in the month of August
Prescriptive Analytics.
Descriptive Analytics.
Predictive Analytics.!
Diagnostic Analysis.
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.
Scheme in which a central information table is connected to multiple dimensional tables.
Star.!
Inverted.
Objects.
Structured.
