Data Engineering on Microsoft Azure

• #21

  You have an Azure Stream Analytics job that is a Stream Analytics project solution in Microsoft Visual Studio. The job accepts data generated by IoT devices in the JSON format. You need to modify the job to accept data generated by the IoT devices in the Protobuf format. Which three actions should you perform from Visual Studio on sequence?

  • ABox 1: Add an Azure Stream Analytics Customer Deserializer Project (.NET) project to the solution. Box 2: Add .NET deserializer code for Protobuf to the custom deserializer project. Box 3: Add an Azure Stream Analytics Application project to the solution.
  • BBox 1: Add an Azure Stream Analytics Customer Deserializer Project (.NET) project to the solution. Box 2: Add .NET deserializer code for Protobuf to the custom deserializer project. Box 3: Change the event Serialization format to Protobuf in the input.json file of the job and reference the DLL.
  • CBox 1: Change the event Serialization format to Protobuf in the input.json file of the job and reference the DLL. Box 2: Add an Azure Stream Analytics Customer Deserializer Project (.NET) project to the solution. Box 3: Add .NET deserializer code for Protobuf to the custom deserializer project.
  • DBox 1: Add an Azure Stream Analytics Application project to the solution. Box 2: Change the event Serialization format to Protobuf in the input.json file of the job and reference the DLL. Box 3: Add .NET deserializer code for Protobuf to the Stream Analytics project.
  उत्तर दिखाएँ
• #22

  You have an Azure Databricks workspace that contains a Delta Lake dimension table named Tablet. Table1 is a Type 2 slowly changing dimension (SCD) table. You need to apply updates from a source table to Table1. Which Apache Spark SQL operation should you use?

  • ACREATE.
  • BUPDATE.
  • CMERGE.
  • DALTER.
  उत्तर दिखाएँ
• #23

  You are monitoring an Azure Stream Analytics job. You discover that the Backlogged Input Events metric is increasing slowly and is consistently non-zero. You need to ensure that the job can handle all the events. What should you do?

  • AChange the compatibility level of the Stream Analytics job.
  • BIncrease the number of streaming units (SUs).
  • CRemove any named consumer groups from the connection and use $default.
  • DCreate an additional output stream for the existing input stream.
  उत्तर दिखाएँ
• #24

  You have an Azure Databricks workspace named workspace! in the Standard pricing tier. Workspace! contains an all-purpose cluster named cluster. You need to reduce the time it takes for cluster 1 to start and scale up. The solution must minimize costs. What should you do first?

  • AUpgrade workspace! to the Premium pricing tier.
  • BCreate a cluster policy in workspace1.
  • CCreate a pool in workspace1.
  • DConfigure a global init script for workspace1.
  उत्तर दिखाएँ
• #25

  You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1. You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1. You plan to insert data from the files in container1 into Table1 and transform the data. Each row of data in the files will produce one row in the serving layer of Table1. You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1. Solution: You use a dedicated SQL pool to create an external table that has an additional DateTime column. Does this meet the goal?

  • AYes.
  • BNo.
  उत्तर दिखाएँ
• #26

  You plan to build a structured streaming solution in Azure Databricks. The solution will count new events in five-minute intervals and report only events that arrive during the interval. The output will be sent to a Delta Lake table. Which output mode should you use?

  • Acomplete.
  • Bupdate.
  • Cappend.
  उत्तर दिखाएँ
• #27

  You have an Azure Data Factory pipeline that performs an incremental load of source data to an Azure Data Lake Storage Gen2 account. Data to be loaded is identified by a column named LastUpdatedDate in the source table. You plan to execute the pipeline every four hours. You need to ensure that the pipeline execution meets the following requirements: Automatically retries the execution when the pipeline run fails due to concurrency or throttling limits. Supports backfilling existing data in the table. Which type of trigger should you use?

  • Aevent.
  • Bon-demand.
  • Cschedule.
  • Dtumbling window.
  उत्तर दिखाएँ
• #28

  You are creating dimensions for a data warehouse in an Azure Synapse Analytics dedicated SQL pool. You create a table by using the Transact-SQL statement shown in the following exhibit.

  • ADimProduct is a [ansver choice] slowly changing dimension (SCD): Type 2. The ProductKey column is [ansver choice]: a surrogate key.
  • BDimProduct is a [ansver choice] slowly changing dimension (SCD): Type 0. The ProductKey column is [ansver choice]: a business key.
  • CDimProduct is a [ansver choice] slowly changing dimension (SCD): Type 1. The ProductKey column is [ansver choice]: an audit column.
  • DDimProduct is a [ansver choice] slowly changing dimension (SCD): Type 2. The ProductKey column is [ansver choice]: a business key.
  उत्तर दिखाएँ
• #29

  You have the following table named Employees. You need to calculate the employee_type value based on the hire_date value. How should you complete the Transact-SQL statement?

  • ABox 1: ELSE. Box 2: CASE.
  • BBox 1: CASE. Box 2: OVER.
  • CBox 1: ELSE. Box 2: OVER.
  • DBox 1: CASE. Box 2: ELSE.
  उत्तर दिखाएँ
• #30

  You have an Azure Synapse Analytics dedicated SQL pool that contains a large fact table. The table contains 50 columns and 5 billion rows and is a heap. Most queries against the table aggregate values from approximately 100 million rows and return only two columns. You discover that the queries against the fact table are very slow. Which type of index should you add to provide the fastest query times?

  • Anonclustered columnstore.
  • Bclustered columnstore.
  • Cnonclustered.
  • Dclustered.
  उत्तर दिखाएँ
• #31

  You have an Azure Synapse Analytics dedicated SQL pod. You need to create a pipeline that will execute a stored procedure in the dedicated SQL pool and use the returned result set as the input or a downstream activity. The solution must minimize development effort. Which Type of activity should you use in the pipeline?

  • ANotebook.
  • BU-SQ.
  • CScript.
  • DStored Procedure.
  उत्तर दिखाएँ
• #32

  You are designing an Azure Databricks interactive cluster. The cluster will be used infrequently and will be configured for auto-termination. You need to ensure that the cluster configuration is retained indefinitely after the cluster is terminated. The solution must minimize costs. What should you do?

  • AClone the cluster after it is terminated.
  • BTerminate the cluster manually when processing completes.
  • CCreate an Azure runbook that starts the cluster every 90 days.
  • DPin the cluster.
  उत्तर दिखाएँ
• #332 चुनें

  You have an Azure Stream Analytics query. The query returns a result set that contains 10,000 distinct values for a column named clusterID. You monitor the Stream Analytics job and discover high latency. You need to reduce the latency. Which two actions should you perform?

  • AAdd a pass-through query.
  • BAdd a temporal analytic function.
  • CScale out the query by using PARTITION BY.
  • DConvert the query to a reference query.
  • EIncrease the number of streaming units.
  उत्तर दिखाएँ
• #34

  What should you recommend using to secure sensitive customer contact information?

  • AData labels.
  • BColumn-level security.
  • CRow-level security.
  • DTransparent Data Encryption (TDE).
  उत्तर दिखाएँ
• #35

  You have a SQL pool in Azure Synapse. You discover that some queries fail or take a long time to complete. You need to monitor for transactions that have rolled back. Which dynamic management view should you query?

  • Asys.dm_pdw_request_steps.
  • Bsys dm_pdw_nodes_tran_database_transactions.
  • Csys.dm_pdw_waits.
  • Dsys.dm_pdw_exec_sessions.
  उत्तर दिखाएँ
• #36

  You have two Azure Storage accounts named Storage1 and Storage2. Each account holds one container and has the hierarchical namespace enabled. The system has files that contain data stored in the Apache Parquet format. You need to copy folders and files from Storage1 to Storage2 by using a Data Factory copy activity. The solution must meet the following requirements: No transformations must be performed. The original folder structure must be retained. Minimize time required to perform the copy activity. How should you configure the copy activity?

  • ASource dataset type: Parquet. Copy activity copy behavior: PreserveHierarchy.
  • BSource dataset type: Binary. Copy activity copy behavior: PreserveHierarchy.
  • CSource dataset type: Parquet. Copy activity copy behavior: FlattenHierarchy.
  • DSource dataset type: Binary. Copy activity copy behavior: FlattenHierarchy.
  उत्तर दिखाएँ
• #37

  You have an Azure Data Factory pipeline that contains a data flow. The data flow contains the following expression: iif(isNull(columnName), 'defaultValue', columnName). You need to ensure that null values in the specified column are replaced with a default value.

  • ANumber of columns: 4. Number of rows: 3.
  • BNumber of columns: 10. Number of rows: 22.
  • CNumber of columns: 22. Number of rows: 4.
  • DNumber of columns: 10. Number of rows: 3.
  उत्तर दिखाएँ
• #38

  You use Azure Stream Analytics to receive Twitter data from Azure Event Hubs and to output the data to an Azure Blob storage account. You need to output the count of tweets during the last five minutes every five minutes. Each tweet must only be counted once. Which windowing function should you use?

  • AFive-minute Session window.
  • BFive-minute Sliding window.
  • CFive-minute Tumbling window.
  • DFive-minute Hopping window that has one-minute hop.
  उत्तर दिखाएँ
• #39

  You have an enterprise data warehouse in Azure Synapse Analytics named DW1 on a server named Server1. You need to verify whether the size of the transaction log file for each distribution of DW1 is smaller than 160 GB. What should you do?

  • AOn the master database, execute a query against the sys.dm_pdw_nodes_os_performance_counters dynamic management view.
  • BFrom Azure Monitor in the Azure portal, execute a query against the logs of DW1.
  • COn DW1, execute a query against the sys.database_files dynamic management view.
  • DExecute a query against the logs of DW1 by using the Get-AzOperationalInsightSearchResult PowerShell cmdlet.
  उत्तर दिखाएँ
• #40

  You manage an enterprise data warehouse in Azure Synapse Analytics. Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries. You need to monitor resource utilization to determine the source of the performance issues. Which metric should you monitor?

  • ADWU percentage.
  • BCache hit percentage Most Voted.
  • CData Warehouse Units (DWU) used.
  • DData IO percentage.
  उत्तर दिखाएँ

अपना स्कोर ट्रैक करना, समयबद्ध मॉक परीक्षा देना और AI व्याख्या पाना चाहते हैं? निःशुल्क खाता बनाएँ