Assessment Modules:
Module 1
Introduction to Data Warehousing
1
What are the components of Data Warehousing Solution?
2
Column-based index has the following property.
3
Row-based index has the following property
Back To Top
Module 2
Planning Data Warehouse Infrastructure
1
How much Data Volume is required for a Small BI System?
2
How much Data Volume is required for a Medium BI System?
3
What is the specific formula for applying cores in a system?
Back To Top
Module 3
Designing and Implementing a Data Warehouse
1
What properties are true regarding snowflake schema?
2
In dimension table the business key is retained as?
3
Which of the following statement is true for tempdb?
Back To Top
Module 4
Columnstore Indexes
1
Columnstore indexes can...
2
Which of the following is NOT the characteristic of Clustered Columnstore indexes
3
What does this statement do “sys.dm_db_index_physical_stats”?
Back To Top
Module 5
Implementing an Azure SQL Data Warehouse
1
) What is the key characteristic of PolyBase?
2
Hash distribution is a part of?
3
) What are the data types that are NOT supported in Azure SQL Data Warehouse?
Back To Top
Module 6
Creating an ETL Solution
1
_______ is the primary ETL tool for SQL Server.
2
In which deployment model multiple packages are deployed in a single project?
3
In which deployment model SSIS packages are deployed and managed individually?
Back To Top
Module 7
Implementing Control Flow in an SSIS Package
1
In Control Flow task, what WMI stands for?
2
In Database Tasks, what CDC stands for?
3
Following is NOT the part of System Variable?
Back To Top
Module 8
Debugging and Troubleshooting SSIS Packages
1
“dtutil” helps to ..
2
Mark the following events that are the part of SSIS logging supports?
3
In Log Schema mark the appropriate integer value with respect to its execution result of the following DataCode?
Back To Top
Module 9
Implementing a Data Extraction Solution
1
Which statement is true for Single-Stage ETL?
2
Which statement is true for Two-Stage ETL?
3
Which statement is true for Three-Stage ETL?
Back To Top
Module 10
Enforcing Data Quality
1
In SQL what does DQS stands for?
2
Which statement is true for DQS
3
What does Data Cleansing do?
Back To Top
Module 11
Master Data Services
1
What statements are true for Master Data Services?
2
What statements are true for Data Quality Services?
3
What are the components of Master Data Services?
Back To Top
Module 12
Extending SQL Server Integration Services
1
What following settings can be configured using Script Task Editor?
2
What are the custom components through which you can extend SSIS?
3
Which statement is true regarding ScriptLanguage?
Back To Top
Module 13
Deploying and Configuring SSIS Packages
1
Which following statement is NOT true regarding SSIS catalogue?
2
If a package is being executed with “dtexec”, which means?
3
Which statement is true regarding Dtexecui.
Back To Top
Module 14
Consuming Data in a Data Warehouse
1
Data _________ improves decision making by revealing patterns in data.
2
What does Self-Service Reporting means?
3
ROLAP Stands for?
Back To Top
Practice Exam - Implementing a Microsoft SQL 2016 Data Warehouse
$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
