Mon-Fri 9am to 6pm CST
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
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 -
| Buy Individually |
|---|
|
About Individual Course:
$109.00
/ Each |
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 |
Financing
Monthly Payments With Affirm
QuickStart and Affirm have teamed up to offer you financing, allowing you to pay off your purchase over time, on your own terms. Simply select Affirm in checkout, and you will need to take a few moments to fill out some information for a real-time decision. Checking your eligibility and terms won't affect your credit score. Once you are qualified, you will have the option to choose from 3, 6, 12, 18 or 26-month financing terms*, with each term clearly showing your monthly payment. No hidden fees or costs! it's that simple!
Rates are between 0-30% APR. As an example, a $700 purchase might cost $63.24/mo for 12 months at 15% APR. A down payment may be required. Subject to eligibility check and approval. Payment options depend on your purchase amount. Estimated payment excluded taxes and shipping fees. Paid interest is nonrefundable. Actual terms may vary. Payment options through Affirm are provided by these lending partners: affirm.com/lenders. Visit affirm.com/help for more info.
Reviews
Write Your Own Review
Chat