9. You need to store the results of a query in a serverless SQL pool as files in a data lake. Which SQL statement should you use?

CREATE EXTERNAL TABLE AS SELECT

11. You drop an existing external table from a database in a serverless SQL pool. What else must you do before recreating an external table with the same location?

Delete the folder containing the data files for dropped table.

Drop and recreate the database.

12. Which of the following statements is true of a lake database?

A relational schema is overlaid on the underlying files, and can be queried using a serverless SQL pool or a Spark pool.

Data is stored in a relational database store and cannot be directly accessed in the data lake files.

Data is stored in files that cannot be queried using SQL.

13. You need to create a new lake database for a retail solution. What's the most efficient way to do this?

Start with the Retail database template in Azure Synapse Studio, and adapt it as necessary.

Create a sample database in Azure SQL Database and export the SQL scripts to create the schema for the lake database.

Start with an empty database and create a normalized schema.

14. You have Parquet files in an existing data lake folder for which you want to create a table in a lake database. What should you do?

Use the database designer to create a table based on the existing folder.

Use a CREATE EXTERNAL TABLE AS SELECT (CETAS) query to create the table.

Convert the files in the folder to CSV format.

15. Which definition best describes Apache Spark?

A distributed platform for parallel data processing using multiple languages.

A highly scalable relational database management system.

A virtual server with a Python runtime.

16. You need to use Spark to analyze data in a parquet file. What should you do?

Load the parquet file into a dataframe.

Import the data into a table in a serverless SQL pool.

Convert the data to CSV format.

20. What happens if you drop an external table that is based on existing files?

The table is dropped from the metastore but the files remain unaffected

An error – you must delete the files first

The table is dropped from the metastore and the files are deleted

21. Which of the following descriptions best fits Delta Lake?

A relational storage layer for Spark that supports tables based on Parquet files.

A Spark API for exporting data from a relational database into CSV files.

A synchronization solution that replicates data between SQL pools and Spark pools.

24. You have a managed catalog table that contains Delta Lake data. If you drop the table, what will happen?

The table metadata and data files will be deleted.

The table metadata will be removed from the catalog, but the data files will remain intact.

The table metadata will remain in the catalog, but the data files will be deleted.

29. You need to write a query to return the total of the UnitsProduced numeric measure in the FactProduction table aggregated by the ProductName attribute in the FactProduct table. Both tables include a ProductKey surrogate key field. What should you do?

Use a SELECT query with a SUM function to total the UnitsProduced metric, using a JOIN on the ProductKey surrogate key to match the FactProduction records to the FactProduct records and a GROUP BY clause to aggregate by ProductName.

Use two SELECT queries with a UNION ALL clause to combine the rows in the FactProduction table with those in the FactProduct table.

Use a SELECT query against the FactProduction table with a WHERE clause to filter out rows with a ProductKey that doesn't exist in the FactProduct table.

32. In which order should you load tables in the data warehouse?

Staging tables, then dimension tables, then fact tables

Staging tables, then fact tables, then dimension tables

Dimension tables, then staging tables, then fact tables

40. A notebook cell contains variable declarations. How can you use them as parameters?

Toggle the Parameters cell setting for the cell

Add a %%Spark magic at the beginning of the cell

Use the var keyword for each variable declaration

DP-203 Mid-Assessment

Professional Development

•

40 Qs

Similar activities

AWS Cloud Practitioner

University - Professional Development

•

41 Qs

Aparato locomotor

Professional Development

•

44 Qs

Modul A2 PABD Melawai

Professional Development

•

40 Qs

Đề 2 - 21017 - 28/03/2021

Professional Development

•

40 Qs

Baroda Academy, Rajkot _2022-23_PPT QUIZ for CL to Officer Day-1

Professional Development

•

40 Qs

TRẮC NGHIỆM-AN KHANG HẠNH PHÚC

Professional Development

•

40 Qs

ITIL 4-8

Professional Development

•

40 Qs

Đề 3 0 20853 032021

Professional Development

•

40 Qs

DP-203 Mid-Assessment

Quiz

•

Professional Development

•

Professional Development

•

Practice Problem

•

Medium

Managobinda Sethi

Used 3+ times

FREE Resource

OPENROWSET

ROWSET

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

7. What character in file path can be used to select all the file/folders that match rest of the path?

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

38 questions

auto tools

Quiz

•

Professional Development

40 questions

Đề 4 - 20853 032021

Quiz

•

Professional Development

45 questions

Davinci Resolve 17 Fusion 101

Quiz

•

11th Grade - Professi...

35 questions

GCS AVENGER

Quiz

•

Professional Development

40 questions

Profesional BK 5

Quiz

•

Professional Development

40 questions

Dasar - Dasar Kelistrikan

Quiz

•

Professional Development

40 questions

Đề MIT 20643.4 (7/3/21)

Quiz

•

Professional Development

Popular Resources on Wayground

25 questions

Multiplication Facts

Quiz

•

5th Grade

15 questions

4:3 Model Multiplication of Decimals by Whole Numbers

Quiz

•

5th Grade

10 questions

The Best Christmas Pageant Ever Chapters 1 & 2

Quiz

•

4th Grade

12 questions

Unit 4 Review Day

Quiz

•

3rd Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

14 questions

Christmas Trivia

Quiz

•

5th Grade

15 questions

Solving Equations with Variables on Both Sides Review

Quiz

•

8th Grade

Discover more resources for Professional Development

20 questions

Customer Service

Quiz

•

Professional Development

20 questions

NCCER Power Tools Quiz

Quiz

•

Professional Development

DP-203 Mid-Assessment

40 questions

1. Azure Data Lake Storage Gen2 stores data in…

2. What option must you enable to use Azure Data Lake Storage Gen2?

3. Which feature of Azure Synapse Analytics enables you to transfer data from one store to another and apply transformations to the data at scheduled intervals?

4. You want to create a data warehouse in Azure Synapse Analytics in which the data is stored and queried in a relational data store. What kind of pool should you create?

5. A data analyst wants to analyze data by using Python code combined with text descriptions of the insights gained from the analysis. What should they use to perform the analysis?

6. What function is used to read the data in files stored in a data lake?

7. What character in file path can be used to select all the file/folders that match rest of the path?

8. Which external database object encapsulates the connection information to a file location in a data lake store?

9. You need to store the results of a query in a serverless SQL pool as files in a data lake. Which SQL statement should you use?

10. Which of the following file formats can you use to persist the results of a query?

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Professional Development