Data Engineering on Microsoft Azure

• #81Choose 2

  You plan to create an Azure Data Lake Storage Gen2 account You need to recommend a storage solution that meets the following requirements: Provides the highest degree of data resiliency Ensures that content remains available for writes if a primary data center fails What should you include in the recommendation?

  • AReplication machanism: Zone-redundant storage (ZRS). Failover process: Failover automatically initiated by an Azure Automation job.
  • BReplication machanism: Change feed. Failover process: Failover initiated by Microsoft.
  • CReplication machanism: Read-access geo-zone-redundant storage (RA-GRS). Failover process: Failover manually initiated by the customer.
  • DReplication machanism: Read-access geo-redundant storage (RA-GRS). Failover process: Failover initiated by Microsoft.
  Show answer
• #82

  You need to create an Azure Data Factory pipeline to process data for the following three departments at your company: Ecommerce, retail, and wholesale. The solution must ensure that data can also be processed for the entire company. How should you complete the Data Factory data flow script?

  • ABox 1: dept=='ecommerce', dept=='retail', dept-- 'wholesale'. Box 2: disjoint: false. Box 3: ecommerce, retail, wholesale, all.
  • BBox 1: ecommerce, retail, wholesale, all. Box 2: disjoint: false. Box 3: dept=='ecommerce', dept=='retail', dept-- 'wholesale'.
  • CBox 1: dept=='ecommerce', dept=='retail', dept-- 'wholesale'. Box 2: disjoint: true. Box 3: ecommerce, retail, wholesale, all.
  • DBox 1: dept=='ecommerce', dept=='wholesale', dept-- 'retail'. Box 2: disjoint: true. Box 3: ecommerce, retail, wholesale, all.
  Show answer
• #83

  You are designing a streaming data solution that will ingest variable volumes of data. You need to ensure that you can change the partition count after creation. Which service should you use to ingest the data?

  • AAzure Event Hubs Dedicated.
  • BAzure Stream Analytics.
  • CAzure Data Factory.
  • DAzure Synapse Analytics.
  Show answer
• #84

  A company plans to use Apache Spark analytics to analyze intrusion detection data. You need to recommend a solution to analyze network and system activity data for malicious activities and policy violations. The solution must minimize administrative efforts. What should you recommend?

  • AAzure Data Lake Storage.
  • BAzure Databricks.
  • CAzure HDInsight.
  • DAzure Data Factory.
  Show answer
• #85

  You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email. You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of aXXX@XXXX.com instead. What should you do?

  • AFrom Microsoft SQL Server Management Studio, set an email mask on the Email column.
  • BFrom the Azure portal, set a mask on the Email column.
  • CFrom Microsoft SQL Server Management studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email.
  • DFrom the Azure portal, set a sensitivity classification of Confidential for the Email column.
  Show answer
• #86

  You need to design a solution that will process streaming data from an Azure Event Hub and output the data to Azure Data Lake Storage. The solution must ensure that analysts can interactively query the streaming data. What should you use?

  • Aevent triggers in Azure Data Factory.
  • BAzure Stream Analytics and Azure Synapse notebooks.
  • CStructured Streaming in Azure Databricks.
  • DAzure Queue storage and read-access geo-redundant storage (RA-GRS).
  Show answer
• #87

  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? When creating the table for sales transactions:

  • AConfigure a clustered index.
  • BSet the distribution column to the sales date.
  • CSet the distribution column to product ID.
  Show answer
• #88

  You have an Azure Databricks resource. You need to log actions that relate to changes in compute for the Databricks resource. Which Databricks services should you log?

  • AClusters.
  • BWorkspace.
  • CDBFS.
  • DSSH.
  • EJobs.
  Show answer
• #89

  You have an Azure Synapse Analytics serverless SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named storage1. The AllowedBlobpublicAccess porperty is disabled for storage1. You need to create an external data source that can be used by Azure Active Directory (Azure AD) users to access storage1 from Pool1. What should you create first?

  • Aan external resource pool
  • Ba remote service binding
  • Cdatabase scoped credentials
  • Dan external library
  Show answer
• #90

  A company plans to use Platform-as-a-Service (PaaS) to create the new data pipeline process. The process must meet the following requirements: Ingest: Access multiple data sources. Provide the ability to orchestrate workflow. Provide the capability to run SQL Server Integration Services packages. Store: Optimize storage for big data workloads. Provide encryption of data at rest. Operate with no size limits. Prepare and Train: Provide a fully-managed and interactive workspace for exploration and visualization. Provide the ability to program in R, SQL, Python, Scala, and Java. Provide seamless user authentication with Azure Active Directory. Model & Serve: Implement native columnar storage. Support for the SQL language Provide support for structured streaming. You need to build the data integration pipeline. Which technologies should you use?

  • AIngest: Logic Apps. Store: Azure Data Lake Storage. Prepare and Train: HDInsight Apache Spark cluster. Model and Serve: HDInsight Apache Kafka cluster.
  • BIngest: Azure Data Factory. Store: Azure Blob Storage. Prepare and Train: Azure Databricks. Model and Serve: Azure Synapse Analytics.
  • CIngest: Azure Data Factory. Store: Azure Data Lake Storage. Prepare and Train: Azure Databricks. Model and Serve: Azure Databricks.
  • DIngest: Azure Automation. Store: Azure files. Prepare and Train: HDInsight Apache Storm cluster. Model and Serve: Azure Data Lake Storage.
  Show answer
• #91

  You have an Azure Storage account that contains 100 GB of files. The files contain rows of text and numerical values. 75% of the rows contain description data that has an average length of 1.1 MB. You plan to copy the data from the storage account to an enterprise data warehouse in Azure Synapse Analytics. You need to prepare the files to ensure that the data copies quickly. Solution: You modify the files to ensure that each row is less than 1 MB. Does this meet the goal?

  • AYes.
  • BNo.
  Show answer
• #92

  You have an enterprise data warehouse in Azure Synapse Analytics. You need to monitor the data warehouse to identify whether you must scale up to a higher service level to accommodate the current workloads Which is the best metric to monitor?

  • AData 10 percentage.
  • BCPU percentage.
  • CDWU used.
  • DDWU percentage.
  Show answer
• #93

  You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1. You plan to create a database named D61 in Pool1. You need to ensure that when tables are created in DB1, the tables are available automatically as external tables to the built-in serverless SQL pod. Which format should you use for the tables in DB1?

  • AParquet.
  • BCSV.
  • CORC.
  • DJSON.
  Show answer
• #94

  What should you recommend to prevent users outside the Litware on-premises network from accessing the analytical data store?

  • Aa server-level virtual network rule.
  • Ba database-level virtual network rule.
  • Ca database-level firewall IP rule.
  • Da server-level firewall IP rule.
  Show answer
• #95

  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 be six columns in the output of ProductRows.

  • AYes.
  • BNo.
  Show answer
• #96

  You have an Azure Storage account and a data warehouse in Azure Synapse Analytics in the UK South region. You need to copy blob data from the storage account to the data warehouse by using Azure Data Factory. The solution must meet the following requirements: Ensure that the data remains in the UK South region at all times. Minimize administrative effort. Which type of integration runtime should you use?

  • AAzure integration runtime.
  • BAzure-SSIS integration runtime.
  • CSelf-hosted integration runtime.
  Show answer
• #97Choose 2

  A company has a real-time data analysis solution that is hosted on Microsoft Azure. The solution uses Azure Event Hub to ingest data and an Azure Stream Analytics cloud job to analyze the data. The cloud job is configured to use 120 Streaming Units (SU). You need to optimize performance for the Azure Stream Analytics job. Which two actions should you perform?

  • AImplement event ordering.
  • BImplement Azure Stream Analytics user-defined functions (UDF).
  • CImplement query parallelization by partitioning the data output.
  • DScale the SU count for the job up.
  • EScale the SU count for the job down.
  • FImplement query parallelization by partitioning the data input.
  Show answer
• #98

  You have an Azure subscription that contains an Azure Synapse Analytics workspace named workspace1. Workspace1 contains a dedicated SQL pool named SQL Pool and an Apache Spark pool named sparkpool. Sparkpool1 contains a DataFrame named pyspark.df. You need to write the contents of pyspark_df to a tabte in SQLPooM by using a PySpark notebook. How should you complete the code?

  • ABox 1: %%local. Box 2: saveAsTable.
  • BBox 1: %%local. Box 2: jdbc.
  • CBox 1: %%sql. Box 2: synapsesql.
  • DBox 1: %%spark. Box 2: synapsesql.
  Show answer
• #99

  You are designing the folder structure for an Azure Data Lake Storage Gen2 container. Users will query data by using a variety of services including Azure Databricks and Azure Synapse Analytics serverless SQL pools. The data will be secured by subject area. Most queries will include data from the current year or current month. Which folder structure should you recommend to support fast queries and simplified folder security?

  • A/{SubjectArea}/{DataSource}/{DD}/{MM}/{YYYY}/{FileData}_{YYYY}_{MM}_{DD}.csv.
  • B/{DD}/{MM}/{YYYY}/{SubjectArea}/{DataSource}/{FileData}_{YYYY}_{MM}_{DD}.csv.
  • C/{YYYY}/{MM}/{DD}/{SubjectArea}/{DataSource}/{FileData}_{YYYY}_{MM}_{DD}.csv.
  • D/{SubjectArea}/{DataSource}/{YYYY}/{MM}/{DD}/{FileData}_{YYYY}_{MM}_{DD}.csv.
  Show answer
• #100

  You have a Microsoft Purview account. The Lineage view of a CSV file is shown in the following exhibit. How is the data for the lineage populated?

  • Amanually.
  • Bby scanning data stores.
  • Cby executing a Data Factory pipeline.
  Show answer

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