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
This Subscription Includes:
 Virtual Classroom CoursesOur virtual instructor-led courses give you access to live instructors training you with other live students in a virtual classroom environment. < Play Video > |
 Online Self-Paced CoursesTake self-paced online courses at your convenience and own pace, with unlimited access to courses in various emerging technologies. |
 E-books blogs, case studies, articlesAs part of informal learning, our platform will recommend E-books, whitepapers, case studies, articles, and videos. This is AI curated content closely aligned with your learning objectives. |
 Self-AssessmentsSet yourself on the right path with self-assessments that allow you to gauge what you already know. Assessments then personalize your learning paths, and allow you to focus only on what you need to succeed. |
 Full Learning Dashboard & AnalyticsAccess all your enrolled, completed, course statistics, and community discussions from one centralized and intuitive learning dashboard with built in analytics, course tracking, time spent, and more. |
 QuickStart DiscussionsEngage with other learners where you can directly chat, ask questions, and socialize with other learners experts and instructors on a course subject. |
 Virtual LabsVideos and lectures only go so far. Get real world, hands-on practice with virtual labs (not available for all courses). |
 Live Instructor Mentoring & SupportGet your IT problems solved through a community of mentors, experts and peers. Get live help from experts to answer questions on course material or guidance on a project. |
 Career PathsStart a learning pathway towards understanding and mastering your career. With QuickStart career paths, you can fully understanding and being the best in your field. |
 Informal LearningAccess to AI curated content from various content publishers which can help in self-directed learning. |
