Data Engineering on Microsoft Azure

• #41

  You have a partitioned table in an Azure Synapse Analytics dedicated SQL pool. You need to design queries to maximize the benefits of partition elimination. What should you include in the Transact-SQL queries?

  • AJOIN.
  • BWHERE.
  • CDISTINCT.
  • DGROUP BY.
  Tampilkan jawaban
• #42

  You plan to perform batch processing in Azure Databricks once daily. Which type of Databricks cluster should you use?

  • AHigh Concurrency.
  • Bautomated.
  • Cinteractive.
  Tampilkan jawaban
• #43

  You need to output files from Azure Data Factory. Which file format should you use for each type of output?

  • AColumnar format: Avro. JSON with a timestamp: GZip.
  • BColumnar format: Parquet. JSON with a timestamp: Avro.
  • CColumnar format: GZip. JSON with a timestamp: Parquet.
  • DColumnar format: Avro. JSON with a timestamp: Parquet.
  Tampilkan jawaban
• #44

  You plan to create an Azure Data Factory pipeline that will include a mapping data flow. You have JSON data containing objects that have nested arrays. You need to transform the JSON-formatted data into a tabular dataset. The dataset must have one tow for each item in the arrays. Which transformation method should you use in the mapping data flow?

  • Aunpivot.
  • Bflatten.
  • Cnew branch.
  • Dalter row.
  Tampilkan jawaban
• #45

  You have an Azure Data Factory instance that contains two pipelines named Pipeline1 and Pipeline2. Pipeline1 has the activities shown in the following exhibit. Pipeline2 has the activities shown in the following exhibit. You execute Pipeline2, and Stored procedure1 in Pipeline1 fails. What is the status of the pipeline runs?

  • APipeline1 and Pipeline2 succeeded.
  • BPipeline1 and Pipeline2 failed.
  • CPipeline1 succeeded and Pipeline2 failed.
  • DPipeline1 failed and Pipeline2 succeeded.
  Tampilkan jawaban
• #46

  You are monitoring an Azure Stream Analytics job. The Backlogged Input Events count has been 20 for the last hour. You need to reduce the Backlogged Input Events count. What should you do?

  • ADrop late arriving events from the job.
  • BAdd an Azure Storage account to the job.
  • CIncrease the streaming units for the job.
  • DStop the job.
  Tampilkan jawaban
• #47

  You need to implement versioned changes to the integration pipelines. The solution must meet the data integration requirements. In which order should you perform the actions?

  • ABox 1: Create a feature branch. Box 2: Merge changes. Box 3: Create a repository and a main branch. Box 4: Create a pull request. Box 5: Publish changes.
  • BBox 1: Publish changes. Box 2: Create a repository and a main branch. Box 3: Merge changes. Box 4: Merge changes. Box 5: Publish changes.
  • CBox 1: Create a repository and a main branch. Box 2: Create a feature branch. Box 3: Create a pull request. Box 4: Merge changes. Box 5: Publish changes.
  • DBox 1: Create a feature branch. Box 2: Create a pull request. Box 3: Merge changes. Box 4: Create a repository and a main branch. Box 5: Publish changes.
  Tampilkan jawaban
• #48

  You need to design an analytical storage solution for the transactional data. The solution must meet the sales transaction dataset requirements. What should you include in the solution?

  • ATable type to store retail store data: Hash. Table type to store promotional data: Round-robin.
  • BTable type to store retail store data: Replicated. Table type to store promotional data: Hash.
  • CTable type to store retail store data: Hash. Table type to store promotional data: Replicated.
  • DTable type to store retail store data: Round-robin. Table type to store promotional data: Hash.
  Tampilkan jawaban
• #49

  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?

  • AOnly CSV files in the tripdata_2020 subfolder.
  • BAll files that have file names that beginning with "tripdata_2020".
  • CAll CSV files that have file names that contain "tripdata_2020".
  • DOnly CSV that have file names that beginning with "tripdata_2020".
  Tampilkan jawaban
• #50

  You have an Azure Synapse Analytics dedicated SQL pool. You need to create a table named FactInternetSales that will be a large fact table in a dimensional model. FactInternetSales will contain 100 million rows and two columns named SalesAmount and OrderQuantity. Queries executed on FactInternetSales will aggregate the values in SalesAmount and OrderQuantity from the last year for a specific product. The solution must minimize the data size and query execution time. How should you complete the code?

  • ABox 1: ( CLUSTERED COLUMNSTORE INDEX. Box 2: Hash([OrderDataKey]).
  • BBox 1: ( HEAP. Box 2: REPLICATE.
  • CBox 1: ( CLUSTERED COLUMNSTORE INDEX. Box 2: Hash([ProductKey]).
  • DBox 1: ( INDEX on [ProductKey]. Box 2: ROUND_ROBIN.
  Tampilkan jawaban
• #51

  You store files in an Azure Data Lake Storage Gen2 container. The container has the storage policy 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.

  • AThe files are [...] after 30 days: moved to cool storage. The storage policy applies to: container1/contoso.csv.
  • BThe files are [...] after 30 days: moved to archive storage. The storage policy applies to: container1/docs/contoso.json.
  • CThe files are [...] after 30 days: moved to hot storage. The storage policy applies to: container1/docs/contoso.json.
  • DThe files are [...] after 30 days: deleted from the container. The storage policy applies to: container1/mycontoso/contoso.csv.
  Tampilkan jawaban
• #52

  You are designing an Azure Databricks table. The table will ingest an average of 20 million streaming events per day. You need to persist the events in the table for use in incremental load pipeline jobs in Azure Databricks. The solution must minimize storage costs and incremental load times. What should you include in the solution?

  • APartition by DateTime fields.
  • BSink to Azure Queue storage.
  • CInclude a watermark column.
  • DUse a JSON format for physical data storage.
  Tampilkan jawaban
• #53Pilih 3

  You are designing a slowly changing dimension (SCD) for supplier data in an Azure Synapse Analytics dedicated SQL pool. You plan to keep a record of changes to the available fields. The supplier data contains the following columns. Which three additional columns should you add to the data to create a Type 2 SCD?

  • ASurrogate primary key.
  • BForeign key.
  • CEffective start date.
  • DEffective end date.
  • ELast modified date.
  • FBusiness key.
  Tampilkan jawaban
• #54

  You are building an Azure Data Factory solution to process data received from Azure Event Hubs, and then ingested into an Azure Data Lake Storage Gen2 container. The data will be ingested every five minutes from devices into JSON files. The files have the following naming pattern. /{deviceType}/in/{YYYY}/{MM}/{DD}/{HH}/{deviceID}_{YYYY}{MM}{DD}HH}{mm}.json You need to prepare the data for batch data processing so that there is one dataset per hour per device Type. The solution must minimize read times. How should you configure the sink for the copy activity?

  • AParameter: @pipeline(),TriggerTime. Naming pattern: /{deviceID}/out/{YYYY}/{MM}/{DD}/{HH}.json. Copy behavior: Add dynamic content.
  • BParameter: @pipeline(),TriggerType. Naming pattern: /{YYYY}/{MM}/{DD}/{deviceType}.json. Copy behavior: Merge files.
  • CParameter: @trigger().startTime. Naming pattern: /{YYYY}/{MM}/{DD}/{HH}_{deviceType}.json. Copy behavior: Flatten hierarchy.
  • DParameter: @trigger().outputs.windowStartTime. Naming pattern: /{YYYY}/{MM}/{DD}/{HH}.json. Copy behavior: Add dynamic content.
  Tampilkan jawaban
• #55

  You are developing a solution that will stream to Azure Stream Analytics. The solution will have both streaming data and reference data. Which input type should you use for the reference data?

  • AAzure Cosmos DB.
  • BAzure Blob storage.
  • CAzure IoT Hub.
  • DAzure Event Hubs.
  Tampilkan jawaban
• #56

  You are designing an Azure Stream Analytics solution that will analyze Twitter data. You need to count the tweets in each 10-second window. The solution must ensure that each tweet is counted only once. Solution: You use a tumbling window, and you set the window size to 10 seconds. Does this meet the goal?

  • AYes.
  • BNo.
  Tampilkan jawaban
• #57

  You are designing an inventory updates table in an Azure Synapse Analytics dedicated SQL pool. The table will have a clustered columnstore index and will include the following columns: You identify the following usage patterns: Analysts will most commonly analyze transactions for a warehouse. Queries will summarize by product category type, date, and/or inventory event type. You need to recommend a partition strategy for the table to minimize query times. On which column should you partition the table?

  • AProductCategoryTypeIDEventDate.
  • BEventDate.
  • CWarehouseID.
  • DEventTypeID.
  Tampilkan jawaban
• #58

  You have a table in an Azure Synapse Analytics dedicated SQL pool. The table was created by using the following Transact-SQL statement. You need to alter the table to meet the following requirements: Ensure that users can identify the current manager of employees. Support creating an employee reporting hierarchy for your entire company. Provide fast lookup of the managers' attributes such as name and job title. Which column should you add to the table?

  • A[ManagerEmployeeID] [int] NULL
  • B[ManagerEmployeeID] [smallint] NULL
  • C[ManagerEmployeeKey] [int] NULL
  • D[ManagerName] varchar NULL
  Tampilkan jawaban
• #59

  You have an Azure data factory named adf1 that contains a pipeline named ExecProduct. ExecProduct contains a data flow named Product. The Product data flow contains the following transformations: WeeklyData: A source that points to a CSV file in an Azure Data Lake Storage Gen2 account with 20 columns. ProductColumns: A select transformation that selects from WeeklyData six columns named ProductID, ProductDescr, ProductSubCategory, ProductCategory, ProductStatus, and ProductLastUpdated. ProductRows: An aggregate transformation. ProductList: A sink that outputs data to an Azure Synapse Analytics dedicated SQL pool. The Aggregate settings for ProductRows are configured as shown in the following exhibit. There will always be one output row for each unique value of ProductDescr.

  • AYes.
  • BNo.
  Tampilkan jawaban
• #60

  You have an Azure Data Lake Storage account that has a virtual network service endpoint configured. You plan to use Azure Data Factory to extract data from the Data Lake Storage account. The data will then be loaded to a data warehouse in Azure Synapse Analytics by using PolyBase. Which authentication method should you use to access Data Lake Storage?

  • Ashared access key authentication.
  • Bmanaged identity authentication.
  • Caccount key authentication.
  • Dservice principal authentication.
  Tampilkan jawaban

Ingin melacak skor, mengikuti ujian simulasi berwaktu, dan mendapat penjelasan AI? Buat akun gratis