DBMS Midterm

c) 1:1 (self-referential) relationship

Parent-child dimensions is built on a table that contains a ___________. Question options: a) 1:M relationship b) M:N relationship c) 1:1 (self-referential) relationship d) no relationships to other tables

e) Only a. and b.

SQL Server Analysis Services allow creating ___________ of underlying data. a) BI Multidimensional Model b) BI Tabular Model c) BI Object-oriented Model d) All of the above Correct Response e) Only a. and b.

True

The ETL process, in part, extracts data from one or more OLTP systems and loads it into the data mart. Correct Response True False

b) XML

The definitions of all objects in the Multidimensional model are stored as ___________ text files. a) HTML Correct Response b) XML c) CSV d) Excel

c) by connecting the preceding arrow from one task to the task that is to run after it

We control the order in which the tasks are executed ________________. Question options: a) using if statement, for and while statements b) assigning events with each task in the control flow c) by connecting the preceding arrow from one task to the task that is to run after it d) developing a main control program

All of the above

What group(s) in a company are responsible for effective decisions? Upper management / executive team Software engineerings Business analyst All of the above;

"b) Precedence arrows

__________ are used within Integration services packages to pass information between the various parts of the package. Question options: a) Variables b) Precedence arrows c) Data flow tasks d) Control flow tasks '

b) The lowest level

___________ of a particular dimension hierarchy that is related to a given measure group determines the granularity of that measure group for that dimension. Question options: a) The highest level b) The lowest level c) The middle level d) All levels

TRUE

"A data mart is needed if the database does not have an appropriate data provider.

FALSE

"A data mart is needed if the database is accessible only via FTP.

TRUE

"A data mart is needed if the underlying data is only in files (and not in a database).

FALSE

"BI requires a data mart

d) All of the above

"The decision makers have to answer the following question(s): ______________.

d) the decision makers themselves

"The goal of the business intelligence is to provide tools and information for effective decision making. Therefore, any business intelligence design must start with __________.

FALSE

"A data mart is needed if the data is stored in an OLTP system.

b) a structure made up of two or more levels

A hierarchy is ___________ within a dimension. a) a network structure of attributes Correct Response b) a structure made up of two or more levels c) a set of attributes describing a star schema d) all of the above

a) square brackets

A qualified identifier must be enclosed in ___________. Question options: a) square brackets b) curly braces c) parentheses d) double quotes '

b) another dimension, measure group

A reference dimension is related to ___________, which is, in turn, related to the ___________. Question options: a) the measure group, parent dimension b) another dimension, measure group c) another dimension, child dimension d) the measure group, child dimension

b) Relational database schema

A star schema is a __________ used to hold measures and dimensions in a data mart. a) File system schema Correct Response b) Relational database schema c) Hierarchical database schema d) Object-oriented database schema

a) multiple times

A role playing dimension is a dimension that is related to the same measure group ___________. Question options: a) multiple times b) with 1:M relationship c) with 1:1 relationship d) with dominant role

c) the sequence of tasks that will be performed by the package

An Integration Services package overall operation is defined by the control flow. The control flow is ____________. Question options: a) the filter that controls the data load into the data mart b) a repetition data structure c) the sequence of tasks that will be performed by the package d) a set of input/output programs

a) value

An aggregate is a __________ formed by combining values from a given dimension or set of dimensions. Correct Response a) value b) dimension c) hierarchy d) cube table

d) an additional piece of information

An attribute is __________ pertaining to a dimension member that is not unique identifier or description of the member. a) a primary key b) a foreign key c) an attribute used for indexing Correct Response d) an additional piece of information

c) packages

An environment is a set of values that can be shared among several ______________. Question options: a) parameters b) predefined control flow tasks c) packages d) predefined data flow tasks e) values '

False

As soon as the ETL process is complete, the process to transform the data into a consistent format can begin. True False

FALSE

BI requires a data mart Question options: True False

d) determine which data has changed since the last ETL process

CDC (Change Data Capture) is a method to ___________. Question options: a) change database table data without data constraints b) change data to capture aggregate values c) capture data with changing the format of the data d) determine which data has changed since the last ETL process '

c) measures and dimensions

Calculated members can be defined using ___________. Question options: a) measures only b) dimensions only c) measures and dimensions d) calculated measures only

__3__ Managers & group leaders __5__ Upper management __4__ Mid-level management

Choose the amount (if any) of latency that the different levels of management can tolerate: Managers & group leaders Upper management Mid-level management 1. No latency (delay is never a good thing) 2. 0-60 seconds latency 3. hourly - daily latency 4. weekly - monthly latency 5. Latency OK

d) can hold other Control Flow item and Maintenance Plan task

Containers in the SSIS Control Flow Toolbox are a special type of item that ____________. They help us repeat a set of tasks or organize group of tasks within the package. Question options: a) can hold data from the source b) can hold data from the source and destination c) can hold another project d) can hold other Control Flow item and Maintenance Plan task

a) write data to

Data flow destinations let us _________ relational databases, flat files, XML files, and certain Analysis Services structures. Question options: a) write data to b) create elements of c) download data from d) retrieve data from "

Data Cleansing

Data from a number of different OLTP systems may be combined into a single data mart. Removing inconsistencies and errors from transactional data is called _________. a) Data brush Correct Response b) Data cleansing c) Data formatting d) Data rounding

B) False

Data load is the periodical copying of data from the data mart to the OLTP. Incorrect Response A)True B) False

d) fact dimensions

Dimensions created from attributes in a fact table are known as __________. Question options: a) reference dimensions b) parent-child dimensions c) many-to-many dimensions d) fact dimensions

d) all of the above

Dimensions enable us to _____________. Question options: a) slice b) dice c) provide understandable phrases in business language d) all of the above

c) @ (at)

Identifiers that represent variables are always preceded by a sign ________. Question options: a) & (ampersand) b) _ (underscore) c) @ (at) d) $ (dollar) '

a) separate dimension table

In a snowflake schema, each level of hierarchy is stored in __________. Correct Response a) separate dimension table b) the fact table c) separate index d) a snowflake table

d) measure groups

In the Multidimensional BI Semantic Model, measures do not exist on their own inside cubes. Instead, they are clustered together and managed as a set. These collections are called ___________. Question options: a) measure sets b) measure lists c) measure clusters d) measure groups

c) we can specify routines to execute when a particular event occurs

Integration Services packages are event-driven. This means that ___________. Question options: a) data flow tasks are considered as events b) control flow tasks are considered as events c) we can specify routines to execute when a particular event occurs d) we can specify parameters of data flow tasks to run events

"d) drag-and-drop

Integration Services uses a(n) ___________ development style. Question options: a) copy and paste b) IntelliSense c) Object-oriented style d) drag-and-drop

Not necessarily, it needs to be digestible to guide effective decisions

Is data BI? Yes, by definition No, data is never BI Not necessarily, it needs to be digestible to guide effective decisions;

c) fact tables, data mart

Measures come from the fields in the __________ in the ____________. Question options: a) report tables, dashboard reports b) OLTP database, Product and Sales database tables c) fact tables, data mart d) data warehouse, snowflake schema

"c) actual information, numeric data

Measures provide the __________ that users of cubes are interested in. Measures are the bits of _____________ that we need to aggregate. Question options: a) reports, charts b) input data, currency data c) actual information, numeric data d) dimensions, statistics

b) nonadditive measures

Measures that use the maximum or minimum value for a measure along a dimension are called ____________. Question options: a) additive measures b) nonadditive measures c) integrative measures d) semiadditive measures

a) pause the program execution at breakpoint

One of the most helpful tools in program development is the capability to ___________ and examine the execution state. Integration Services provides this functionality. Question options: a) pause the program execution at breakpoint b) organize loops c) organize a program as a sequence of data flow tasks d) check for some conditions it selection statements '

b) moves data from one place to another

One of the most often used control flow tasks is the data flow task. The data flow task ____________. Question options: a) creates primary key for the fact table b) moves data from one place to another c) moves database applications to the data mart d) creates data mart referential integrity View Feedback

d) data mart

Online analytical processing (OLAP) systems enable users to quickly and easily retrieve information from data, usually in a(n) __________. a) direct access file b) OLTP database c) object-oriented database d) data mart

Record business interactions, day-to-day

Online transaction processing (OLTP) systems ____________ as they happen. They support the ____________ operation of an organization. a) Record business interactions, human resources b) Record only sales transactions, day-to-day Correct Response c) Record business interactions, day-to-day d) Run queries, data mart

List a goal that would exemplify as a 'SMART' Goal

Overall goal: Learn to play guitar S (Specific)- I would like to learn 5 major and 5 minor guitar chords that I can play along to 3 popular songs by my favorite artist (Tori Kelly) by February 25, 2018 at 3:00pm. M (Measurable)- I would like to learn 5 major chords and 5 minor chords in 1 position for each chord. A (Appropriate)- Play 5 major chords and 5 minor chords 1 position along to 3 favorite songs R (Realistic) - In order to set realistic yet challenging goal, I would like to learn these 10 chords (5 major, 5 minor) in at least one position along to 3 songs within the next 30 days. This realistic because I am not aiming for a goal that is out of reach (e.g., become a world-renown professional guitar player within the next 30 days); or not challenging enough (e.g., learn 1 chord on the guitar within the next month). For my ability/experience level this goal feasible and realistic. T(Timely)- I would like to learn to play 5 major chords and 5 minor chords along to three songs by my favorite artist by February 25, 2018 at 3:00pm. This time constraint holds me accountable to a deadline and allows the overall goal to become more tangible.

"it's a mature software product with thousands of users

SQL Server Data Tools has built-in editing and debugging tools, source code management integration, and other helpful tools because ___________. Question options: clients demanded them based on the purchase price it's a mature software product with thousands of users it's really hard to do BI without them it's Visual Studio

it's a mature software product with thousands of users

SQL Server Data Tools has built-in editing and debugging tools, source code management integration, and other helpful tools because ___________. Question options: clients demanded them based on the purchase price it's a mature software product with thousands of users it's really hard to do BI without them it's Visual Studio

b) folder and project level

Security for IS packages on the server can be set at the ___________. Question options: a) data flow task level b) folder and project level c) input and output data d) control flow task level'"

c) some measures, others

Semiadditive measures can be added along ___________ but no along ___________. Question options: a) some measures, dimensions b) some dimensions, others c) some measures, others d) all dimensions, measures

c) manage all connections in a IS package

The Connection tray in SSIS is used to ____________. Question options: a) maintain connection to the SSIS database b) maintain connection to the SSRS database c) manage all connections in a IS package d) manage all connections to any source and destination

b) Data Flow Task

The Control Flow items include ___________ that implements the actual transfer of data from source to destination. Question options: a) Execute SQL Task b) Data Flow Task c) Data Source, Destination, Transform Task d) Data Transform Service Task

c) Data flow service

The Data Flow SSIS Toolbox contains three types of objects. Which of the following is NOT an object type from the Data Flow SSID Toolbox? Question options: a) Data flow source b) Data flow destination c) Data flow service d) Data flow transformation

d) Source, Destination

The Data Flow SSIS Toolbox contains two assistants that aid in the process of creating data flow sources and destinations. They are _________ and _________ assistants. Question options: a) Input, Output b) Download, Upload c) Editor, Advanced Editor d) Source, Destination

c) store and execute IS packages on the server

The Integration Services Catalog allows us to ____________. Question options: a) list all different control and data flow tasks from an IS package b) select which control task to be executed c) store and execute IS packages on the server d) debug an IS package '

c) aggregate values

The cube also contains ___________ formed by the dimension hierarchies or when one or more of the dimensions is left out of the hierarchy. a) dimensions b) measures c) aggregate values d) queries

d) database relationships

The data flow transformations are used to modify the __________ as it moves through the data flow. Question options: a) data b) database c) data mart d) database relationships

d) All of the above

The decision makers have to answer the following question(s): ______________. Question options: a) What facts, figures, statistics, and so forth you need for effective decision making? b) How this information should be sliced and diced? c) What additional information can aid in finding exactly what is needed? d) All of the above

c) foundation and feedback measures

The facts, figures, statistics, and so forth are for the ____________ in a data mart. Question options: a) dimensions b) hierarchies c) foundation and feedback measures d) attributes"

d) the decision makers themselves

The goal of the business intelligence is to provide tools and information for effective decision making. Therefore, any business intelligence design must start with __________. Question options: a) design of data mart b) design of reports c) design of OLTP d) the decision makers themselves

c) at run time

The parameters in an IS package allow some interaction with the package __________. Question options: a) design editor b) solution explorer c) at run time d) at design time '

c) Fact tables, dimension tables

The star schema uses two types of tables: _________ and __________. a) Normalized, unnormalized b) Vertical partitioned, horizontal partitioned Correct Response c) Fact tables, dimension tables d) Query tables, dependency tables

a) foreign key fields, primary key fields

To aggregate cube measures by dimensions, the dimensions must be related somehow to the measures. This is done by using ___________ in the fact table and ____________ in the dimension tables. Question options: a) foreign key fields, primary key fields b) primary key fields, foreign key fields c) foreign key fields, foreign key fields d) primary key fields, primary key fields

e) Only a. and b.

To load and maintain data mart data we need the following CDC (Change Data Capture) Integration Services (IS) package(s): ____________. Question options: a) CDC initial load package b) CDC incremental load package c) CDC scheduled load package d) All of the above e) Only a. and b. '

a) a series of items in a package all completed successfully

Transactions in Integration Services packages ensure that our data remains in a consistent state. By using transactions

b) selecting the correct data flow task from the drop-down list of the SSIS toolbox

We need to drill down into a data flow task to define the content of the data flow. This done by _____________. Question options: a) creating SQL statements b) selecting the correct data flow task from the drop-down list of the SSIS toolbox c) selecting the correct XML file from the Solution Explorer d) creating a new DTP (Data Transformation Project)

A number that is calculated from amounts in many details records

What is an aggregate? a) Set of material used in construction of business intelligence b) Technique used in algorithm analysis c) SQL query that retrieves all transactions of a given type Correct Response d) A number that is calculated from amounts in many details records

b) loads all data into memory

When operating in cached mode, the Tabular model ____________. a) directly queries the database Correct Response b) loads all data into memory c) caches all data onto a virtual disk memory d) loads all data into a data cube

c) queries the underlying data sources to get its results

When operating in direct query mode, the Tabular model always ___________. a) queries the data cube b) queries database tables with JOIN and GROUP BY clauses Correct Response c) queries the underlying data sources to get its results d) queries the database with nested SQL queries

period

When two data flow columns have the same name, we can include the name of the data flow source or transformation item, where each column was created. A(n) ________ is placed between the item name and the column name.

e) all of the above

When using Multidimensional model, the business data takes the form of __________. a) measures b) dimensions c) hierarchies d) cubes Correct Response e) all of the above

c) IfElse Container

Which of the following is NOT a Container from the SSIS Control Flow Toolbox? Question options: a) For Loop Container b) Foreach Loop Container c) IfElse Container d) Sequence Container

d) Star Schema task

Which of the following is NOT a Control Flow SSIS Toolbox object type? Question options: a) Container b) Control Flow Task c) Maintenance Plan task d) Star Schema task

d) lowest level of each hierarchy

With the snowflake schema the foreign keys of the fact table are primary keys of the ___________. a) all dimension tables from an hierarchy b) measure tables c) data mart tables d) lowest level of each hierarchy

b) Expressions

__________ let us modify the behavior of a package by evaluating conditions and changing properties at run time. Question options: a) Control flow tasks b) Expressions c) Variables d) Data flow tasks '

c) MDX (Multidimensional Expression Language)

_______________ is a special language with features designed to handle the advanced mathematics and formulas required by OLAP analysis. Question options: a) MDC (Multidimensional Cube Language) b) DAX (Data Analysis Language) c) MDX (Multidimensional Expression Language) d) MDA (Multidimensional Data Analysis Language)

a) additive measures

measures that use the Sum function for their aggregates are called __________. Question options: a) additive measures b) nonadditive measures c) integrative measures d) semiadditive measures

FALSE

A data mart is needed if the data is stored in an OLTP system. Question options: True False

a) measures

A cube is a structure that contains a value for one or more __________ for each combination of the members of all its dimensions. a) measures b) dimensions c) hierarchies d) aggregates

c) dragging a data flow item from the SSIS toolbox and placing it in the control flow

A data flow task is created by ___________. Question options: a) developing Visual Basic program b) developing C# program c) dragging a data flow item from the SSIS toolbox and placing it in the control flow d) opening the Data Flow design ta

True

A data mart is a body of historical data in electronic repository that does not participate in daily operations of the organization. True False

False

A data mart is a collection of all of a companies data, that individual organizations can use. True False

TRUE

A data mart is needed if the database does not have an appropriate data provider. Question options: True False

FALSE

A data mart is needed if the database is accessible only via FTP. Question options: True False

TRUE

A data mart is needed if the underlying data is only in files (and not in a database). Question options: True False

True

A data warehouse is a large, one-stop-shopping repositories, where all the historical data for the organization would be stored. Correct Response True False

d) Only a) and b)

A dimension in a data mart is ___________. a) A categorization used to spread out an aggregate measure to reveal its constituent parts b) Structured labeled information used to provide filtering, grouping, and labeling (slicing and dicing) of measures c) One of three coordinates determining a position in space or four coordinates determining a position in space and time d) Only a) and b)