Data Engineering on Microsoft Azure Test 16

A window function enables you to perform a mathematical equation on a set of data that is defined within a window. The mathematical equation is typically an aggregate function; however, instead of applying the aggregate function to all the rows in a table, it is applied to a set of rows that are defined by the window function, and then the aggregate is applied to it.
One of the key components of window functions is the [?] clause. This clause determines the partitioning and ordering of a rowset before the associated window function is applied. That is, the [?] clause defines a window or user-specified set of rows within a query result set.

Select 1 option(s):

From a high level, the Azure Databricks service launches and manages Apache Spark clusters within your Azure subscription. Apache Spark clusters are groups of computers that are treated as a single computer and handle the execution of commands issued from notebooks.
Internally, Azure Kubernetes Service (AKS) is used to … [?]

Select 1 option(s):

If you have created a data flow in which you have set parameters, it is possible to execute it from a pipeline using the Execute Data Flow Activity. Once you have added the activity to the pipeline canvas, you’ll find the data flow parameters in the activity’s Parameters tab.
Is it possible to combine the pipeline and data flow expression parameters while mapping dataflow?

Select 1 option(s):

Select 4 option(s):

Select 1 option(s):

Azure Synapse Pipelines enables you to integrate data pipelines between which of the following? (Select all that apply)

Select 3 option(s):

Review the following architecture designs.
Design A:

Design B:

Design C:

Which design would be best suited for the need?

Select 1 option(s):

Which of the following are primary languages available within the notebook environment? (Select four)

Select 4 option(s):

Which of the below is the correct response?

Select 1 option(s):

Select 1 option(s):

[?] is a cloud-integration service which orchestrates the movement of data between various data stores. [?] processes and transforms data by using compute services such as Azure HDInsight, Hadoop, Spark, and Azure Machine Learning. Publish output data to data stores such as Azure SQL Data Warehouse so that business intelligence applications can consume the data.

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Azure Databricks has which the following compliance certifications?

Select 6 option(s):

Select 1 option(s):

Select 1 option(s):

Which tool should you choose?

Select 1 option(s):

Select 1 option(s):

Azure Databricks is a fully-managed, cloud-based Big Data and Machine Learning platform, which empowers developers to accelerate AI and innovation by simplifying the process of building enterprise-grade production data applications. Built as a joint effort by Databricks and Microsoft, Azure Databricks provides data science and engineering teams with a single platform for Big Data processing and Machine Learning.
By combining the power of Databricks, an end-to-end, managed Apache Spark platform optimized for the cloud, with the enterprise scale and security of Microsoft’s Azure platform, Azure Databricks makes it simple to run large-scale Spark workloads.
Internally, [?] is used to run the Azure Databricks control-plane and data-planes via containers running on the latest generation of Azure hardware (Dv3 VMs), with NvMe SSDs capable of blazing 100us latency on IO.

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

True or False: You cannot disable the Synapse Link feature once it is enabled on the account.

Select 1 option(s):

Which of the below describes a good strategy for doing this?

Select 1 option(s):

Required: An assessment of databases must be done in order to determine whether or not data will move without compatibility issues.
The Avengers IT team has many different tools at their disposal and it is your responsibility to advise them on which tool to use. Which of the following is the best for the application?

Select 1 option(s):

Select 1 option(s):

True or False: The list of pipeline and activity runs is auto refreshed every 60 seconds.
To view the results of a debug run, select the Debug tab.


Select 1 option(s):

Azure Storage provides a REST API to work with the containers and data stored in each account. The simplest way to handle access keys and endpoint URLs within applications is to use [?].

Select 1 option(s):