You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?

Online Transaction Processing (OLTP)

Online Analytical Processing (OLAP)

For each of the following statements, select all that are true?

Azure Databricks is based on apache spark

Azure Data Studio can be used to restore Database

Azure Data Studio can be used to query an Azure SQL database from a device that run on macOS

Sql Server Management Studio (SSMS) enable users to create and use SQL Noteboooks

Select all that is True

An Azure Data Factory pipeline can pass parameters to a notebook ?

Databricks can process data held in many different types of storage, including Azure Blob storage, Azure Data Lake Store, Hadoop storage, flat files, SQL databases, and data warehouses, and Azure services such as Cosmos DB ?

Imagine that you're part of a team that is analyzing house price data. The dataset that you receive contains house price information for several regions. Your team needs to report on how the house prices in each region have varied over the last few months. To achieve this, you need to ingest the data into Azure Synapse Analytics. You've decided to use Azure Datawarehouse to perform this task.

Select the correct answer

Prevent access to an SQL database from another network - FirewallSupport Azure Active Directory sign ins - Authentication Ensure that sensitive data never appears as plain text in Azure SQL database - Encryption

Prevent access to an SQL database from another network - EncryptionSupport Azure Active Directory sign ins - Authentication Ensure that sensitive data never appears as plain text in Azure SQL database - Firewall

Prevent access to an SQL database from another network - Firewall Support Azure Active Directory sign ins - Authorization Ensure that sensitive data never appears as plain text in Azure SQL database - Encryption

Which among the following statement(s) is/are true with respect to Azure SQL database?

You can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases.

You need a Microsoft 365 subscription to create an Azure SQL Database

You must apply patches to the Azure SQL Databases regularly

In a Azure Data factory pipeline, you can use an ___________ activity to run an operation to modify and filter data, or an _________________ activity to run a notebook that performs more advanced processing.

Azure Function, Azure Databricks Notebook

Azure Function, Azure Data Studio SQL Notebook

Azure Logic app, Azure Databricks Notebook

Azure Logic app, Azure Data Studio SQL Notebook

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database. Which type of authentication would you use?

Azure Active Directory (Azure AD) authentication

service principal authentication

You have a transactional workload running on a relational database system. You need to remove all DML anomalies which hamper the integrity of the databases. What would you do in such a scenario?

Normalize the tables as much as possible

De-normalize the tables as much as possible

Remove relationships in the tables

Which of the following best defines 'relation'?

A column in a relational table.

A row in a non-relational table.

Which of the following is not the property of Azure Cosmos DB ?

Run the stored procedure for an infinite time period

Elastically scalable throughput and storage

What is correct hierarchy structure for the Azure Storage Account having blobs, container, files in it ? Example : Resource Group -> Azure Storage Account (This statement means that Azure Storage Account is inside the Resource Group) What will be the correct hierarchy among Azure Resources ?

Resource Group -> Azure Storage Account -> Container -> Blob

Azure Storage Account -> Data Lake Storage -> Blob -> Container

Resource Group -> Data Lake Storage -> Container -> Blob

Data Lake Storage – >Azure Storage Account -> Blob -> Container

The data engineering team manages Azure HDInsight clusters. The team spends a large amount of time creating and destroying clusters daily because most of the data pipeline process runs in minutes. You need to implement a solution that deploys multiple HDInsight clusters with minimal effort. What should you implement?

Azure Resource Manager templates

Azure Pipelines Azure Data factory

Which tool provides a graphical user interface for managing many different database systems without logging in each and every other system?

SSMS (SQL Studio Management System)

Microsoft Azure Storage Explorer

You have an Azure Storage account and an Azure SQL data warehouse by using Azure Data Factory. The solution must meet the following requirements: 1. Ensure that the data remains in the UK West region at all times. 2. Minimize administrative effort. Which type of integration runtime should you use?

Self-hosted integration runtime

A company stores data in multiple types of cloud-based databases. You need to design a solution to consolidate data into a single relational database. Ingestion of data will occur at set times each day. What should you recommend?

Azure Database Migration Service

You are creating a new notebook in Azure Databricks that will support R as the primary language but will also support Scala and SQL. Which switch should you use to switch between languages?

Change the language at the time of creation of notebook

Select all that is TRUE:

While ingesting data from Azure Data Lake storage across azure regions you will incur cost for bandwidth

You implement data lake storage by creating an Azure Storage Account

You can use Blob, File and Table storage in the same Azure Storage Account

You are designing a data storage solution for a database that is expected to grow to 50 TB. The usage pattern is singleton inserts, singleton updates, and reporting. Which storage solution should you use?

Azure SQL Database elastic pools

Azure Cosmos DB that uses the Gremlin API

Sending cloud infrastructure metadata every 30 minutes is an example of a streaming workload? Select " No change needed " if the above statement is correct, otherwise select the correct answer.

sending telemetry data from edge devices

sending transactions that are older than a month to an archive

sending transactions daily from point of sale (POS) devices

You are monitoring an Azure Steam Analytics job by using metrics in Azure Stream Analytics job by using metrics in Azure. You discover that during the last 12 hours, the average watermark delay is consistently greater than the configured late arrival tolerance. What can be the reason?

The job lacks the resources to process the volume of incoming data

The late arrival policy causes events to be dropped

Events whose application timestamp is earlier than their arrival time by more than five minutes arrive as inputs

There are errors in the input data

You have data stored in Azure Storage and want to ensure that the data is resilient to region outage. Which of the following 2 replication options would you select

Read-access-geo-redundant storage

You need to collect applications metrics, streaming query events, and application log messages for an Azure Databricks cluster. What type of library should you implement?

Azure Databricks Monitoring Library

Microsoft Azure Management Monitoring Library

Select the correct options

Enables the use of SQL queries against data stored in JSON documents - Cosmos DB Enables users to access data using the Server Message Block(SMB) version3 protocol - Azure Files

Enables the use of SQL queries against data stored in JSON documents - Azure Table StorageEnables users to access data using the Server Message Block(SMB) version3 protocol - Azure Files

Enables the use of SQL queries against data stored in JSON documents - Cosmos DB Enables users to access data using the Server Message Block(SMB) version3 protocol - Azure Blob Storage

In the context of a relational database, " schema " is The structure of the database including table names, column names, data types, indexes, and other database structure definitions Select " No change needed " if the above statement is correct, otherwise select the correct answer.

The data type assigned to each column such as string, integer, boolean, etc

The data stored in the database

The physical files the database is stored in at the storage level

You have an Azure database access. You recently changed your external IP address After changing the IP address, you are no longer able to access the storage What could be the cause?

Dynamic Host Configuration Protocol

collect data and then process when a condition is met

collect and process data at most daily

process data in memory row by row

Which of the following are common characteristics of a data warehouse? Select two correct options.

Supports massive amounts of data

Database optimized for reading by being denormalized

Significant pre-processing happens on the data before it can be used for reporting

D900_2

Quiz

•

Computers

•

1st - 5th Grade

•

Practice Problem

•

Easy

Edgar Martínez

Used 9+ times

FREE Resource

50 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which component of an Azure Data Factory can be triggered to run data ingestion tasks?

CSV File

Pipeline

Linked service

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Review the data model and answer following question:

The data model is:

star schema

transactional model

snowflake scheme

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of these services can be used to ingest data into Azure Synapse Analytics?

Azure Data Factory

Power BI

Azure Active Directory

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Review the data model and answer the following:

Product is an example of ----------- table

dimension

fact

bridge

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You have an inventory management database. Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

INSERT

MERGE

UPDATE

CREATE

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Transcribing an audio file is an example of:

predictive

prescriptive

descriptive

cognitive

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A bar chart showing year-to date sales by region is an example of which type of analytics?

descriptive

diagnostic

predictive

prescriptive

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

50 questions

ASK T1 BAB 3

Quiz

•

1st Grade

50 questions

CAT - Gr 10 - Hardware & Software

Quiz

•

KG - University

50 questions

Quiz Latihan Soal-Soal UTS Pengantar Organisasi Komputer

Quiz

•

KG - University

50 questions

pangkalan data lanjutan tingkatan 5

Quiz

•

1st Grade - University

50 questions

HTML,CSS

Quiz

•

3rd Grade - University

50 questions

Quiz 1 Digital Literacy, Careers in IT, Information Technology

Quiz

•

2nd Grade

45 questions

Reading Comprehension

Quiz

•

5th Grade

45 questions

IC3 - Spark - CF - GMetrix - 2

Quiz

•

1st - 5th Grade

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

10 questions

Introduction to Coding

Interactive video

•

3rd - 6th Grade

D900_2

50 questions

Which component of an Azure Data Factory can be triggered to run data ingestion tasks?

Review the data model and answer following question:The data model is:

Which of these services can be used to ingest data into Azure Synapse Analytics?

Review the data model and answer the following:Product is an example of ----------- table

You have an inventory management database. Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

Transcribing an audio file is an example of:

A bar chart showing year-to date sales by region is an example of which type of analytics?

You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?

For each of the following statements, select all that are true?

Select all that is True

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

Review the data model and answer following question:

The data model is:

Review the data model and answer the following:

Product is an example of ----------- table