Question 11

You have an Azure subscription.
You need to deploy an Azure Data Lake Storage Gen2 Premium account. The solution must meet the following requirements:
* Blobs that are older than 365 days must be deleted.
* Administrator efforts must be minimized.
* Costs must be minimized
What should you use? To answer, select the appropriate options in the answer are a. NOTE Each correct selection is worth one point.

Question 12

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You plan to create an Azure Databricks workspace that has a tiered structure. The workspace will contain the following three workloads:
A workload for data engineers who will use Python and SQL.
A workload for jobs that will run notebooks that use Python, Scala, and SOL.
A workload that data scientists will use to perform ad hoc analysis in Scala and R.
The enterprise architecture team at your company identifies the following standards for Databricks environments:
The data engineers must share a cluster.
The job cluster will be managed by using a request process whereby data scientists and data engineers provide packaged notebooks for deployment to the cluster.
All the data scientists must be assigned their own cluster that terminates automatically after 120 minutes of inactivity. Currently, there are three data scientists.
You need to create the Databricks clusters for the workloads.
Solution: You create a High Concurrency cluster for each data scientist, a High Concurrency cluster for the data engineers, and a Standard cluster for the jobs.
Does this meet the goal?
  • Question 13

    You are performing exploratory analysis of the bus fare data in an Azure Data Lake Storage Gen2 account by using an Azure Synapse Analytics serverless SQL pool.
    You execute the Transact-SQL query shown in the following exhibit.

    What do the query results include?
  • Question 14

    You have an Azure Synapse workspace named MyWorkspace that contains an Apache Spark database named mytestdb.
    You run the following command in an Azure Synapse Analytics Spark pool in MyWorkspace.
    CREATE TABLE mytestdb.myParquetTable(
    EmployeeID int,
    EmployeeName string,
    EmployeeStartDate date)
    USING Parquet
    You then use Spark to insert a row into mytestdb.myParquetTable. The row contains the following data.

    One minute later, you execute the following query from a serverless SQL pool in MyWorkspace.
    SELECT EmployeeID
    FROM mytestdb.dbo.myParquetTable
    WHERE name = 'Alice';
    What will be returned by the query?
  • Question 15

    You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 contains a table named table1.
    You load 5 TB of data intotable1.
    You need to ensure that columnstore compression is maximized for table1.
    Which statement should you execute?