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

A virtual table based on the result set of a query

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

Which one of the following statements is a benefit of using a 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 databases 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, and 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 to be processed quickly?

Write the temperatures 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 Server 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 back ups

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? See all Back Skip

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

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

Scaling out doesn't take effect until you restart the 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

When should you use a block blob, and when should you 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 Archive 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 or other unstructured 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 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

What is a security principal?

An object that represents a user, group, service, or managed identity that is requesting access to Azure resources.

A named collection of permissions that can be granted to a service, such as the ability to use the service to read, write, and delete data. In Azure, examples include Owner and Contributor

A set of resources managed by a service to which you can grant access

Which of the following is an advantage of using multi-region replication with Cosmos DB?

Data will always be consistent in every region

Increased security for your data

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

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

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/region, and 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 to be 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

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 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 Power BI Desktop

Bring data into Power BI mobile, create a report, then share it to Power BI Desktop

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 Azure Data Lake storage and download the data

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 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

Match the correct option

1. Diagnostic 2. Prescriptive 3. Cognitive

1. Diagnostic 2. Predictive 3. Cognitive

1. Descriptive 2. Predictive 3. Cognitive

1. Descriptive 2. Prescriptive 3. Cognitive

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

native support for cross-database queries and transactions

system-initiated automatic backups

You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?

Microsoft SQL Server Data Tools (SSDT)

Microsoft SQL Server Management Studio (SSMS)

Select all that is TRUE:

A Microsoft Power BI dashboard is associated with a single workspace

A Microsoft Power BI dashboard can display visualizations from a Microsoft excel workbook

A Microsoft Power BI dashboard can only display visualizations from a single dataset

Select all that are TRUE

Batch data can process all the data in the dataset. Stream processing typically only has access to the most recent data received, or within a rolling time window (the last 30 seconds, for example)

You typically use batch processing for performing complex analytics. Stream processing is used for simple response functions, aggregates, or calculations such as rolling averages

Stream processing is suitable for handling large datasets efficiently. Batch data is intended for individual records or micro batches consisting of few records

The latency for Stream processing is typically a few hours. Batch Processing typically occurs immediately, with latency in the order of seconds or milliseconds. Latency is the time taken for the data to be received and processed

A relational database must be used when

strong consistency guaranty is required

to store large images and videos

data will be stored as key/value pairs

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 have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?

Online Analytical Processing (OLAP)

Online Transaction Processing (OLTP)

D900_1

Authored by Edgar Martínez

Computers

1st - 5th Grade

Used 9+ 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

How is data in a relational table organized?

Rows and Columns

Header and Footer

Pages and Paragraphs

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an example of unstructured data?

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

Audio and Video files

A table within SQL Server database

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What of the following is an example of a streaming dataset?

Data from sensors and devices

Sales data for the past month

List of employees working for a company

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Backing up and restoring databases

Creating dashboards and reports

Identifying data quality issues

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following tools is a visualization and reporting tool?

SQL Server Management Studio

Power BI

SQL

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which one of the following roles is not a data job role?

Systems Administrator

Data Analyst

Database Administrator

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

All data must be stored as character strings

A row in a table represents a single entity

Different rows in the same table can contain different columns

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

45 questions

Quiz Berpikir Komputasional

Quiz

•

1st Grade

50 questions

CursTic

Quiz

•

5th - 8th Grade

55 questions

ICT

Quiz

•

5th - 6th Grade

50 questions

ICT year 5 revision

Quiz

•

5th Grade

45 questions

Prueba Ingresos HFA

Quiz

•

1st - 12th Grade

54 questions

Examen General

Quiz

•

2nd Grade

53 questions

TBT DÖNEM SONU DEĞERLENDİRME

Quiz

•

5th Grade

48 questions

ICDL modulo 1_computer essential

Quiz

•

3rd 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

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th 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

Discover more resources for Computers

10 questions

Module 2 Vocab

Quiz

•

5th Grade

10 questions

Introduction to Coding

Interactive video

•

3rd - 6th Grade

D900_1

How is data in a relational table organized?

Which of the following is an example of unstructured data?

What of the following is an example of a streaming dataset?

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

Which of the following tools is a visualization and reporting tool?

Which one of the following roles is not a data job role?

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

What is an index?

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

Which of the following services should you use to implement a non-relational database?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers