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 Blob Storage is ideal for building an enterprise data lake and performing big data analytics. It is a massively scalable and highly available object storage solution designed to store large amounts of unstructured data, such as text or binary data. This makes it perfect for raw data ingestion and processing in analytics workloads, supporting various big data frameworks.

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

In Azure Data Explorer (Kusto Query Language or KQL), to query an external table, you must explicitly reference it using the `external_table()` function. This function takes the name of the external table as an argument and allows users to query data stored in external locations like Azure Blob Storage or Azure Data Lake Storage. It's essential for interacting with data outside the native database.

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

To apply additional archival compression to a Columnstore table in SQL Server or Azure SQL Data Warehouse, you use the `COLUMNSTORE_ARCHIVE` compression option. This option provides a deeper level of compression than the default `COLUMNSTORE` compression, which is beneficial for data that is accessed less frequently but needs to be stored efficiently. It helps reduce storage costs for cold data.

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

Zone-redundant storage (ZRS) replicates data synchronously across three Azure availability zones within a single region. This ensures data availability and durability even if an entire data center (zonal) goes down, covering both write and read activities. ZRS is the least expensive option among the choices that guarantees availability across zones.

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

The `infer_storage_schema` plug-in in Azure Data Explorer (KQL) is used to automatically detect and understand the schema of external data stored in Azure Data Lake Store Gen1 (or other external storage). This plug-in helps in quickly creating external tables by suggesting column names and data types based on the data's structure. It simplifies the process of querying external data without manual schema definition.

Microsoft Azure Security Engineer Certification Practice Test

Microsoft Azure Security Engineer Certification Practice Test

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