Assessment Modules:
Module 1
Introduction to Business Intelligence and Data Modeling
1
To improve the usability and performance of an Organizations in order to gain insights that can benefit the business , _____________ and _____________ can be used.
2
____________________ 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.
3
What are the characteristic of Power BI?
Back To Top
Module 2
Creating Multidimensional Databases
1
What does OLTP stands for in data base systems?
2
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.
3
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
1
An instance of database dimension within a cube called as?
2
In Dimension what does each layer known as?
3
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
1
What are the three types of additivity of the measures in aggregated function ? (Chose Three)
2
Additivity measure also known as?
3
What type of additive function is “FirstChild”?
Back To Top
Module 5
Introduction to MDX
1
An MDX query that returns a single value is called an MDX _______________?
2
An MDX query that returns a large set of data like cube is called an MDX ________________ ?
3
In MDX what is the property of Set?
Back To Top
Module 6
Customizing Cube Functionality
1
Which below property is a part of KPI.
2
What could be the output statement of below expression
Case
When [Product].[Category].CurrentMember Is
[Product].[Category].[Accessories]
Then .60
Else .30
End
3
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
1
Which of the following statement is true for ragged hierarchies?
2
Select the below statement which is not true
3
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)
1
Which of the following operator is used for “Not Equal” in DAX?
2
Which of the following logical operator is used for “AND” in DAX?
3
Which below Syntax is correct for DAX LOOKUPVALUE
Back To Top
Module 9
Performing Predictive Analysis with Data Mining
1
To test which algorithm is most accurate when you analyze data using different algorithms ?
2
What statement/s does Data Definition Language include?
3
What are the tools used for Data Mining?
Back To Top
Practice Exam - Developing SQL Data Models
Self-Paced
Learning Style
Practice Exam
Learning Style
Beginner
Difficulty
1 Hour
Course Duration
Course Info
Certificate
{{startDate}}
9:00 AM - 5:00 PM CST
Duration - 0 Days -
You have already taken demo for this course.
If you want to get access to demo again, feel free to contact our support at (855) 800-8240
Outline
More Information
| Lab Access | No |
|---|---|
| Learning Style | Self-Paced Learning |
| Learning Type | Practice Exam |
| Difficulty | Beginner |
| Course Duration | 1 Hour |
| Language | English |
Reviews
Write Your Own Review
