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

Azure SQL Database has built in high availability

Azure SQL Database includes a fully managed backup service

Azure SQL Database allows independent provisioning of throughput and storage

Azure SQL Database is fully compatible with Microsoft SQL server

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service would you use?

SQL Server on Azure virtual machines

You need to recommend a security solution for containers in Azure Blob storage. The solution must ensure that only read permissions are granted to a specific user for a specific container. What should you include in the recommendation?

an RBAC role in Azure Active Directory (Azure AD)

public read access for blobs only

Your manager asked to create Azure Data Lake Store so that data can be used to querying further, how will you create Azure Data Lake Store in Azure Portal ? Which is the correct way to create Storage Account.

Create an Azure Storage Account and then enable the Azure Data Lake radio button while configuring Azure Data Factory.

Add a resource and then search for Azure Data Lake Store , then create it.

Create an Azure Data Factory and then enable the Azure Data Lake radio button while configuring Azure Data Factory.

Add a resource and then search Azure Data Lake Analytics and then create it.

A company plans to use Platform-as-a-Service (PaaS) to create the new data pipeline process. The process must meet the following requirements: 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.

HDInsights Apache Storm cluster

You are developing the data platform for a global retail company. The company operates during normal working hours in each region. The analytical database is used once a week for building sales projections. Each region maintains its own private virtual network. Building the sales projections is very resource intensive are generates upwards of 20 terabytes (TB) of data. Microsoft Azure SQL Databases must be provisioned. – Database provisioning must maximize performance and minimize cost –The daily sales for each region must be stored in an Azure SQL Database instance –Once a day, the data for all regions must be loaded in an analytical Azure SQL Database instance You need to provision Azure SQL database instances. Select the right option. 1. Azure SQL Database elastic pools 2. Azure SQL Database Hyperscale 3. Azure SQL Database Premium 4. Azure SQL Database Managed Instance

Weekly Analysis - Azure SQL Database Hyperscale Daily Analysis - Azure SQL Database elastic pools Weekly

Analysis - Azure SQL Database Premium Daily Analysis - Azure SQL Database Managed Instance

Weekly Analysis - Azure SQL Database elastic pools Daily Analysis - Azure SQL Database Hyperscale

A company manages several on-premises Microsoft SQL Server databases. You need to migrate the databases to Microsoft Azure by using a backup process of Microsoft SQL Server. Which data technology should you use?

Azure SQL Database Managed Instance

Azure SQL Database single database

You need to recommend a storage solution for a sales system that will receive thousands of small files per minute. The files will be in JSON, text, and CSV formats. The files will be processed and transformed before they are loaded into a data warehouse in Azure Synapse Analytics. The files must be stored and secured in folders. Which storage solution should you recommend?

Azure SQL Database Azure Blob storage

Below are the statements given you need to identify if the statements which are correct ?

Azure SQL managed instance supports user created backup

Azure SQL managed instance supports cross db Queries

Azure SQL managed instance backups can be restore to sql server running on vm in azure

Azure analysis services can be used for transactional workloads

You have a transactional application that stores data in an Azure SQL managed instance. When should you implement a read-only database replica?

You need to generate reports without affecting the transactional workload.

You need to audit the transactional application.

You need to implement high availability in the event of a regional outage.

You need to improve the recovery point objective (RPO).

Fill in the blanks. Batch workloads --------------------------

collect data and process data when a condition is met

process data in memory, row by row

collect and process data at most once a day

process data as new data is received real time

Azure Synapse Analytics is used to ----------------

perform very complex queries and aggregations

enable large number of users to query analytics data

create dashboards from tabular data

Expenses Table: From the Expense table above, your manager asked you to write a SQL query to get the below results: Select the right query which fills the boxes

SELECT DATE, AmountFrom Expenses GROUP BY Date;

SELECT ExpenseType, AmountFrom Expenses GROUP BY ExpenseType;

SELECT DATE, AmountFrom Expenses GROUP BY ExpenseType;

SELECT ExpenseType, AmountFrom Expenses GROUP BY Date;

You need to insert a new JSON document into a Cosmos DB database, but there's a problem. All the previous customers have a valid name, and the data you are attempting to insert doesn't have it. What happens when you attempt to add a JSON document that is missing a field that other documents all have?

NoSQL databases support not providing all properties with every record. The insert will succeed

You must provide all properties and the insert will fail

Cosmos DB will add the missing property to the document with a default value or null if no default exists

What is the best way to transfer the data in a PostgreSQL database running on-premises into a database running Azure Database for PostgreSQL service?

Use the Azure Database Migration Services

Upload a PostgreSQL database backup file to the database running in Azure

Export the data from the on-premises database and import it manually into the database running in Azure

D900_5

Authored by Edgar Martínez

Computers

1st - 5th Grade

Used 12+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

50 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Descriptive analytics tells you:

what is most likely to happen in the future

what occurred in the past

which actions you can perform to affect outcomes

why something occurred in the past

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

An ETL Process requires

a matching schema in the data source and data target

a target data store powerful enough to transform the data

data that is fully processed before being loaded in the target data store

that the target store be relational data store

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Relational databases use ---------- to enforce relationship among tables

keys

columns

partitions

collections

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A virtual table that defines content defined by a query

index

views

heap

stored procedure

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Select the correct option:

A database object that holds data - Table

A database object whose content is defined by a query -View

A database object that helps to improve the speed of data retrieval- Index

A database object that holds data - ViewA

database object whose content is defined by a query -Table

A database object that helps to improve the speed of data retrieval- Index

A database object that holds data - View

A database object whose content is defined by a query -Index

A database object that helps to improve the speed of data retrieval- Table

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Select all that is TRUE

You can use Microsoft SQL Server Management Studio (SSMS) to query an Azure Synapse Analytics

You can use Azure Data Studio to query Microsoft SQL server big data cluster

You can use MYSQL workbench to query Azure Databases with Maria DB

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Select the correct option for data stores and appropriate scenarios:

Application users and their default language - key value

Medical Image and their associated metadata - Object

Employee data that shows relationship between employees - Graph

Application users and their default language - Object

Medical Image and their associated metadata - key value

Employee data that shows relationship between employees - Graph

Application users and their default language - Object

Medical Image and their associated metadata - Graph

Employee data that shows relationship between employees - key value

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

47 questions

ICT P4 2nd Term Final Revision Elmotamayez P1

Quiz

•

4th Grade

55 questions

TIK KELAS 4 - ALMARJAN - PAK MANARUL

Quiz

•

4th Grade

55 questions

IC3-LV2-CHỦ ĐỀ 1: CĂN BẢN VỀ CÔNG NGHỆ (Phần 1)

Quiz

•

4th Grade

50 questions

Computer basics

Quiz

•

5th - 9th Grade

51 questions

Parts of computer

Quiz

•

KG - 2nd Grade

47 questions

Modele sieci komputerowych (47)

Quiz

•

1st - 6th Grade

50 questions

Grade 5 IT Quiz

Quiz

•

5th Grade - University

50 questions

Test Wiedzy o Bezpieczeństwie w Internecie IV-VI (zał. nr 3)

Quiz

•

4th - 6th Grade

Popular Resources on Wayground

7 questions

History of Valentine's Day

Interactive video

•

4th Grade

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

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Computers

7 questions

History of Valentine's Day

Interactive video

•

4th Grade

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

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

D900_5

Descriptive analytics tells you:

An ETL Process requires

Relational databases use ---------- to enforce relationship among tables

A virtual table that defines content defined by a query

Select the correct option:

Select all that is TRUE

Select the correct option for data stores and appropriate scenarios:

Which two settings can you configure at the container level? Each correct answer presents a complete solution. (Choose two.)
NOTE: Each correct selection is worth one point.

You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.
Which storage tier should you use?

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

D900_5

Descriptive analytics tells you:

An ETL Process requires

Relational databases use ---------- to enforce relationship among tables

A virtual table that defines content defined by a query

Select the correct option:

Select all that is TRUE

Select the correct option for data stores and appropriate scenarios:

Which two settings can you configure at the container level? Each correct answer presents a complete solution. (Choose two.)NOTE: Each correct selection is worth one point.

You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.Which storage tier should you use?

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

Which two settings can you configure at the container level? Each correct answer presents a complete solution. (Choose two.)
NOTE: Each correct selection is worth one point.

You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.
Which storage tier should you use?