Data Engineering on Microsoft Azure

• #161

  Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes mapping data Flow, and then inserts the data info the data warehouse.

  • AYes.
  • BNo.
  解答を表示
• #162

  You have an Azure data factory. You need to examine the pipeline failures from the last 180 flays. What should you use?

  • Athe Activity tog blade for the Data Factory resource.
  • BAzure Data Factory activity runs in Azure Monitor.
  • CPipeline runs in the Azure Data Factory user experience.
  • Dthe Resource health blade for the Data Factory resource.
  解答を表示
• #163

  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 Standard cluster for each data scientist, a Standard cluster for the data engineers, and a High Concurrency cluster for the jobs. Does this meet the goal?

  • AYes.
  • BNo.
  解答を表示
• #164

  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: In an Azure Synapse Analytics pipeline, you use a Get Metadata activity that retrieves the DateTime of the files. Does this meet the goal?

  • AYes.
  • BNo.
  解答を表示
• #1653 つ選択

  You are implementing a star schema in an Azure Synapse Analytics dedicated SQL pool. You plan to create a table named DimProduct. DimProduct must be a Type 3 slowly changing dimension (SCD) table that meets the following requirements: The values in two columns named ProductKey and ProductSourceID will remain the same. The values in three columns named ProductName, ProductDescription, and Color can change. You need to add additional columns to complete the following table definition. Which three columns should you add?

  • A[EffectiveStartDate] [datetime] NOT NULL.
  • B[EffectiveEndDate] [datetime] NOT NULL.
  • C[OriginalProductDescription] NVARCHAR(2000) NOT NULL.
  • D[IsCurrentRow] [bit] NOT NULL.
  • E[OriginalColor] NVARCHAR(50) NOT NULL.
  • F[OriginalProductName] NVARCHAR(100) NULL.
  解答を表示
• #166

  You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1. Table1 contains the following: One billion rows A clustered columnstore index A hash-distributed column named Product Key A column named Sales Date that is of the date data type and cannot be null Thirty million rows will be added to Table1 each month. You need to partition Table1 based on the Sales Date column. The solution must optimize query performance and data loading. How often should you create a partition?

  • Aonce per month.
  • Bonce per year.
  • Conce per day.
  • Donce per week.
  解答を表示
• #167

  You build an Azure Data Factory pipeline to move data from an Azure Data Lake Storage Gen2 container to a database in an Azure Synapse Analytics dedicated SQL pool. Data in the container is stored in the following folder structure. /in/{YYYY}/{MM}/{DD}/{HH}/{mm} The earliest folder is /in/2021/01/01/00/00. The latest folder is /in/2021/01/15/01/45. You need to configure a pipeline trigger to meet the following requirements: Existing data must be loaded. Data must be loaded every 30 minutes. Late-arriving data of up to two minutes must he included in the load for the time at which the data should have arrived. How should you configure the pipeline trigger?

  • AType: Tumbling window. Additional properties: Recurrence: 30 minutes, Start time: 2021-01-01T00:00, Delay: 2 minutes.
  • BType: Schedule. Additional properties: Recurrence: 30 minutes, Start time: 2021-01-01T00:00, Delay: 2 minutes.
  • CType: Schedule. Additional properties: Prefix: /in/, Event: created.
  • DType: On-demand. Additional properties: Recurrence: 30 minutes, Start time: 2021-01-01T00:00.
  解答を表示
• #1682 つ選択

  You are designing 2 solution that will use tables in Delta Lake on Azure Databricks. You need to minimize how long it takes to perform the following: Queries against non-partitioned tables. Joins on non-partitioned columns. Which two options should you include in the solution?

  • AZ-Ordering
  • BApache Spark caching
  • Cdynamic file pruning (DFP)
  • Dthe clone command
  解答を表示
• #169

  You implement an enterprise data warehouse in Azure Synapse Analytics. You have a large fact table that is 10 terabytes (TB) in size. Incoming queries use the primary key SaleKey column to retrieve data as displayed in the following table: You need to distribute the large fact table across multiple nodes to optimize performance of the table. Which technology should you use?

  • Ahash distributed table with clustered index.
  • Bhash distributed table with clustered Columnstore index.
  • Cround robin distributed table with clustered index.
  • Dround robin distributed table with clustered Columnstore index.
  • Eheap table with distribution replicate.
  解答を表示
• #1702 つ選択

  You are designing a data mart for the human resources (HR) department at your company. The data mart will contain employee information and employee transactions. From a source system, you have a flat extract that has the following fields: EmployeeIDFirstName - LastName Recipient GrossAmount TransactionID GovernmentID NetAmountPaid TransactionDate You need to design a star schema data model in an Azure Synapse Analytics dedicated SQL pool for the data mart. Which two tables should you create?

  • ADimension table for Transaction.
  • BDimension table for EmployeeTransaction.
  • CDimension table for Employee.
  • DFact table for Employee.
  • EFact table for Transaction.
  解答を表示
• #171

  You need to design a data storage structure for the product sales transactions. The solution must meet the sales transaction dataset requirements. What should you include in the solution? Table type to store the product sales transactions:

  • AHash.
  • BRound-robin.
  • CReplicated.
  解答を表示
• #172

  You are designing an Azure Stream Analytics job to process incoming events from sensors in retail environments. You need to process the events to produce a running average of shopper counts during the previous 15 minutes, calculated at five-minute intervals. Which type of window should you use?

  • Asnapshot.
  • Btumbling.
  • Chopping.
  • Dsliding.
  解答を表示
• #173

  You are developing a solution using a Lambda architecture on Microsoft Azure. The data at test layer must meet the following requirements: Data storage: Serve as a repository or high volumes of large files in various formats. Implement optimized storage for big data analytics workloads. Ensure that data can be organized using a hierarchical structure. Batch processing: Use a managed solution for in-memory computation processing. Natively support Scala, Python, and R programming languages. Provide the ability to resize and terminate the cluster automatically. Analytical data store: Support parallel processing. Use columnar storage. Support SQL-based languages. You need to identify the correct technologies to build the Lambda architecture. Which technologies should you use?

  • AData storage: Azure Data Lake Store. Batch processing: HDInsight Spark. Analytical data store: Azure Synapse Analytics.
  • BData storage: Azure SQL Database. Batch processing: HDInsight Hadoop. Analytical data store: HDInsinght HBase.
  • CData storage: Azure Blob Storage. Batch processing: Azure Databricks. Analytical data store: Azure Analysis Services.
  • DData storage: Azure Data Lake Store. Batch processing: HDInsight Interactive Query. Analytical data store: Azure Cosmos DB.
  解答を表示
• #174

  You plan to develop a dataset named Purchases by using Azure databricks Purchases will contain the following columns: ProductID ItemPrice lineTotal Quantity StorelD Minute Month Hour Year Day You need to store the data to support hourly incremental load pipelines that will vary for each StoreID. the solution must minimize storage costs. How should you complete the rode?

  • ABox 1: .bucketBy. Box 2("StoreID","Year","Month","Day","Hour") Box 3: .csv("/Purchases").
  • BBox 1: .partitionBy. Box 2: ("StoreID","Hour"). Box 3: .json("/Purchases").
  • CBox 1: .partitionBy. Box 2: ("StoreID", , "Year", "Month", "Day", "Hour"). Box 3: .parquet(/Purchases").
  • DBox 1: .range. Box 2: (""). Box 3: .saveAsTable("/Purchases").
  解答を表示
• #175

  You have an Azure subscription that contains a logical Microsoft SQL server named Server1. Server1 hosts an Azure Synapse Analytics SQL dedicated pool named Pool1. You need to recommend a Transparent Data Encryption (TDE) solution for Server1. The solution must meet the following requirements: Track the usage of encryption keys. Maintain the access of client apps to Pool1 in the event of an Azure datacenter outage that affects the availability of the encryption keys. What should you include in the recommendation?

  • ATo track encryption key usage: Always Encrypted. To maintain client app access in the event of a datacenter outage: Create and configure Azure key vaults in two Azure regions.
  • BTo track encryption key usage: TDE with customer-managed keys. To maintain client app access in the event of a datacenter outage: Create and configure Azure key vaults in two Azure regions.
  • CTo track encryption key usage: TDE with customer-managed keys. To maintain client app access in the event of a datacenter outage: .NET Framework data provider.
  • DTo track encryption key usage: TDE with platform-managed keys. To maintain client app access in the event of a datacenter outage: Enable Advanced Data Security on Server1.
  解答を表示
• #176

  You have a C# application that process data from an Azure IoT hub and performs complex transformations. You need to replace the application with a real-time solution. The solution must reuse as much code as possible from the existing application.

  • AAzure Databricks.
  • BAzure Event Grid.
  • CAzure Stream Analytics.
  • DAzure Data Factory.
  解答を表示
• #177

  You have a self-hosted integration runtime in Azure Data Factory. The current status of the integration runtime has the following configurations: Status: Running Type: Self-Hosted Version: 4.4.7292.1 Running / Registered Node(s): 1/1 High Availability Enabled: False Linked Count: 0 Queue Length: 0 Average Queue Duration. 0.00s The integration runtime has the following node details: Name: X-M Status: Running Version: 4.4.7292.1 Available Memory: 7697MB CPU Utilization: 6% Network (In/Out): 1.21KBps/0.83KBps Concurrent Jobs (Running/Limit): 2/14 Role: Dispatcher/Worker Credential Status.

  • AIf the X-M node becomes unavailable, all executed pipelines will be: switch to another integration runtime. Box 2: left as is.
  • BIf the X-M node becomes unavailable, all executed pipelines will be: exceed the CPU limit. Box 2: left as is.
  • CIf the X-M node becomes unavailable, all executed pipelines will be: fail until the node comes back online. Box 2: raised.
  • DIf the X-M node becomes unavailable, all executed pipelines will be: fail until the node comes back online. Box 2: lowered.
  解答を表示
• #178

  You need to implement an Azure Synapse Analytics database object for storing the sales transactions data. The solution must meet the sales transaction dataset requirements. What should you do?

  • ATransact-SQL DDL command to use: CREATE EXTERNAL TABLE. Partitioning option to use in the WITH clause of the DDL statement: FORMAT_TYPE.
  • BTransact-SQL DDL command to use: CREATE TABLE. Partitioning option to use in the WITH clause of the DDL statement: RANGE RIGHT FOR VALUES.
  • CTransact-SQL DDL command to use: CREATE TABLE. Partitioning option to use in the WITH clause of the DDL statement: RANGE LEFT FOR VALUES.
  • DTransact-SQL DDL command to use: CREATE VIEW. Partitioning option to use in the WITH clause of the DDL statement: RANGE LEFT FOR VALUES.
  解答を表示
• #179

  You are designing a dimension table in an Azure Synapse Analytics dedicated SQL pool. You need to create a surrogate key for the table. The solution must provide the fastest query performance. What should you use for the surrogate key?

  • Aa GUID column
  • Ba sequence object
  • Can IDENTITY column
  解答を表示
• #180

  You have an Azure Data Factory version 2 (V2) resource named Df1. Df1 contains a linked service. You have an Azure Key vault named vault1 that contains an encryption key named key1. You need to encrypt Df1 by using key1. What should you do first?

  • AAdd a private endpoint connection to vaul 1.
  • BEnable Azure role-based access control on vault 1.
  • CRemove the linked service from Df1.
  • DCreate a self-hosted integration runtime.
  解答を表示

スコアの記録、時間制限付き模擬試験、AI解説をご利用になりますか？ 無料アカウントを作成