Questions

Question 1

Actions to perform in sequence in Stored Procedure

Answer 1

Create an empty table that has the same schema

Switch partition containing the stale data

Drop the table

Question 2

Rule of thumb regarding common distribution methods

Answer 2

Fact table - use Hash distribution with clustered columnstore index

Dimension table - use Replicated if the table is smaller. If it’s too large, use Hash.

Staging table - use Round Robin

Question 3

Users with administrative privileges are ______ excluded from masking and can see the original data

never/sometimes/always

Answer 3

Always

Question 4

Actions to perform in sequence in Databricks notebook when destination table in Azure Synapse, Azure Blob storage container, and service principle have already been created

Answer 4

Mount the Data Lake Storage on DBFS

Read the file into the data frame

Perform transformations on the data frame

Specify a temporary folder to stage the data

Write the results to a table in Azure Synapse

Question 5

Publish changes from main branch of Git repository to ADFdev. Need to deploy the artifats from ADFdev to ADFprod. What first?

Answer 5

From Azure DevOps, create a release pipeline

Question 6

When developing a solution that will have both streaming data and reference data and that will stream to Azure Stream Analytics, which input type should be used for reference data?

Answer 6

Azure Blob storage. Stream Analytics supports Blob storage and Azure SQLDatabase as the storage layer for Reference Data

Question 7

Ensure automated data loads have enough memory available to complete quickly and successfully when adhoc queries run

Answer 7

Assign a larger resource class to the automated data load queries. Increases the available memory for the node. Less parallelization as a consequence.

Question 8

Which 3 tSQL DDL commands to run in sequence to ensure that Twitter feed data can be analyzed in dedicated SQL pool?

Answer 8

CREATE EXTERNAL DATA SOURCE

CREATE EXTERNAL FILE FORMAT

CREATE EXTERNAL TABLE

Question 9

You need to implement the surrogate key for the retail store table. What should you create?

Answer 9

A table that has an IDENTITY property

Question 10

Recommended to use to secure sensitive customer contact information?

Answer 10

Column-level security. That way you can hide an entire column with sensitive data