Pertemuan 7 - Azure Data Engineer

You plan to create an Azure Databricks workspace and use the SQL persona view in the Azure Databricks portal. Which of the following pricing tiers can you select?

• Enterprise

• Standard

• Premium

You need to use Spark to process data in files, preparing it for analysis. Which persona view should you use in the Azure Databricks portal?

• Data Science and Engineering

• Machine Learning

• SQL

You've created an Azure Databricks workspace in which you plan to use code in notebooks to process data. What must you create in the workspace?

• A SQL Warehouse

• A Spark cluster

• A Windows Server virtual machine

Which definition best describes Apache Spark?

• A highly scalable relational database management system.

• A virtual server with a Python runtime.

• A distributed platform for parallel data processing using multiple languages.

What feature of Delta Lake enables you to retrieve data from previous versions of a table?

• Spark Structured Streaming

• Time Travel

• Catalog Tables

Which of the following workloads is best suited for Azure Databricks SQL?

• Running Scala code in notebooks to transform data

• Querying and visualizing data in relational tables

• Training and deploying machine learning models

Which statement should you use to create a database in a SQL warehouse?

• CREATE VIEW

• CREATE SCHEMA

• CREATE GROUP

You need to share data visualizations, including charts and tables of data, with users in your organization. What should you create?

• A table

• A query

• A dashboard

You want to connect to an Azure Databricks workspace from Azure Data Factory. What must you define in Azure Data Factory?

• A global parameter

• A linked service

• A customer managed key

You need to run a notebook in the Azure Databricks workspace referenced by a linked service. What type of activity should you add to a pipeline?

• Notebook

• Python

• Jar