FREE Data Engineering on Microsoft Azure: Design & Implement Data Storage Questions and Answers

Question 1

You have been given the task of creating an enterprise data lake on Azure and carrying out big data analytics while working for a cloud company.
Which Azure service from the list below would you choose in this situation?

Accepted Answer

Azure Blobs

Answer

Azure Disks

Answer

Azure Files

Answer

Azure Queues

Question 2

In Azure Data Explorer, you have established an external table with the name ExtTable. The KQL (Kusto Query Language) query must now be executed on this external table by a database user. Which of the subsequent functions ought he to use to make a reference to this table?

Accepted Answer

external_table()

Answer

access_table()

Answer

Only the table administrator can query the table

Answer

refer_table()

Question 3

Your current project is a Columnstore table. Even though columnstore tables and indexes are always saved using columnstore compression, you want to further reduce the size of the columnstore data. You choose to configure archival compression, an add-on compression, for this reason. Which of the following techniques would you employ in order to archive compression on the data?

Accepted Answer

COLUMNSTORE_ARCHIVE

Answer

COLUMNSTORE_COMPRESS

Answer

COLUMNSTORE_ARCHIVECOMPRESS

Answer

COLUMNSTORE

Question 4

You are setting up a storage account for Azure Data Lake Gen2. The availability of data must be guaranteed for both write and read activities, even if a whole data center (zonal or non-zonal) goes down. Which replication technique would you apply to the storage account? (Select the least expensive solution)

Accepted Answer

Zone-redundant storage (ZRS)

Answer

Geo-zone-redundant storage (GZRS)

Answer

Geo-redundant storage (GRS)

Answer

Locally-redundant storage (LRS)

Question 5

With Azure Data Lake Store Gen1, you are engaged. You now realize how important it is to understand the external data's schema. Which plug-in from the list below would you use to learn the external data schema?

Accepted Answer

infer_storage_schema

Answer

mysql_request

Answer

Pivot

Answer

Narrow

Question 6

In SQL Server Analysis Services, data semantic models must be created. One should adhere to a few best practices for data modeling that are advised. Which of the following procedures would you believe to be the ideal procedures to follow when developing data semantic models?

Accepted Answer

All of the above

Answer

Create a dimension model snowflake or/and star, even if you need to ingest data from various sources.

Answer

Only include the integer surrogate keys or value encoding in the model and exclude all the natural keys from the dimension tables.

Answer

Decrease cardinality to reduce the uniqueness of the values and allow much better compression.

Question 7

A history table is automatically created in the same database when you establish a temporal table in Azure SQL Database in order to store the historical records. Which of the following claims regarding the history table and temporal table is accurate?

Accepted Answer

All of the above

Answer

A temporal table must have 1 primary key.

Answer

To create a temporal table, System Versioning needs to be set to On.

Answer

If you don't specify the name for the history table, the default naming convention is used for the history table.