In dimensional modelling the first phase is toa.Identify grainb.Identify business processc.Identify tablesd.identify facts

Which of the following are examples of reference models that can be used for process identification.  ITIL  CMMI  SCOR  PCF  APQC

process management has four phase; under streamline phase we work ________.Select one:a. Analyses data to find area of improvement.b. Integrated of new processes & systemsc. Implement process restructured. All

1.Question 1True or false: Data modeling is only used to develop entity relational databases.1 pointTrueFalse2.Question 2Fill in the blank: The dimensions in a dimensional data model define the ______ for your measures.1 pointcontextquantityunits3.Question 3Fill in the blank: A dimensional data model is created using four key steps; identifying the ______, choosing the grain, the facts, and the dimensions.1 pointtextual datadata sourcelevel of detailbusiness process4.Question 4Which data model is typically used for complicated database projects? 1 pointObject-Oriented modelEntity Relationship model Dimensional modelHierarchical model5.Question 5In normalization of relational database models, which normal form deals with removing unnecessary duplicated data?1 pointFourth normal formFirst normal formSecond normal formThird normal form6.Question 6In data warehouse architecture, which process or processes takes place in the data staging component?1 pointextract, transform, and loadtrain and extractextract and loadtransform and load7.Question 7Which of the following describes what MySQL Workbench is?1 pointA tool for developers to create data models and manage data.External hardware that plugs into a computer to help with efficiently creating and managing data models.A computer that can efficiently handle anything database related.8.Question 8True or false: MySQL Workbench facilitates data migration between different versions of MySQL, and between MySQL and other relational database systems. 1 pointTrueFalse9.Question 9Fill in the blank: ______ data analysis identifies patterns to better make informed decisions about the future.1 pointPredictiveExploratoryCausalInteresting10.Question 10True or false: With MySQL Workbench, you can use the reverse engineer method to create an ER diagram from an existing database. 1 pointTrueFalse11.Question 11Fill in the blank: A data _________ is a centralized data repository that aggregates, stores and processes large amounts of data from multiple sources for data analytics.1 pointwarehouseshopcentermodel12.Question 12In dimensional data modeling, after selecting the business process to focus on you must choose the grain. Which of the following is the grain concerned with? Select all that apply.1 pointThe size of the data set.The lowest level of detail required.The facts and dimensions.The detail required to address the problem.13.Question 13An Entity Relationship data model represents a database as a collection of relations. How are these relations presented?1 pointAs an entity with its own set of attributes.As an entity with primary and foreign keys.As an entity with no attributes.As a conceptual diagram.14.Question 14Fill in the blank: The hierarchical data model organizes data in a tree-like or a parent-child structure. Because of its structure it can only be used to record ______ relationships.1 pointone to manyone to onemany to many15.Question 15The ______ scale describes the ordering of data without defining the degree of variation between data points.1 pointordinalintervalnominalratio16.Question 16Which database system(s) is the data ware

___ is the first and initial phase of the Prototype Model. This phase is used to identify the problem.*1 pointTestingProblem identificationDesign

Which phase of the SDLC would the following task most likely occur in?The analyst teaches the plant manager how to generate a new predefined report using a new system. Question 2Select one:a.Planningb.Analysisc.Designd.Implementatione.Support