Data Engineering on Microsoft Azure Test 15

What security option would be the best option to use?

Select 1 option(s):

Microsoft Azure Storage is a managed service that provides durable, secure, and scalable storage in the cloud. A single Azure subscription can host up to [A] storage accounts, each of which can hold [B] TB of data.

Select 1 option(s):

True or False: Each data factory has a single dedicated pipeline. When additional pipelines are needed for workloads, additional data factory deployments can be used to create an unlimited number of pipelines.

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Transactional databases are often called [?] systems. These systems commonly support lots of users, have quick response times, and handle large volumes of data.

Select 1 option(s):

The current project is dealing with social media and has the following requirements.
Required:
• Real-time Twitter feed analysis of posts which contain specific keywords and must be stored as well as processed on MS Azure then displayed using MS Power BI.
Ray and the IT team have put together a list of actions they think need to be performed to meet the needs of the project, but they are not sure on the order to execute. Below is a list of the actions they are considering.
Proposed Actions:
a. Create an HDInsight cluster with the Hadoop cluster type.
b. Create a Jupyter Notebook.
c. Run a job that uses the Spark Streaming API to ingest data from Twitter.
d. Create a Runbook.
e. Create an HDInsight cluster with the Spark cluster type.
f. Create a HVAC table.
g. Load the HVAC table into Power BI Desktop
As you are the Azure SME, Ray and the team look to you for direction on selecting the required items and putting them in the proper order. Which of the below contains the correct items in the correct sequence to meet the requirements?

Select 1 option(s):

Required: Load the data from the Azure Data Lake Gen 2 storage account into the Azure SQL Data Warehouse.
The Avengers IT team has proposed the following solution:
1. Create an external data source pointing to the Azure storage account
2. Create an external file format and external table using the external data source
3. Load the data using the INSERT … SELECT statement
Will the solution proposed by the Avengers IT team meet the requirement?

Select 1 option(s):

Which of the following should you choose?

Select 1 option(s):

Select 1 option(s):

Spark has optimized this operation by using a format called Tungsten which prevents the need for expensive serialization and de-serialization of objects in order to get data from one JVM to another.
The data that is “shuffled” is in a format known as UnsafeRow, or more commonly, the Tungsten Binary Format.
When we shuffle data, it creates what is known as [?].

Select 1 option(s):

Select 1 option(s):

Data classification: Structured
Operations: Read-only, complex analytical queries across multiple databases
Latency & throughput: Some latency in the results is expected based on the complex nature of the queries.
Transactional support: Not required

Select 1 option(s):

Roles such as business stakeholders, business analysts, and business intelligence developers are well known and valuable.
Which of the available roles is best described by:
“Performs advanced analytics to extract value from data. Their work can vary from descriptive analytics to predictive analytics. Descriptive analytics evaluate data through a process known as exploratory data analysis (EDA). They are used in machine learning to apply modelling techniques that can detect anomalies or patterns. These are an important part of forecast models.”

Select 1 option(s):

Select 1 option(s):

Bruce has come to you because his IT team needs advice on the proper type of storage to use for their files in an Azure Storage environment. Due to the various jurisdictions that Wayne Enterprises operates in, there are many compliance regulations which must be followed.
Required:
• A single storage account must be used to store all operations (includes all reads, writes and deletes)
• Retention policy dictates that an on-premises copy must exist for all historical operations
As the contracted expert on Azure, Bruce and the team look to you for direction. Which of the following actions will you recommend to them to meet the requirements?

Select 2 option(s):

Select 1 option(s):

Select 1 option(s):

In order to make use of the Azure-SSIS Integration Runtime, it is assumed that there is SSIS Catalog (SSISDB) deployed on a SQL Server SSIS instance. With that prerequisite met, the Azure-SSIS Integration Runtime is capable of lifting and shifting existing SSIS workloads
During the provisioning of the Azure-SSIS Integration Runtime, which are the options that must be specified? (Select all that apply)

Select 4 option(s):

Which of the following are the limitations of this experience? (Select all that apply)

Select 3 option(s):

Select 1 option(s):

Select 1 option(s):

Which command meets the requirement by specifing a column value in a DataFrame’s filter?

Select 1 option(s):

A transactional database must adhere to the [?] properties to ensure that the database remains consistent while processing transactions.

Select 1 option(s):

Which of the following is best described by:
“A managed Spark as a Service propriety Solution that provides an end to end data engineering/data science platform as a solution. This is of interest for Data Engineers and Data Scientists, working on big data projects daily because it provides the whole platform in which you have the ability to create and manage the big data/data science pipelines/projects all on one platform.”

Select 1 option(s):

1. Private and proprietary
2. For public consumption.
When considering Azure Storage Accounts, which option meet the data diversity requirement?

Select 1 option(s):

Which of the following should be utilized?

Select 1 option(s):

The design decisions around how to split and disperse this data among the nodes and then to the storage is important to querying workloads, as the correct selection minimizes data movement that is a primary cause of performance issues in an Azure Synapse dedicated SQL Pool environment.
Which of the following are valid table distribution types available in Synapse Analytics SQL Pools?

Select 3 option(s):

Microsoft Azure Stream Analytics is an event processing engine. It enables the consumption and analysis of high volumes of streaming data generated by sensors, devices, or applications. [?] processes the data in real time.

Select 1 option(s):

You can use a service-level SAS to allow access to specific resources in a storage account. You’d use this type of SAS, for example, … [?] (Select all that apply)

Select 2 option(s):

Quentin Beck is a team member who has contributor access to the storage account, as well as the application ID access key. One of Quentin’s tasks on his to-do list is to use PolyBase to load data into Azure SQL data warehouse.
Required: Configure PolyBase to connect the data warehouse to the storage account.
Tony has listed out a few items that he thinks Quentin should create to perform the task, but is not sure if they are correct and is not sure of the order of operations needed to complete the requirement successfully.
a. A database encryption key
b. An asymmetric key
c. An external data source
d. An external file format
e. A database scoped credential
Since you are an Azure SME, he looks to you for advice to identify the correct items to create and for you to arrange them in the correct order.
Which of the following identifies the correct items needed in the correct order to fulfill the requirement?

Select 1 option(s):

The act of setting up the database server is called [?].

Select 1 option(s):

As such, locking, and blocking mechanisms are put in place to maintain transactional integrity while providing adequate workload concurrency. These blocking aspects may significantly delay the completion of queries.
To improve the response time, turn [?] the READ_COMMITTED_SNAPSHOT database option for a user database when connected to the master database.

Select 1 option(s):

Select 4 option(s):

Select 1 option(s):

All data within an Azure Cosmos DB container is partitioned based on the [?], and applies to both the transactional store and the analytical store. Boundaries for parallelizing workloads are based on this [?].

Select 1 option(s):

Select 1 option(s):

Azure Synapse Analytics can work by acting as the one stop shop to meet all of your analytical needs in an integrated environment.
You can develop big data engineering and machine learning solutions using [?]. You can take advantage of the big data computation engine to deal with complex compute transformations that would take too long in a data warehouse.

Select 1 option(s):

Azure Data Lake Storage Gen2 provides a first-class data lake solution that enables enterprises to consolidate their data.
Along with role-based access control (RBAC), Azure Data Lake Storage Gen2 provides [?] that are POSIX-compliant, and that restrict access to only authorized users, groups, or service principals. It applies restrictions in a way that’s flexible, fine-grained, and manageable.

Select 1 option(s):

Which type of security would typically be best used in for this scenario?

Select 1 option(s):

Select 1 option(s):

Security and infrastructure configuration go hand-in-hand. When you set up your Azure Databricks workspace(s) and related services, you need to make sure that security considerations do not take a back seat during the architecture design.
When enabled, authentication automatically takes place in Azure Data Lake Storage (ADLS) from Azure Databricks clusters using the same Azure Active Directory (Azure AD) identity that one uses to log into Azure Databricks. Commands running on a configured cluster will be able to read and write data in ADLS without needing to configure service principal credentials. Any ACLs applied at the folder or file level in ADLS are enforced based on the user’s identity.
ADLS Passthrough is configured when you create a cluster in the Azure Databricks workspace. On a standard cluster, when you enable this setting … [?]

Select 1 option(s):

Which of the following are valid options for transforming data within Azure Data Factory? (Select three)

Select 3 option(s):

Stream Analytics can route job output to which of the following storage systems? (Select all that apply)

Select 4 option(s):

Select 1 option(s):

The company has 10,000 employees. Most employees are located in Europe. The company supports teams worldwide.
AIM has two main locations: a main office in London, England, and a manufacturing plant in Berlin, Germany.
At the moment, you are leading a Workgroup meeting with the IT Team where the topic of discussion is the implementation of a process which copies data from an instance on the company’s on-prem MS SQL Server to Azure Blob storage.
Required:
• The process must orchestrate and manage the data lifecycle.
• Configuration of Azure Data Factory to connect to the SQL Server instance.
Several ideas have been tabled as action items, which are listed below:
a. Configure a linked service to connect to the SQL Server instance.
b. From the on-prem network, install and configure a self-hosted runtime.
c. From the SQL Server, backup the database and then copy the database to Azure Blob storage.
d. Deploy and Azure Data Factory.
e. From the SQL Server, create a database master key.
The IT Team looks to you as for direction as the Azure SME and you need to advise them on which of the ideas tabled, need to be executed and in which order.
Which of the following calls for the correct action items in the correct order?

Select 1 option(s):

Which of the following are valid dependency conditions? (Select four)

Select 4 option(s):

Select 1 option(s):

Select 5 option(s):

Microsoft Azure Storage is a managed service that provides durable, secure, and scalable storage in the cloud. The Azure Queue service is used to store and retrieve messages. Queue messages can be up to [A] KB in size, and a queue can contain millions of messages. Queues are used to store lists of messages to be processed [B].

Select 1 option(s):

Azure Data Factory provides a variety of methods for ingesting data, and also provides a range of methods to perform transformations.
These methods are:
• Mapping Data Flows
• Compute Resources
• SSIS Packages
Mapping Data Flows provides a number of different transformations types that enable you to modify data. They are broken down into the following categories:
• Schema modifier transformations
• Row modifier transformations
• Multiple inputs/outputs transformations
Some of the transformations that you can define have a(n) [?] that will enable you to customize the functionality of a transformation using columns, fields, variables, parameters, functions from your data flow in these boxes. To build the expression, use the [?], which is launched by clicking in the expression text box inside the transformation. You’ll also sometimes see “Computed Column” options when selecting columns for transformation.

Select 1 option(s):

Which feature commits the changes of Azure Data Factory work in a custom branch created with the main branch in a Git repository?

Select 1 option(s):

Which are they? (Select four)

Select 4 option(s):

Select 1 option(s):

Which of the following fit this description? (Select all that apply)

Select 4 option(s):

Select 1 option(s):

Required: Implement an Azure SQL Database elastic pool to minimize cost.
Which option or options should you recommend to the Avengers IT team to configure?

Select 1 option(s):

Which is the best authentication method to use?

Select 1 option(s):

When you expand Pipelines you will see which of the following? (Select three)

Select 3 option(s):

Select 1 option(s):

Select 1 option(s):

Which of the following are valid Strategies for managing source data files? (Select all that apply)

Select 3 option(s):

Select 1 option(s):

Select 3 option(s):