Data Engineering on Microsoft Azure

• #181Choose 2

  You have several Azure Data Factory pipelines that contain a mix of the following types of activities. Wrangling data flow. Notebook. Copy jar. Which two Azure services should you use to debug the activities?

  • AAzure HDInsight.
  • BAzure Databricks.
  • CAzure Machine Learning.
  • DAzure Data Factory.
  • EAzure Synapse Analytics.
  Show answer
• #182

  You are designing an Azure Synapse Analytics dedicated SQL pool. You need to ensure that you can audit access to Personally Identifiable information (PII). What should you include in the solution?

  • ADynamic data masking.
  • BRow-level security (RLS).
  • CSensitivity classifications.
  • DColumn-level security.
  Show answer
• #183

  You plan to create a dimension table in Azure Synapse Analytics that will be less than 1 GB. You need to create the table to meet the following requirements: Provide the fastest Query time. Minimize data movement during queries. Which type of table should you use?

  • Ahash distributed.
  • Bheap.
  • Creplicated.
  • Dround-robin.
  Show answer
• #184

  You have an enterprise data warehouse in Azure Synapse Analytics. Using PolyBase, you create an external table named [Ext].[Items] to query Parquet files stored in Azure Data Lake Storage Gen2 without importing the data to the data warehouse. The external table has three columns. You discover that the Parquet files have a fourth column named ItemID. Which command should you run to add the ItemID column to the external table?

  • AOption A.
  • BOption B.
  • COption C.
  • DOption D.
  Show answer
• #185

  A company purchases IoT devices to monitor manufacturing machinery. The company uses an IoT appliance to communicate with the IoT devices. The company must be able to monitor the devices in real-time. You need to design the solution. What should you recommend?

  • AAzure Stream Analytics cloud job using Azure PowerShell.
  • BAzure Analysis Services using Azure Portal.
  • CAzure Data Factory instance using Azure Portal.
  • DAzure Analysis Services using Azure PowerShell.
  Show answer
• #186

  You have an Azure subscription that contains an Azure Databricks workspace named databricks1 and an Azure Synapse Analytics workspace named synapse1. The synapse1 workspace contains an Apache Spark pool named pool1. You need to share an Apache Hive catalog of pool1 with databricks1. What should you do?

  • AFrom synapse1, create a linked service to: Azure Cosmos DB. Configure pool1 to use the linked service as: A Hive metastore.
  • BFrom synapse1, create a linked service to: Azure SQL Database. Configure pool1 to use the linked service as: A Hive metastore.
  • CFrom synapse1, create a linked service to: Azure Data Lake Storage Gen2. Configure pool1 to use the linked service as: An Azure Purview account.
  • DFrom synapse1, create a linked service to: Azure SQL Database. Configure pool1 to use the linked service as: A managed Hive metastore service.
  Show answer
• #187

  You have an Azure Synapse Analytics serverless SQL pool. You have an Azure Data Lake Storage account named adls1 that contains a public container named container1. The container1 container contains a folder named folder1. You need to query the top 100 rows of all the CSV files in folder1. How should you complete the query?

  • ABox 1: OPENROWSET. Box 2: BULK.
  • BBox 1: BULK. Box 2: DATA_SOURCE.
  • CBox 1: LOCATION. Box 2: OPERNROWSET.
  • DBox 1: LOCATION. Box 2: BULK.
  Show answer
• #188

  You have an Azure subscription that is linked to a hybrid Azure Active Directory (Azure AD) tenant. The subscription contains an Azure Synapse Analytics SQL pool named Pool1. You need to recommend an authentication solution for Pool1. The solution must support multi-factor authentication (MFA) and database-level authentication. Which authentication solution or solutions should you include in the recommendation?

  • AMFA: Microsoft SQL Server authentication. Database-level authentication: Application roles.
  • BMFA: Passwordless authentication. Database-level authentication: Contained database users.
  • CMFA: Windows authentication. Database-level authentication: Microsoft SQL Server logins.
  • DMFA: Azure AD authentication. Database-level authentication: Contained database users.
  Show answer
• #189

  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 SQL. 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?

  • AYes.
  • BNo.
  Show answer
• #190

  You are designing an Azure Synapse solution that will provide a query interface for the data stored in an Azure Storage account. The storage account is only accessible from a virtual network. You need to recommend an authentication mechanism to ensure that the solution can access the source data. What should you recommend?

  • Aa managed identity.
  • Banonymous public read access.
  • Ca shared key.
  Show answer
• #191

  You have an Azure Synapse Analytics serverless SQL pool, an Azure Synapse Analytics dedicated SQL pool, an Apache Spark pool, and an Azure Data Lake Storage Gen2 account. You need to create a table in a lake database. The table must be available to both the serverless SQL pool and the Spark pool. Where should you create the table, and Which file format should you use for data in the table?

  • ACreate the table in: The dedicated SQL pool. File format: Delta.
  • BCreate the table in: The serverless SQL pool. File format: JSON.
  • CCreate the table in: The dedicated SQL pool. File format: Apache Parquet.
  • DCreate the table in: The Spark pool. File format: JSON.
  Show answer
• #192

  You are designing a fact table named FactPurchase in an Azure Synapse Analytics dedicated SQL pool. The table contains purchases from suppliers for a retail store. FactPurchase will contain the following columns.FactPurchase will have 1 million rows of data added daily and will contain three years of data. Transact-SQL queries similar to the following query will be executed daily.SELECT - SupplierKey, StockItemKey, IsOrderFinalized, COUNT()FROM FactPurchase - WHERE DateKey >= 20210101 - AND DateKey <= 20210131 - GROUP By SupplierKey, StockItemKey, IsOrderFinalized Which table distribution will minimize query times?

  • Areplicated.
  • Bhash-distributed on PurchaseKey.
  • Cround-robin.
  • Dhash-distributed on IsOrderFinalized.
  Show answer
• #193

  You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements.

  • ATable that has an IDENTITY property.
  • BSystem-versioned temporal table.
  • CUser-defined SEQUENCE object.
  • DTable that has a FOREIGN KEY constraint.
  Show answer
• #194

  You use Azure Data Lake Storage Gen2 to store data that data scientists and data engineers will query by using Azure Databricks interactive notebooks. Users will have access only to the Data Lake Storage folders that relate to the projects on which they work. You need to recommend which authentication methods to use for Databricks and Data Lake Storage to provide the users with the appropriate access. The solution must minimize administrative effort and development effort. Which authentication method should you recommend for each Azure service?

  • ADatabricks: Azure Key Vault secrets. Data Lake Storage: Azure Active Directory credential passthrough.
  • BDatabricks: Personal access tokens. Data Lake Storage: Azure Active Directory credential passthrough.
  • CDatabricks: Personal access tokens. Data Lake Storage: Shared access keys.
  • DDatabricks: Personal access tokens. Data Lake Storage: Shared access signatures.
  Show answer
• #195

  You need to build a solution to ensure that users can query specific files in an Azure Data Lake Storage Gen2 account from an Azure Synapse Analytics serverless SQL pool. Which three actions should you perform in sequence?

  • ABox 1: Create an external file format object. Box 2: Create an external data source. Box 3: Create a table.
  • BBox 1: Create an external table. Box 2: Create a query that uses Create as Select. Box 3: Create an external data source.
  • CBox 1: Create an external data source. Box 2: Create an external file format object. Box 3: Create an external table.
  • DBox 1: Create an external table. Box 2: Create a table. Box 3: Create a query that uses Create Table as Select.
  Show answer
• #196

  You have an Azure Synapse Analytics dedicated SQL pool that contains the users shown in the following table. User1 executes a query on the database, and the query returns the results shown in the following exhibit. User1 is the only user who has access to the unmasked data.

  • AWhen User2 queries the YearlyIncome column, the values returned will be: the values stored in the database. When User1 queries the BirthDate column, the values returned will be: a random number.
  • BWhen User2 queries the YearlyIncome column, the values returned will be: a random number. When User1 queries the BirthDate column, the values returned will be: 1900-01-01.
  • CWhen User2 queries the YearlyIncome column, the values returned will be: 0. When User1 queries the BirthDate column, the values returned will be: the values stored in the database.
  • DWhen User2 queries the YearlyIncome column, the values returned will be: XXXX. When User1 queries the BirthDate column, the values returned will be: a random number.
  Show answer
• #197

  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?

  • AUse a Get Metadata activity in Azure Data Factory.
  • BUse a Conditional Split transformation in an Azure Synapse data flow.
  • CLoad the data by using the OPEHROwset Transact-SQL command in an Azure Synapse Anarytics serverless SQL pool.
  • DLoad the data by using PySpark.
  Show answer
• #198

  You have an Azure Data Factory pipeline that is triggered hourly. The pipeline has had 100% success for the past seven days. The pipeline execution fails, and two retries that occur 15 minutes apart also fail. The third failure returns the following error. What is a possible cause of the error?

  • AThe parameter used to generate year=2021/month=01/day=10/hour=06 was incorrect.
  • BFrom 06:00 to 07:00 on January 10, 2021, there was no data in wwi/BIKES/CARBON.
  • CFrom 06:00 to 07:00 on January 10, 2021, the file format of data in wwi/BIKES/CARBON was incorrect.
  • DThe pipeline was triggered too early.
  Show answer
• #199Choose 2

  You are designing a solution that will copy Parquet files stored in an Azure Blob storage account to an Azure Data Lake Storage Gen2 account. The data will be loaded daily to the data lake and will use a folder structure of {Year}/{Month}/{Day}/. You need to design a daily Azure Data Factory data load to minimize the data transfer between the two accounts. Which two configurations should you include in the design?

  • ADelete the files in the destination before loading new data.
  • BFilter by the last modified date of the source files.
  • CDelete the source files after they are copied.
  • DSpecify a file naming pattern for the destination.
  Show answer
• #200

  You have an Azure Blob storage account that contains a folder. The folder contains 120,000 files. Each file contains 62 columns. Each day, 1,500 new files are added to the folder. You plan to incrementally load five data columns from each new file into an Azure Synapse Analytics workspace. You need to minimize how long it takes to perform the incremental loads. What should you use to store the files and format?

  • AStorage: Multiple blob storage accounts. Format: CSV.
  • BStorage: Timeslice partitioning in the folders. Format: JSON.
  • CStorage:Timeslice partitioning in the folders. Format: CSV.
  • DStorage: Timeslice partitioning in the folders. Format: Apache Parquet.
  Show answer

Want to track your score, take timed mock exams and get AI explanations? Create a free account