When should you use Azure Synapse Analytics?

To perform very complex queries and aggregations

To create dashboards from tabular data

To enable large number of users to query analytics data

What is the purpose of data ingestion?

To capture data flowing into a data warehouse system as quickly as possible

To perform complex data transformations over data received from external sources

To visualize the results of data analysis

What is the primary difference between a data lake and a data warehouse?

A data lake holds raw data, but a data warehouse holds structured information.

A data lake contains structured information, but a data warehouse holds raw business data.

Data stored in a data lake is dynamic, but information stored in a data warehouse is static.

When might you use PolyBase?

To query data from external data sources from Azure SQL Database

To ingest streaming data using Azure Databricks

To orchestrate activities in Azure Data Factory

You have a large amount of data held in files in Azure Data lake storage. You want to retrieve the data in these files and use it to populate tables held in Azure Synapse Analytics. Which processing option is most appropriate?

Use Azure Synapse Link to connect to Data Lake storage and download the data

In Azure Databricks how do you change the language a cell uses?

The first line in the cell is %language. For example, %scala

Change the notebook language before writing the commands

Wrap the command in the cell with ##language##

What is the common flow of activity in Power BI?

Bring data into Power BI desktop and create a report, share it to the Power BI service, view and interact with the reports and dashboards in the service and Power BI mobile.

Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service.

Create a report in the Power BI service, share it to Power BI mobile, interact with it in the Power BI Desktop.

Which of the following are building blocks of Power BI?

Visualizations, datasets, reports, dashboards, tiles

Tiles, dashboards, databases, mobile devices

Visual Studio, C#, and JSON files

Which of the following is an example of unstructured data?

An Employee table with columns Employee ID, Employee Name, and Employee Designation

A table within SQL Server database

Which of the following is an example of streaming dataset?

List of employees working for a company

Which of the following tasks is a role of a database administrator?

Backing up and restoring databases

Creating dashboards and reports

Identifying data quality issues

Which one of the following statements is a characteristic of a relational database?

A row in a table represents a single entity

All data must be stored as character strings

Different rows in the same table can contain different columns

A structure enable you to locate rows in a table quickly, using an indexed value

A virtual table based on the result set of query

A structure comprising rows and columns that you use for storing data

Which one of the following statements is a benefit of using PaaS service, instead of an on-premises system to run your database management systems?

Increased day-to-day management costs

Which of the following is a characteristic of non-relational databases?

Non-relational databases are either schema free or have relaxed schemas

Non-relational databases contain tables with flat fixed-column records

Non-relational database require you to use data normalization techniques to reduce data duplication

You are building a system that monitors the temperature throughout a set of office blocks, and sets the air conditioning in each room in each block to maintain a pleasant ambient temperature. Your system has to manage the air conditioning in several thousand buildings spread across the country or region, each building typically contains at least 100 air-conditioned rooms. What type of NoSQL data store is most appropriate for capturing the temperature data to enable it processed quickly?

Write the temperature to a blob in Azure Blob storage

What is data ingestion?

Capturing raw data streaming from various sources and storing it

The process of transforming raw data into models containing meaningful information

Which deployment requires the fewest changes when migrating an existing SQL Server on-premises solution?

SQL Sever running on a virtual machine

Azure SQL Database Managed Instance

Azure SQL Database Single Database

Which of the following statements is true about SQL Server running on a virtual machine?

You're responsible for all software installation and maintenance, and performing backups

You must install and maintain the software for the database management system yourself, but backups are automated

Software installation and maintenance are automated, but you must do your own backups

Which of the following statement is true about Azure SQL Database?

Scaling up or out will take effect without restarting the SQL database

Scaling up doesn't take effect until you restart your database

Scaling out doesn't take effect until you restart your database

When using an Azure SQL Database managed instance, what is the simplest way to implement backups?

Backups are automatically handled

Manual Configuration of the SQL server

Create a scheduled task to back up

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

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

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

When should you use a block blob, an when you should use a page blob?

Use a page block for blobs that require random read and write access. Use a block blob for discrete objects that change infrequently

Use a block blob for unstructured data that requires random access to perform reads and writes. Use a page blob for discrete objects that rarely change

Use a block blob for active data stored using the Hot data access tier, and a page blob for data stored using the Cool or Archived data access tiers

Why might you use Azure File storage?

To enable users at different sites to share files

To share files that are stored-on premises with users located at other sites

To store large binary data files containing images of other unstructured data

You are building a system that monitors the temperature throughout a set of office blocks, and sets the air conditioning in each room in each block to maintain a pleasant ambient temperature. Your system has to manage the air conditioning in several thousand buildings spread across the country or region, each building typically contains at least 100 air-conditioned rooms. What type of NoSQL data store is most appropriate for capturing the temperature data to enable it processed quickly?

Send the data to an Azure Cosmos DB database and use Azure Functions to process the data

Store the data in a file stored in a share created using Azure File Storage

Write the temperatures to a blob in Azure Blob storage.

What is provisioning?

The act of running series of tasks that a service provider performs to create and configure a service

Providing other users access to an existing service

Tuning a service to improve performance

Azure Data Fundamentals Review

Authored by Ma.Teresa Tango

Computers

Professional Development

Used 49+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

141 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A database object that holds data.

Index

View

Table

Heap

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A database object whose content is defined by a query.

Index

View

Table

Heap

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A database object that helps improve the speed of data retrieval.

Index

View

Table

Heap

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A relational database must be used when

A dynamic schema is required

Data will be stored in key/value pairs.

Storing large images and videos

Strong consistency guarantees are required.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Azure HDInsight

SQL Server on Azure virtual machines

Azure Cosmos DB

Azure SQL Database

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Azure Resource Manager is a JSON file that describes the architecture of your project.

True

False

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

It refers to the public web-based interface for management of Azure platform.

Azure Portal

Azure PowerShell

Azure CLI

Azure Cloud Shell

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

142 questions

Từ vựng bổ sung EXCEL

Quiz

•

Professional Development

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

29 questions

Alg. 1 Section 5.1 Coordinate Plane

Quiz

•

9th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

11 questions

FOREST Effective communication

Lesson

•

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Computers

15 questions

LOTE_SPN2 5WEEK3 Day 2 Itinerary

Quiz

•

Professional Development

20 questions

Black History Month Trivia Game #1

Quiz

•

Professional Development

20 questions

90s Cartoons

Quiz

•

Professional Development

42 questions

LOTE_SPN2 5WEEK2 Day 4 We They Actividad 3

Quiz

•

Professional Development

6 questions

Copy of G5_U6_L3_22-23

Lesson

•

KG - Professional Dev...

20 questions

Employability Skills

Quiz

•

Professional Development

Azure Data Fundamentals Review

A database object that holds data.

A database object whose content is defined by a query.

A database object that helps improve the speed of data retrieval.

A relational database must be used when

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

Azure Resource Manager is a JSON file that describes the architecture of your project.

It refers to the public web-based interface for management of Azure platform.

It is designed for self-service, customizable and simple tasks.

It is a set of commands used to create and manage Azure resources that is available across Azure services and is designed to get you working quickly with Azure, with an emphasis on automation especially if you are working in Linux.

It is a set of cmdlets for managing Azure resources that provides powerful features for automation especially for those working in Windows although it is also supported in Linux and MacOS.

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers