You are provisioning an Azure SQL database in the Azure portal as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview

Comment: *

Name: *

Email: *

Verification: *

You have the following Transact-SQL query.

Which column returned by the query represents the free space in each file?

• A.ColumnA
• B.ColumnB
• C.ColumnC
• D.ColumnD

Comment: *

Name: *

Email: *

Verification: *

You have the following Azure Data Factory pipelines:
* Ingest Data from System1
* Ingest Data from System2
* Populate Dimensions
* Populate Facts
Ingest Data from System1 and Ingest Data from System2 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2. Populate Facts must execute after the Populate Dimensions pipeline. All the pipelines must execute every eight hours.
What should you do to schedule the pipelines for execution?

• A.Add a schedule trigger to all four pipelines.
• B.Add an event trigger to all four pipelines.
• C.Create a parent pipeline that contains the four pipelines and use an event trigger.
• D.Create a parent pipeline that contains the four pipelines and use a schedule trigger.

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL database named DB1. DB1 contains a table that has a column named Col1.
You need to encrypt the data in Col1.
Which four actions should you perform for DB1 in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

1 - Create a database master key.
2 - Create a certificate.
3 - Create a symmetric key.
4 - Open the symmetric key.
Reference:
https://www.sqlshack.com/an-overview-of-the-column-level-sql-server-encryption/

Comment: *

Name: *

Email: *

Verification: *

You have an Azure Synapse Analytics Apache Spark pool named Pool1.
You plan to load JSON files from an Azure Data Lake Storage Gen2 container into the tables in Pool1. The structure and data types vary by file.
You need to load the files into the tables. The solution must maintain the source data types.
What should you do?

• A.Load the data by using PySpark.
• B.Load the data by using the OPENROWSETTransact-SQL command in an Azure Synapse Analytics serverless SQL pool.
• C.Use a Get Metadata activity in Azure Data Factory.
• D.Use a Conditional Split transformation in an Azure Synapse data flow.

Comment: *

Name: *

Email: *

Verification: *