Individuals

Learn how you can get certified, advance your career, and get promoted with our self-paced subscription of over 900 self-paced courses.

Learn More

Certification Exam Prep Questions For
Developing SQL Data Models (MS-20768)

Name: Practice Exam - Developing SQL Data Models
SKU: Practice Exam - Developing SQL Data Models
Price: 109 USD
Availability: InStock

QuickStart is now offering you assessment questions for Developing SQL Data Models (MS-20768). Whether you are deciding which exam to sign up for, or simply want to practice the materials necessary to complete certification for this course, we have provided a practice assessment to better aid in certification. 100% of the questions are real questions from a recent version of the test you will take for Developing SQL Data Models (MS-20768).

Assessment Modules:

1. Introduction to Business Intelligence and Data Modeling

2. Creating Multidimensional Databases

3. Working with Cubes and Dimensions

4. Working with Measures and Measure Groups

5. Introduction to MDX

6. Customizing Cube Functionality

7. Implementing a Tabular Data Model by Using SQL Server Analysis Services

8. Introduction to Data Analysis Expressions (DAX)

9. Performing Predictive Analysis with Data Mining

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.

A. Business Intelligence and Data Storage: Incorrect.

B. Data Modeling and Business Intelligence: Correct!

C. Data Storage and Business Intelligences: Incorrect.

D. Business Intelligence and Data Duplication: Incorrect.

____________________ 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.

A. Data Mining: Incorrect.

B. Data Filtering: Incorrect.

C. Transformation: Incorrect.

D. ETL: Correct!

What are the characteristic of Power BI?

A. Using Power BI you can create reports only: Incorrect.

B. Using Power BI you can transform data of your reports only: Incorrect.

C. Using Power you can import data, transform data, create reports, Publish reports but cannot Create Dashboard: Incorrect.

D. Using Power you can import data, transform data, create reports, Publish reports and Creates Dashboard: Correct!

Module 2

Creating Multidimensional Databases

What does OLTP stands for in data base systems?

A. Online Transformation Processing: Incorrect.

B. Online Transaction Processing: Correct!

C. Online Transfer Process: Correct!

D. Online Transformation Process: Incorrect.

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.

A. Dimensions: Incorrect.

B. Cubes: Correct!

C. Slicing: Incorrect.

D. Dicing: Incorrect.

You can use ____________ to drill down through different layers of data by using a hierarchy.

A. Dimensions: Correct!

B. Cubes: Incorrect.

C. Slicing: Incorrect.

D. Dicing: Incorrect.

Module 3

Working with Cubes and Dimensions

An instance of database dimension within a cube called as?

A. Dimension over cube: Incorrect.

B. Cube in dimension: Incorrect.

C. Cube Dimension: Correct!

D. Dimension: Incorrect.

In Dimension what does each layer known as?

A. Stage: Incorrect.

B. Rows: Incorrect.

C. Vertical Plane: Incorrect.

D. Level: Correct!

To improve usability in Analysis Services, attribute members can be formed into member groups through a process called _______________?

A. Data Mining: Incorrect.

B. Discretization: Correct!

C. ETL: Incorrect.

D. Grouping: Incorrect.

Module 4

Working with Measures and Measure Groups

What are the three types of additivity of the measures in aggregated function ? (Chose Three)

A. Additive measure: Correct!

B. Complete Additive measure: Incorrect.

C. Semi Additive measure: Correct!

D. Less Additive measure: Incorrect.

Additivity measure also known as?

A. Fully Additive measure: Incorrect.

B. Semi Additive measure: Correct!

C. Less Additive measure: Incorrect.

D. None of the above: Incorrect.

What type of additive function is “FirstChild”?

A. Fully Additive function: Correct!

B. Non-Additive function: Incorrect.

C. Semi-Additive function: Incorrect.

D. None of the above: Incorrect.

Module 5

Introduction to MDX

An MDX query that returns a single value is called an MDX _______________?

A. Expression: Correct!

B. Statement: Incorrect.

C. Equation: Incorrect.

D. One: Incorrect.

An MDX query that returns a large set of data like cube is called an MDX ________________ ?

A. Many: Incorrect.

B. Expression: Incorrect.

C. Statement: Correct!

D. Equation: Incorrect.

In MDX what is the property of Set?

A. It uniquely identifies a slice of data from a cube.: Correct!

B. It uniquely identifies the whole data from a cube not by slice: Incorrect.

C. Select only the common values form a cube: Incorrect.

D. Select the values from the cube that are not common: Incorrect.

Module 6

Customizing Cube Functionality

Which below property is a part of KPI.

A. Value: Incorrect.

B. Goal: Incorrect.

C. Trend: Incorrect.

D. All of the above: Correct!

What could be the output statement of below expression
Case
When [Product].[Category].CurrentMember Is
[Product].[Category].[Accessories]
Then .60
Else .30
End

A. Margin goal of 30 percent for accessories, and 60 percent for all other categories.: Incorrect.

B. Margin goal of 60 percent for accessories, and 30 percent for all other categories: Correct!

C. Margin goal of 90 percent for accessories, and 10 percent for all other categories: Incorrect.

D. Margin goal of 10 percent for accessories, and 90 percent for all other categories: Incorrect.

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