Module 1
Introduction to Business Intelligence and Data Modeling
To improve the usability and performance of an Organizations in order to gain insights that can benefit the business , _____________ and _____________ can be used.
____________________ is the process of extracting data from data sources, applying transformations to convert the data into the required format, and then loading it into a data store such as a data warehouse.
What are the characteristic of Power BI?
Back To Top
Module 2
Creating Multidimensional Databases
What does OLTP stands for in data base systems?
In a multidimensional database, you create a structure called ____________ to store measures, which are discrete, aggregated, numerical values, such as sales revenue totals or manufacturing costs.
You can use ____________ to drill down through different layers of data by using a hierarchy.
Back To Top
Module 3
Working with Cubes and Dimensions
An instance of database dimension within a cube called as?
In Dimension what does each layer known as?
To improve usability in Analysis Services, attribute members can be formed into member groups through a process called _______________?
Back To Top
Module 4
Working with Measures and Measure Groups
What are the three types of additivity of the measures in aggregated function ? (Chose Three)
Additivity measure also known as?
What type of additive function is “FirstChild”?
Back To Top
Module 5
Introduction to MDX
An MDX query that returns a single value is called an MDX _______________?
An MDX query that returns a large set of data like cube is called an MDX ________________ ?
In MDX what is the property of Set?
Back To Top
Module 6
Customizing Cube Functionality
Which below property is a part of KPI.
What could be the output statement of below expression
Case
When [Product].[Category].CurrentMember Is
[Product].[Category].[Accessories]
Then .60
Else .30
End
What could be the output statement of below expression
Case
When KpiValue( "Gross Profit Margin" ) /
KpiGoal ( "Gross Profit Margin" ) >= 1
Then 1
When KpiValue( "Gross Profit Margin" ) /
KpiGoal ( "Gross Profit Margin" ) < 0.5
Then -1
Else 0
End
Back To Top
Module 7
Implementing a Tabular Data Model by Using SQL Server Analysis Services
Which of the following statement is true for ragged hierarchies?
Select the below statement which is not true
The window that displays status information that relates to builds and deployments Is known as?
Back To Top
Module 8
Introduction to Data Analysis Expressions (DAX)
Which of the following operator is used for “Not Equal” in DAX?
Which of the following logical operator is used for “AND” in DAX?
Which below Syntax is correct for DAX LOOKUPVALUE
Back To Top
Module 9
Performing Predictive Analysis with Data Mining
To test which algorithm is most accurate when you analyze data using different algorithms ?
What statement/s does Data Definition Language include?
What are the tools used for Data Mining?
Back To Top
Practice Exam - Developing SQL Data Models
More Information:
- Learning Style: On Demand
- Learning Style: Practice Exam
- Difficulty: Beginner
- Course Duration: 1 Hour
- Course Info: Download PDF
- Certificate: See Sample
Need Training for 5 or More People?
Customized to your team's need:
- Annual Subscriptions
- Private Training
- Flexible Pricing
- Enterprise LMS
- Dedicated Customer Success Manager
Course Information