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
$109.00
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
Outline
Reviews
Write Your Own Review
