SQL Server Advanced Data Warehousing: Expert-Level Quiz

Which of the following transformations would you use to extract the maximum number of posts made about a person from a social media archive?

Fill in the missing code to create a data warehouse ETL process using SSIS:

CREATE PACKAGE ___;

Complete the script to create an indexed view:

CREATE VIEW vw_SalesSummary
____________
AS
SELECT SaleDate, SUM(Amount) AS TotalSales
FROM dbo.Sales
GROUP BY SaleDate;

One of the following is not a primary function performed by OLAP.

Which SQL Server feature allows you to create a data warehouse ETL process?

Which of the following statements is correct?

Which of the following is not a type od SCD?

Fill in the missing code to create a partitioned table:

CREATE TABLE Sales (
    SaleID INT,
    SaleDate DATE,
    Amount DECIMAL(10, 2)
) ON ___ (SaleDate);

There is a Microsoft SQL server equipped with Data Quality Services (DQS); your task is to evaluate the data's completeness and uniqueness within the matching policy. To accomplish this, you decide to establish a matching rule. Would this approach achieve the intended objective?

Partitioning is done for many reasons, such as assisting backup recovery, enhancing performance, and easy management.

Which of the following stores information about how the management data warehouse reports should group and aggregate performance counters?

Complete the script to create a clustered columnstore index:

CREATE ____________ CCI_Sales
ON Sales;

Which of the following is the right sequence of jobs to load data into warehouse?

What is data scrubbing?

When considering the task of importing country data from a flat file into SQL Server and Oracle databases, which transformation would be employed?

Fill in the missing code to create a data warehouse schema:

CREATE SCHEMA ___;

You are tasked with configuring the Similarity of Similar percentage that defines a match in a matching policy containing one matching rule. In what similarity percentage will a similarity score of 0 always be generated?

Which SQL Server feature allows you to create a read-only replica of a database?

The major difference between non-addictive facts and conformed facts is that conformed facts cannot sum up any of the dimensions in the fact table. Whereas, a non-additive fact is a table across multiple data marts and fact tables.

What describes dimension tables?