Data Engineering on Microsoft Azure

• #101

  You use Azure Stream Analytics to receive data from Azure Event Hubs and to output the data to an Azure Blob Storage account. You need to output the count of records received from the last five minutes every minute. Which windowing function should you use?

  • ASession.
  • BTumbling.
  • CSliding.
  • DHopping.
  उत्तर दिखाएँ
• #102

  You are developing an Azure Synapse Analytics pipeline that will include a mapping data flow named Dataflow1. Dataflow1 will read customer data from an external source and use a Type 1 slowly changing dimension (SCD) when loading the data into a table named DimCustomer in an Azure Synapse Analytics dedicated SQL pool. You need to ensure that Dataflow1 can perform the following tasks:Detect whether the data of a given customer has changed in the DimCustomer table. Perform an upsert to the DimCustomer table. Which type of transformation should you use for each task?

  • ADetect whether the data of a given customer has changed in the DimCustomer table: Aggregate. Perform an upsert to the DimCustomer table: Alter row.
  • BDetect whether the data of a given customer has changed in the DimCustomer table: Surrogate key. Perform an upsert to the DimCustomer table: Assert.
  • CDetect whether the data of a given customer has changed in the DimCustomer table: Derrived column. Perform an upsert to the DimCustomer table: Alter row.
  • DDetect whether the data of a given customer has changed in the DimCustomer table: Surrogate key. Perform an upsert to the DimCustomer table: Cast.
  उत्तर दिखाएँ
• #103

  You create an Azure Databricks cluster and specify an additional library to install. When you attempt to load the library to a notebook, the library in not found. You need to identify the cause of the issue. What should you review?

  • ANotebook logs.
  • BCluster event logs.
  • CGlobal init scripts logs.
  • DWorkspace logs.
  उत्तर दिखाएँ
• #104

  You have an Azure Synapse Analytics dedicated SQL pool named SA1 that contains a table named Table1. You need to identify tables that have a high percentage of deleted rows. What should you run?

  • Asys.pdw_nodes_column_store_segments.
  • Bsys.dm_db_column_store_row_group_operational_stats.
  • Csys.pdw_nodes_column_store_row_groups.
  • Dsys.dm_bd_column_store_row_group_physical_stats.
  उत्तर दिखाएँ
• #105

  You have an Azure Data Lake Storage Gen2 account named account1 that stores logs as shown in the following table. You do not expect that the logs will be accessed during the retention periods. You need to recommend a solution for account1 that meets the following requirements: Automatically deletes the logs at the end of each retention period Minimizes storage costs What should you include in the recommendation?

  • ATo minimize storage costs: Store the infrastructure logs in the Cool access tier and the application logs in the Archive access tier. To delete logs automatically: Azure Data Factory pipelines.
  • BTo minimize storage costs: Store the infrastructure logs and the application logs in the Cool access tier. To delete logs automatically: Azure Blob storage lifecycle management rules.
  • CTo minimize storage costs: Store the infrastructure logs in the Cool access tier and the application logs in the Archive access tier. To delete logs automatically: Immutable Azure Blob storage time-based retention policies.
  • DTo minimize storage costs: Store the infrastructure logs in the Cool access tier and the application logs in the Archive access tier. To delete logs automatically: Azure Blob storage lifecycle management rules.
  उत्तर दिखाएँ
• #106

  You are incrementally loading data into fact tables in an Azure Synapse Analytics dedicated SQL pool. Each batch of incoming data is staged before being loaded into the fact tables. You need to ensure that the incoming data is staged as quickly as possible. How should you configure the staging tables?

  • ATable distribution: ROUND_ROBIN. Table structure: Heap.
  • BTable distribution: HASH. Table structure: Heap.
  • CTable distribution: REPLICATE. Table structure: Clustered index.
  • DTable distribution: ROUND_ROBIN. Table structure: Columnstore index.
  उत्तर दिखाएँ
• #1073 चुनें

  You have an enterprise-wide Azure Data Lake Storage Gen2 account. The data lake is accessible only through an Azure virtual network named VNET1. You are building a SQL pool in Azure Synapse that will use data from the data lake. Your company has a sales team. All the members of the sales team are in an Azure Active Directory group named Sales. POSIX controls are used to assign the Sales group access to the files in the data lake. You plan to load data to the SQL pool every hour. You need to ensure that the SQL pool can load the sales data from the data lake. Which three actions should you perform?

  • AAdd the managed identity to the Sales group.
  • BUse the managed identity as the credentials for the data load process.
  • CCreate a Shared Access Signature (SAS).
  • DAdd your Azure Active Directory (Azure AD) account to the Sales group.
  • EUse the Shared Access Signature (SAS) as the credentials for the data load process.
  • FCreate a managed identity.
  उत्तर दिखाएँ
• #108

  You have an Azure Data Lake Storage Gen2 container that contains 100 TB of data. You need to ensure that the data in the container is available for read workloads in a secondary region if an outage occurs in the primary region. The solution must minimize costs. Which type of data redundancy should you use?

  • AZone-redundant storage (ZRS).
  • BRead-access geo-redundant storage (RA-GRS).
  • CLocally-redundant storage (LRS).
  • DGeo-redundant storage (GRS).
  उत्तर दिखाएँ
• #109

  You have two fact tables named Flight and Weather. Queries targeting the tables will be based on the join between the following columns. You need to recommend a solution that maximizes query performance. What should you include in the recommendation?

  • AIn the tables use a hash distribution of ArrivalDateTime and ReportDateTime.
  • BIn the tables use a hash distribution of ArrivaIAirportID and AirportlD.
  • CIn each table, create an identity column.
  • DIn each table, create a column as a composite of the other two columns in the table.
  उत्तर दिखाएँ
• #110

  What should you do to improve high availability of the real-time data processing solution?

  • ADeploy identical Azure Stream Analytics jobs to paired regions in Azure.
  • BDeploy a High Concurrency Databricks cluster.
  • CDeploy an Azure Stream Analytics job and use an Azure Automation runbook to check the status of the job and to start the job if it stops.
  • DSet Data Lake Storage to use geo-redundant storage (GRS).
  उत्तर दिखाएँ
• #111

  You need to collect application metrics, streaming query events, and application log messages for an Azure Databrick cluster. Which type of library and workspace should you implement?

  • ALibrary: Microsoft Azure Management Monitoring Library. Workspace: Azure Machine Learning.
  • BLibrary: Azure Databricks Monitoring Library. Workspace: Azure Log Analytics.
  • CLibrary: PyTorch. Workspace: Azure Databricks.
  • DLibrary: TensorFlow. Workspace: Azure Machine Learning.
  उत्तर दिखाएँ
• #112

  You need to trigger an Azure Data Factory pipeline when a file arrives in an Azure Data Lake Storage Gen2 container. Which resource provider should you enable?

  • AMicrosoft.Sql.
  • BMicrosoft-Automation.
  • CMicrosoft.EventGrid.
  • DMicrosoft.EventHub.
  उत्तर दिखाएँ
• #113

  You have an Azure Synapse Analytics dedicated SQL pool. You need to ensure that data in the pool is encrypted at rest. The solution must NOT require modifying applications that query the data. What should you do?

  • AEnable encryption at rest for the Azure Data Lake Storage Gen2 account.
  • BEnable Transparent Data Encryption (TDE) for the pool.
  • CUse a customer-managed key to enable double encryption for the Azure Synapse workspace.
  • DCreate an Azure key vault in the Azure subscription grant access to the pool.
  उत्तर दिखाएँ
• #114

  You are implementing Azure Stream Analytics windowing functions. Which windowing function should you use for each requirement?

  • ASegment the data stream into distinct time segments that repeat but do not overlap: Sliding. Segment the data stream into distinct time segments that repeat and can overlap: Hopping. Segment the data stream to produce an output only when an event occurs: Tumbling.
  • BSegment the data stream into distinct time segments that repeat but do not overlap: Tumbling. Segment the data stream into distinct time segments that repeat and can overlap: Hopping. Segment the data stream to produce an output only when an event occurs: Hopping.
  • CSegment the data stream into distinct time segments that repeat but do not overlap: Hopping. Segment the data stream into distinct time segments that repeat and can overlap: Sliding. Segment the data stream to produce an output only when an event occurs: Tumbling.
  • DSegment the data stream into distinct time segments that repeat but do not overlap: Sliding. Segment the data stream into distinct time segments that repeat and can overlap: Tumbling. Segment the data stream to produce an output only when an event occurs: Hopping.
  उत्तर दिखाएँ
• #115

  You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements. Which Azure Storage functionality should you include in the solution?

  • AChange feed.
  • BSoft delete.
  • CTime-based retention.
  • DLifecycle management.
  उत्तर दिखाएँ
• #116

  You have an Azure Data Factory pipeline that has the activities shown in the following exhibit.

  • AStored procedure1 will execute Web1 and Set variable1: succeed. If Web1 and Set variable2 succeds, the pipeline status will be: Failed.
  • BStored procedure1 will execute Web1 and Set variable1: complete. If Web1 and Set variable2 succeds, the pipeline status will be: Failed.
  • CStored procedure1 will execute Web1 and Set variable1: fail. If Web1 and Set variable2 succeds, the pipeline status will be: Succeeded.
  • DStored procedure1 will execute Web1 and Set variable1: complete. If Web1 and Set variable2 succeds, the pipeline status will be: Canceled.
  उत्तर दिखाएँ
• #117

  You need to create a partitioned table in an Azure Synapse Analytics dedicated SQL pool. How should you complete the Transact-SQL statement?

  • ABox 1: DISTRIBUTION. Box 2: PARTITION.
  • BBox 1: PARTITION FUNCTION. Box 2: DISTRIBUTION.
  • CBox 1: CLUSTERED INDEX. Box 2: PARTITION SCHEME.
  • DBox 1: COLLATE. Box 2: PARTITION FUNCTION.
  उत्तर दिखाएँ
• #118

  You need to design a data ingestion and storage solution for the Twitter feeds. The solution must meet the customer sentiment analytics requirements. What should you include in the solution?

  • ATo increase the throughput of ingesting the Twitter feeds: Configure Event Hubs partitions. To store the Twitter feed data, use: An Azure Databricks high concurrency cluster.
  • BTo increase the throughput of ingesting the Twitter feeds: Configure Event Hubs partitions. To store the Twitter feed data, use: An Azure Data Lake Storage Gen2 account.
  • CTo increase the throughput of ingesting the Twitter feeds: Use Event Hubs Dedicated. To store the Twitter feed data, use: An Azure General-purpose V2 storage account in the Premium tier.
  • DTo increase the throughput of ingesting the Twitter feeds: Enable Auto-Inflate in Event Hubs. To store the Twitter feed data, use: An Azure Databricks high concurrency cluster.
  उत्तर दिखाएँ
• #119

  Solution: In an Azure Synapse Analytics pipeline, you use a data flow that contains a Derived Column transformation.

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

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

  • ADBCC INDEXDEFRAG (pool1, table1).
  • BDBCC DBREINDEX (table1).
  • CALTER INDEX ALL on table1 REORGANIZE.
  • DALTER INDEX ALL on table1 REBUILD.
  उत्तर दिखाएँ

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