Data Engineering on Microsoft Azure Test 10

Select 2 option(s):

Which tool should you choose?

Select 1 option(s):

The Azure Synapse SQL query language supports different features based on the resource model being used.
Which of the below have support in both relational and non-relational data types? (Select all that apply)

Select 6 option(s):

Select 4 option(s):

Select 6 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.
[?] offers both serverless and dedicated resource models to work with both descriptive and diagnostic analytical scenarios. This is a distributed query system that enables you to implement data warehousing and data virtualization scenarios using standard T-SQL.

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.
With regards to the Workspace to VNet ratio, Microsoft recommends … [?]

Select 1 option(s):

Which of the following allow programmatic interaction with Azure Data Factory?

Select 5 option(s):

Select 1 option(s):

Which of the following is best described by:
“An implementation by Microsoft of Open Source Spark, managed on the Azure Platform. You can use this for a spark environment when you are aware of the benefits of Apache Spark in its OSS form, but you want an SLA. Usually this is of interest to Open Source Professionals needing an SLA as well as Data Platform experts experienced with Microsoft.”

Select 1 option(s):

Which of the following should you choose?

Select 1 option(s):

These three IR types are:
• Azure
• Self-hosted
• Azure-SSIS
Which does not have Private network support?

Select 1 option(s):

Setting Global parameters in an Azure Data Factory pipeline … [?]

Select 1 option(s):

Within an Apache Spark Pool it is possible to configure a fixed size when you disable autoscaling. When you enable autoscale, you can set a minimum and maximum number of nodes in order to control the scale that you’d like. Once you have enabled autoscale, Synapse Analytics will monitor the resource load.
It will continuously monitoring CPU usage, pending memory, free CPU, free memory, and the used memory per node for scaling decisions. It checks these metrics every [?] seconds and makes scaling decisions based on the values.

Select 1 option(s):

Select 1 option(s):

By default, how long are the Azure Data Factory diagnostic logs retained for?

Select 1 option(s):

Data classification: Unstructured
Operations:
• Only need to be retrieved by ID.
• Customers require a high number of read operations with low latency.
• Creates and updates will be somewhat infrequent and can have higher latency than read operations.
Latency & throughput: Retrievals by ID need to support low latency and high throughput. Creates and updates can have higher latency than read operations.
Transactional support: Not required

Select 1 option(s):

Select 1 option(s):

[?] describes the final cost of owning a given technology. In on-premises systems, [?] includes the following costs:
• Hardware
• Software licensing
• Labour (installation, upgrades, maintenance)
• Datacentre overhead (power, telecommunications, building, heating and cooling)

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 the following:
“Provisions and sets up data platform technologies that are on-premises and in the cloud. They manage and secure the flow of structured and unstructured data from multiple sources. The data platforms they use can include relational databases, nonrelational databases, data streams, and file stores. They ensure that data services securely and seamlessly integrate with other data platform technologies or application services such as Azure Cognitive Services, Azure Search, or even bots.”

Select 1 option(s):

From a high level, the Azure Databricks service launches and manages Apache Spark clusters within your Azure subscription. Apache Spark clusters are groups of computers that are treated as a single computer and handle the execution of commands issued from notebooks.
Microsoft Azure manages the cluster, and [?]

Select 1 option(s):

Select 1 option(s):

Select 4 option(s):

Select 1 option(s):

Apache Spark is an open-source distributed system that is used for processing big data workloads.
To achieve this capability, … [?]

Select 1 option(s):

Select 4 option(s):

Select 1 option(s):

Which component is best described by:
“It has information on the different data sources and Data Factory uses this information to connect to data originating sources. It is mainly used to locate the data stores in the machines and also represent the compute services for the activity to be executed, such as running spark jobs on spark clusters or running hive queries using hive services from the cloud.”

Select 1 option(s):

The following steps are required when implementing data ingestion and transformation using the collective capabilities of Azure Data Factory and Azure Databricks.
The order of the below steps has been shuffled.
a. Perform analysis on data
b. Create Azure storage account
c. Create data workflow pipeline
d. Create an Azure Data Factory
e.  Add Databricks notebook to pipeline
Select the correct step order from the below.

Select 1 option(s):

Scenario: You have created a storage account name using a standardized naming convention within your department.
Your teammate is concerned with this practice because the name of a storage account must be [?].

Select 1 option(s):

What should his answer be?

Select 1 option(s):

SQL
COPY INTO dbo.[lineitem] FROM ‘https://unsecureaccount.blob.core.windows.net/customerdatasets/folder1/lineitem.csv’
What is this code created to do?

Select 1 option(s):

Select 1 option(s):

Azure Cosmos DB analytical store is a fully isolated column store for enabling large-scale analytics against operational data in your Azure Cosmos DB, without any impact to your transactional workloads.
There are two schema representation modes for data stored in the analytical store.
• For SQL (Core) API accounts, when analytical store is enabled, the default schema representation in the analytical store is [A].
• For Azure Cosmos DB API for MongoDB accounts, the default schema representation in the analytical store is [B].

Select 1 option(s):

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

Select 1 option(s):

[?] logs every operation Azure Storage account activity in real time, and you can search the logs for specific requests. Filter based on the authentication mechanism, the success of the operation, or the resource that was accessed.

Select 1 option(s):

[?] data is typically stored in a relational database such as SQL Server or Azure SQL Database.

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

What does unstructured mean?

Select 1 option(s):

Is Azure Blob storage a good choice for this data?

Select 1 option(s):

From a high level, the Azure Databricks service launches and manages Apache Spark clusters within your Azure subscription. Apache Spark clusters are groups of computers that are treated as a single computer and handle the execution of commands issued from notebooks.
In Databricks, the notebook interface … [?]

Select 1 option(s):

Data flow activities can be operationalized via which of the following? (Select four)

Select 4 option(s):

Which component is best described by:
“It is a specific action performed on the data in a workflow like the transformation or ingestion of the data. Each workflow can have one or more of these in it.”

Select 1 option(s):

There are two ways to create a wrangling data flow in Azure Data Factory.
• Click the plus icon and select Data Flow in the factory resources pane.
• In the activities pane of the pipeline canvas, open the Move and Transform accorskillcertpro and drag the Data flow activity onto the canvas.
In both methods, in the side pane that opens, select Create new data flow and choose Wrangling data flow. Click OK.
Once you have selected a source, then clicked on create, what is the result?

Select 1 option(s):

Azure Cosmos DB supports 99.999 percent uptime. You can invoke a regional failover by using programming or the Azure portal. An Azure Cosmos DB database will automatically failover if there’s a regional disaster.
By using multimaster replication in Azure Cosmos DB, you can often achieve a response time of less than 1 second from anywhere in the world. Azure Cosmos DB is guaranteed to achieve a response time of less than [?] for reads and writes.

Select 1 option(s):

When is it unnecessary to use import statements for transferring data between a dedicated SQL and Spark pool?

Select 1 option(s):

Which of the following is a benefit of to parameterizing a linked service in Azure Data Factory?

Select 1 option(s):

To facilitate faster load times, you can create a workload classifier for the load user with … [?]

Select 1 option(s):

Video 1: business-critical; requires a replication policy that creates multiple copies across geographically diverse datacentres
Video 2: non-business-critical; local replication policy is sufficient
Which of the following options would satisfy both data diversity and cost sensitivity consideration?

Select 1 option(s):

Select 3 option(s):

Which option should you configure when creating the storage account?

Select 1 option(s):

There are two control knobs of a shuffle that can used to optimize.
Which are these options? (Select two)

Select 2 option(s):

In order to bring data to a notebook, you have several options.
It is possible to load data from which of the following?

Select 3 option(s):

Azure Synapse SQL enables you to implement data warehouse solutions, or to perform data virtualization.
[?] enables ad hoc data preparation scenarios, where organizations are wanting to unlock insights from their own data stores without going through the formal processes of setting up a data warehouse.

Select 1 option(s):

Select 4 option(s):

Statistics in a serverless SQL pool have the same objective of using a cost-based optimizer to choose an execution plan that will execute the fastest. How it creates the statistics is different.
True or False: In a serverless SQL pool, if statistics are missing, the query optimizer creates statistics on entire tables in the query predicate or join condition to improve cardinality estimates for the query plan.

Select 1 option(s):

Select 1 option(s):

• Choose the data abstraction
• Use the optimal data format
• Use the cache option
• Check the memory efficiency
• Use Bucketing
• Optimize Joins and Shuffles if appropriate
• Optimize Job Execution
If you did decide to use bucketed tables, which of the following are recommended practices? (Select all that apply)

Select 3 option(s):

Azure Databricks (ADB) is a Big Data analytics service. Being a Cloud Optimized managed PaaS offering, it is designed to hide the underlying distributed systems and networking complexity as much as possible from the end user.
Multiple clusters can exist within a workspace, and there’s a one-to-many mapping between a Subscription to Workspaces, and further, from one Workspace to multiple Clusters.
Azure Databricks is a multitenant service and to provide fair resource sharing to all regional customers, it imposes limits on API calls. These limits are expressed at the Workspace level and are due to internal ADB components.
Key workspace limits are:
• The maximum number of jobs that a workspace can create in an hour is [A]
• At any time, you cannot have more than [B] jobs simultaneously running in a workspace
• There can be a maximum of [C] notebooks or execution contexts attached to a cluster
• There can be a maximum of [D] Azure Databricks API calls/hour

Select 1 option(s):

Which of the following are valid data integration capabilities? (Select four)

Select 4 option(s):

Which service ensures that the client has the permissions required to access the data.

Select 1 option(s):

True or False: You can only enable analytical store at the time of creating a new container.

Select 1 option(s):

Azure Synapse Analytics is an integrated analytics platform, which combines data warehousing, big data analytics, data integration, and visualization into a single environment. Azure Synapse Analytics empowers users of all abilities to gain access and quick insights across all of their data, enabling a whole new level of performance and scale.
Azure Synapse Analytics enables you to answer the question … [?]

Select 1 option(s):

In the Azure Portal you can use the Pause command within the dedicated SQL pool and within Azure Synapse Studio, in the [?] hub which allows you to enable it, and set the number of minutes idle.

Select 1 option(s):