Prévia do material em texto

<p>Business Intelligence Foundation Professional</p><p>Certification Exam Answers – Certiprof</p><p>Question 1: It is the attribute of an entity that exists as a dependency on another entity, whose values must match values of a</p><p>key that must be primary to another relationship:</p><p>Foreign Key.</p><p>Composite Primary Key.</p><p>Primary Key.</p><p>Question 2: A foreign key must correspond to a primary key of another table.</p><p>True.</p><p>False.</p><p>Question 3: What is a data source in general?</p><p>It is the location where the data being used comes from.</p><p>A BI software.</p><p>A Data Mining Platform.</p><p>Question 4: One of the difficulties in implementing BI solutions is the diversity of data sources you may have, what would be a</p><p>solution to this?</p><p>Perform analysis for each source.</p><p>Data integration.</p><p>Request to unify data sources.</p><p>Export data.</p><p>Question 5: Data relationships and constraints are a concept of:</p><p>Data relationship model.</p><p>Qlik Sense.</p><p>Power BI.</p><p>Primary key.</p><p>Question 6: Transformation is part of:</p><p>ETL.</p><p>Descriptive analysis.</p><p>Prescriptive Analysis.</p><p>Predictive analytics.</p><p>Question 7: Full extraction is performed only with the data that have changed since a given event.</p><p>True.</p><p>False.</p><p>Question 8: Incremental extraction is performed only on data that has changed since a given event.</p><p>True.</p><p>False.</p><p>10/09/2024, 17:08 Business Intelligence Foundation Professional Certification Exam Answers - Certiprof - Priya Dogra - Certification | Jobs | Inte…</p><p>https://priyadogra.com/business-intelligence-foundation-professional-certification-exam-answers-certiprof/ 1/11</p><p>Question 9: Use of historical data analysis to identify trends and relationships:</p><p>Historical Analysis.</p><p>Descriptive Analysis.</p><p>Referential analysis.</p><p>Question 10: Identify the likelihood of future outcomes based on historical data:</p><p>Descriptive Analytics.</p><p>Historical Analytics.</p><p>Predictive Analytics.</p><p>Prescriptive Analytics.</p><p>Question 11: Discovering patterns and forecasting future patterns, using advanced statistics and predictive analytics is the</p><p>definition of:</p><p>Advanced programmer.</p><p>BI Developer.</p><p>Data science.</p><p>BI Analysis.</p><p>Question 12: What is happening? This question should be asked in the phase:</p><p>Observe.</p><p>Understand.</p><p>Predict.</p><p>Decide.</p><p>Question 13: Processes that read the data from the different sources, transform and adapt them to the model we have defined,</p><p>debug and clean them, and introduce them into the target database:</p><p>Transformation Processes.</p><p>Extraction Processes.</p><p>Data Loading Processes.</p><p>Question 14: Why does it happen? It is a question of the phase of:</p><p>Predict.</p><p>Collaborate.</p><p>Observe.</p><p>Understand.</p><p>Question 15: What does the acronym BI stand for?</p><p>Business Improve.</p><p>Business Impact.</p><p>Business Intelligence.</p><p>Business Insider.</p><p>Question 16: What is a real and measurable advantage of using BI?</p><p>Time increase.</p><p>Reduction of information security.</p><p>Identification of new business opportunities.</p><p>10/09/2024, 17:08 Business Intelligence Foundation Professional Certification Exam Answers - Certiprof - Priya Dogra - Certification | Jobs | Inte…</p><p>https://priyadogra.com/business-intelligence-foundation-professional-certification-exam-answers-certiprof/ 2/11</p><p>Expand the company’s value chain.</p><p>Question 17: Some of these are sources of data collection:</p><p>Databases.</p><p>Flat files.</p><p>Registration data.</p><p>All of the above.</p><p>Question 18: Depending on the requirement of the organization the data upload can have a variety of different actions.</p><p>True.</p><p>False.</p><p>Question 19: “What is most likely to happen in the future based on historical trends?” the type of analysis that can help me</p><p>answer the above question is:</p><p>Prescriptive Analytics.</p><p>Predictive Analytics.</p><p>Descriptive Analytics.</p><p>Historical Analytics.</p><p>Question 20: Which of the following options are part of the BI strategy?</p><p>Identify key stakeholders.</p><p>Failure to define the scope.</p><p>Have a roadmap.</p><p>A and B are correct.</p><p>A and C are correct.</p><p>None is correct.</p><p>All are correct.</p><p>Question 21: What is a Business Intelligence platform for?</p><p>As an Internet browser.</p><p>As Software to create reports and analyze data.</p><p>To Generate Graphics.</p><p>As a Spreadsheet.</p><p>Question 22: The model showing the limitations of data storage is called:</p><p>Transformation model.</p><p>Data relationship model.</p><p>ETL Model.</p><p>Granularity model.</p><p>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</p><p>primary key value.</p><p>True.</p><p>False.</p><p>Question 24: What is a Primary Key?</p><p>It is a single field within a table and is used to establish relationships between tables.</p><p>10/09/2024, 17:08 Business Intelligence Foundation Professional Certification Exam Answers - Certiprof - Priya Dogra - Certification | Jobs | Inte…</p><p>https://priyadogra.com/business-intelligence-foundation-professional-certification-exam-answers-certiprof/ 3/11</p><p>It’s to make my Tablet look pretty.</p><p>It is any field in the table.</p><p>It is a field used to protect my database.</p><p>Question 25: The word ETL stands for the acronym in English:</p><p>External, Transform, Load.</p><p>Extract, Transform, Load.</p><p>Extract, Transaction, Loading.</p><p>Extract, Transform, Loop.</p><p>Question 26: The name used to uniquely identify each record within a database table.</p><p>Database</p><p>Entity.</p><p>Foreign key</p><p>Primary key.</p><p>Question 27: A column or set of columns in a table whose values uniquely identify a row in the table. It is a_____________ key:</p><p>External.</p><p>Internal.</p><p>Foreign.</p><p>Primary.</p><p>Question 28: In a BI project it is important:</p><p>Identify the tools to be used.</p><p>Identify key stakeholders.</p><p>To have external expert advisors.</p><p>Question 29: The definition “data coming from the previous phase (transformation phase) are loaded in the target system”</p><p>corresponds to:</p><p>Data extraction.</p><p>Data transformation.</p><p>Data deletion.</p><p>Data upload.</p><p>Question 30: What are the phases of BI implementation?</p><p>Observing, Compiling, Predicting, Collaborating, Deciding.</p><p>Observing, Understanding, Programming, Collaborating, Deciding.</p><p>Observing, Understanding, Predicting, Collaborating, Dialoguing.</p><p>Observing, Understanding, Predicting, Collaborating, Deciding.</p><p>Question 31: During this process, data is taken (extracted) from a source system, converted (transformed) into a format that</p><p>can be stored and stored (loaded) in a data warehouse or other system, is the definition of:</p><p>Datawarehouse.</p><p>Accumulation.</p><p>ETL.</p><p>Rolling.</p><p>10/09/2024, 17:08 Business Intelligence Foundation Professional Certification Exam Answers - Certiprof - Priya Dogra - Certification | Jobs | Inte…</p><p>https://priyadogra.com/business-intelligence-foundation-professional-certification-exam-answers-certiprof/ 4/11</p><p>Question 32: The types of relationships between tables are:</p><p>1-to-1, 1-to-Many, many-to-one, many-to-many, many-to-many relationships.</p><p>Many-to-many relationships.</p><p>No relationships between tables are established.</p><p>1 to 1 ratio.</p><p>Question 33: When we refer to the set of strategies and tools focused on the data analysis of a company through the analysis of</p><p>existing data we talk about:</p><p>Data Science.</p><p>Business intelligence.</p><p>Data Analytics.</p><p>Data Information.</p><p>Question 34: Using the current data to identify data relationships is a ___________ analysis.</p><p>Recurring.</p><p>Predictive.</p><p>Prescriptive.</p><p>Descriptive.</p><p>Question 35: By having only internal data, is it possible to have a complete view of the business?</p><p>True.</p><p>False.</p><p>Question 36: The Entity Relationship diagram is used as:</p><p>Analysis to establish relationships between tables.</p><p>It is a diagram where data are related by their shapes.</p><p>Both of the above.</p><p>None of the above.</p><p>Question 37: What are the extraction techniques?</p><p>Simple extraction.</p><p>Complete Extraction.</p><p>Incremental Extraction.</p><p>All are correct.</p><p>A and B are correct.</p><p>A and C are correct.</p><p>B and C are correct.</p><p>None of the above.</p><p>Question 38: Scheme in which a central information table is connected to multiple dimensional tables.</p><p>Inverted.</p><p>Star.</p><p>Objects.</p><p>Structured.</p><p>Question 39: Identifying key trends is part of the____________ analysis.</p><p>10/09/2024, 17:08 Business Intelligence Foundation Professional Certification Exam Answers - Certiprof - Priya Dogra - Certification | Jobs | Inte…</p><p>https://priyadogra.com/business-intelligence-foundation-professional-certification-exam-answers-certiprof/</p><p>5/11</p><p>Predictive.</p><p>Descriptive.</p><p>Recurring.</p><p>Prescriptive.</p><p>Question 40: In recent years, processes have been added to business intelligence software to improve performance. These</p><p>include:</p><p>Data Visualization.</p><p>Data quality management and monitoring.</p><p>Dynamic Report Generation.</p><p>All of the above.</p><p>Question 41: Effectively aggregating as much data as possible and making it easy to interpret can support increased</p><p>productivity and efficiency.</p><p>True.</p><p>False.</p><p>Question 42: We would like to estimate how many sales there will be in the month of August</p><p>Predictive Analytics.</p><p>Diagnostic Analysis.</p><p>Descriptive Analytics.</p><p>Prescriptive Analytics.</p><p>Question 43: Load is part of:</p><p>ETL.</p><p>Predictive analytics.</p><p>Prescriptive Analysis.</p><p>Descriptive analysis.</p><p>Question 44: Extraction is part of:</p><p>Prescriptive Analysis.</p><p>Predictive analytics.</p><p>Descriptive analysis.</p><p>ETL.</p><p>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.</p><p>True.</p><p>False.</p><p>Question 46: What do you see as the purpose of business intelligence solutions in organizations?</p><p>Data integration.</p><p>Promote business sales.</p><p>Facilitate and improve decision making.</p><p>Facilitate data collection.</p><p>Question 47: What data integration is used to blend data from multiple sources?</p><p>Saas.</p><p>10/09/2024, 17:08 Business Intelligence Foundation Professional Certification Exam Answers - Certiprof - Priya Dogra - Certification | Jobs | Inte…</p><p>https://priyadogra.com/business-intelligence-foundation-professional-certification-exam-answers-certiprof/ 6/11</p><p>Extract, Re-engineer, Programming.</p><p>Extract, Transform, Load.</p><p>Extract, Program, Load.</p><p>Question 48: The main benefits of Business Intelligence are as follows.</p><p>Organization, Budget and Administration.</p><p>Decisions, Analysis and Proposals.</p><p>Decisions, Big Data Consumption and Proposals.</p><p>Time savings, data clarity and customizable reporting.</p><p>Question 49: “The combination of technology, tools and processes that allow me to transform my stored data into information,</p><p>this information into knowledge and this knowledge directed to a business plan or strategy. The above is the definition of:”</p><p>Business intelligence.</p><p>Business intelligence.</p><p>Production intelligence.</p><p>Management intelligence.</p><p>Question 50: Considerations for choosing data visualization software</p><p>Integration of different data sources and with other platforms.</p><p>Variety of languages.</p><p>Free.</p><p>Multiplatform.</p><p>Question 51: Easily accessible data repository that draws from multiple data sources</p><p>ETL.</p><p>Datawarehouse.</p><p>Data mining.</p><p>Analysis.</p><p>Question 52: Which of the following is part of the challenges in data mining?</p><p>Compatibility problems.</p><p>Unstructured data correctly.</p><p>Data security.</p><p>All of the above.</p><p>Question 53: Key that provides a unique value for each row in a table.</p><p>Foreign key.</p><p>Primary key.</p><p>Secondary key.</p><p>None of the above.</p><p>Question 54: Select those necessary to complete the structured business intelligence architecture.</p><p>Data Sources.</p><p>ETL.</p><p>Data Repository.</p><p>Access Interface.</p><p>All of the above.</p><p>10/09/2024, 17:08 Business Intelligence Foundation Professional Certification Exam Answers - Certiprof - Priya Dogra - Certification | Jobs | Inte…</p><p>https://priyadogra.com/business-intelligence-foundation-professional-certification-exam-answers-certiprof/ 7/11</p><p>Question 55: Recommending possible actions is part of the_______________ analysis.</p><p>Prescriptive.</p><p>Recurring.</p><p>Predictive.</p><p>Descriptive.</p><p>Question 56: If you want to know how many new customers there will be next year, you can use:</p><p>Descriptive Analytics.</p><p>Predictive Analytics.</p><p>Diagnostic Analysis.</p><p>Prescriptive Analytics.</p><p>Question 57: Claiming that the primary and foreign key are the same is:</p><p>True.</p><p>False.</p><p>Question 58: It is mainly used for filtering data, merging fields and deleting or correcting erroneous fields:</p><p>SAAS.</p><p>ETL.</p><p>Transformation.</p><p>Load.</p><p>Question 59: The process of converting data or information from one format to another, usually from the format of a source</p><p>system to the required format of a new target system:</p><p>Data Transformation.</p><p>Data Extraction.</p><p>Data Modeling.</p><p>Data Loading.</p><p>Question 60: The logical structure of how data is related and stored is a concept of:</p><p>ETL.</p><p>Primary key.</p><p>Data relationship model.</p><p>Power BI.</p><p>Question 61: Data quality and security is a challenge of:</p><p>Data loading.</p><p>Data extraction.</p><p>Data transformation.</p><p>All of the above.</p><p>Question 62: Drawing conclusions from data analysis using statistical analysis is the concept of:</p><p>Data analysis.</p><p>Data science.</p><p>BI Analysis.</p><p>None of the above.</p><p>10/09/2024, 17:08 Business Intelligence Foundation Professional Certification Exam Answers - Certiprof - Priya Dogra - Certification | Jobs | Inte…</p><p>https://priyadogra.com/business-intelligence-foundation-professional-certification-exam-answers-certiprof/ 8/11</p><p>Question 63: Joining different fields to obtain a consolidated view is part of the process:</p><p>Data loading.</p><p>Data extraction.</p><p>Data transformation.</p><p>All of the above.</p><p>Question 64: How data is stored and accessed is a concept of:</p><p>Primary key.</p><p>Secondary key.</p><p>Data relationship model.</p><p>Data extraction.</p><p>Question 65: What is granularity?</p><p>Organized collection of information.</p><p>Confirmation of data upload.</p><p>Existence of business data.</p><p>Level of detail at which business information is stored.</p><p>Question 66: Why is it important to find the right enterprise BI platform?</p><p>To save costs in the company.</p><p>To adapt to the market.</p><p>To achieve the necessary agility without sacrificing data security.</p><p>To forecast data.</p><p>Question 67: Data transformation helps in the process of:</p><p>Extract information and analyze it.</p><p>Storing data in a data warehouse.</p><p>Load the information in a new destination.</p><p>Convert data from one format to a more user-friendly format.</p><p>Question 68: What is a common form of Entity-Relationship Diagram (ERD)?</p><p>Objects.</p><p>Structured.</p><p>Star.</p><p>Inverted.</p><p>Question 69: Databases are an organized collection of data</p><p>True.</p><p>False.</p><p>Question 70: When I generate a data load where only data that has been updated or changed since a discrete past event is</p><p>extracted. This is a type extraction:</p><p>Incremental.</p><p>Complete.</p><p>Progressive.</p><p>Closed.</p><p>10/09/2024, 17:08 Business Intelligence Foundation Professional Certification Exam Answers - Certiprof - Priya Dogra - Certification | Jobs | Inte…</p><p>https://priyadogra.com/business-intelligence-foundation-professional-certification-exam-answers-certiprof/ 9/11</p><p>Question 71: One data is:</p><p>Concrete information about facts, elements, etc., that allows them to be studied, analyzed or known.</p><p>The registration of an event.</p><p>One variable.</p><p>A numeric value, generated by a transaction.</p><p>Question 72: What does KPI stand for?</p><p>Knowledge Panning Indicator.</p><p>Key Planning Indicator.</p><p>Key Performance Indicator.</p><p>None of the above.</p><p>Question 73: Column or a set of columns in a table whose values correspond to the values of the primary key of another table,</p><p>this concept refers to:</p><p>Common key.</p><p>Structured key.</p><p>Primary key.</p><p>Foreign key.</p><p>Question 74: Which path should be followed? This is a question from the phase of:</p><p>Collaborate.</p><p>Observe.</p><p>Decide.</p><p>Predict.</p><p>Question 75: The advance from the early Business Intelligence tools to today’s tools has been driven by making them more:</p><p>Specialized programming and high cost.</p><p>Larger data repository size.</p><p>Intuitive, easy to use, higher processing data loading.</p><p>Question 76: What is ETL?</p><p>It is the process for moving data from multiple sources.</p><p>A Data connection protocol.</p><p>A tool for importing and transforming data.</p><p>None of the above.</p><p>Question 77: It is part of the ETL Process (Select all that apply) Choose all of the correct answers (multiple possibilities).</p><p>Extract data.</p><p>Transform data.</p><p>Create data.</p><p>Load data.</p><p>All of the above.</p><p>Question 78: What is a Database?</p><p>It is an organized collection of structured information or data, usually stored electronically in a computer system.</p><p>Repository where all the transactional information of a company is transferred.</p><p>10/09/2024, 17:08 Business Intelligence Foundation Professional Certification Exam Answers - Certiprof - Priya Dogra - Certification</p><p>| Jobs | Inte…</p><p>https://priyadogra.com/business-intelligence-foundation-professional-certification-exam-answers-certiprof/ 10/11</p><p>Data Warehouse.</p><p>All of the above.</p><p>Question 79: It is a collection of data describing the activities of an organization.</p><p>File System.</p><p>Entity – Relationship Diagram.</p><p>Database.</p><p>Question 80: What is ETL?</p><p>Extraction, Transformation and Cleaning.</p><p>Extraction, Transformation and Load.</p><p>Extraction, Transformation and Transportation.</p><p>Important Keys to Remember:</p><p>Observe: What is happening?</p><p>Understand: Why it happens?</p><p>Predict: What would happen?</p><p>Collaborate: What should the team do?</p><p>Decide: Which way to go?</p><p>10/09/2024, 17:08 Business Intelligence Foundation Professional Certification Exam Answers - Certiprof - Priya Dogra - Certification | Jobs | Inte…</p><p>https://priyadogra.com/business-intelligence-foundation-professional-certification-exam-answers-certiprof/ 11/11</p>