Take our free assessment for DP-900T00: Microsoft Azure Data Fundamentals and test your knowledge on relational, non-relational, relevant cloud services, Azure Synapse Analytics and Azure storage. Assess your skills now!

How is data in a relational table organized?

An Employee table with columns Employee ID and Employee Name

Which of the following is an example of unstructured data?

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

Writing queries for day-to-day activities

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?

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

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

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

A structure to hold summarized data for each row

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?

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

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

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

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

Write the temperatures to a blob in Azure Blob storage

What type of NoSQL data store is most appropriate for capturing the temperature data to enable it to be processed quickly?

Which type of analytics helps answer questions about what has happened in the past?

Which one of the following visuals displays the major contributors to a selected result or value?

The process of transforming raw data into models containing meaningful information

Capturing raw data streaming from various sources and storing it

What is data ingestion?

The act of setting up the database server is called

Which of the following is a drawback of Normalization?

Processing data as it arrives is called

What lets you create a virtual infrastructure in the cloud that mirrors the way an on-premises data center might work?

Which of these is a row-based format for compressing data and minimizing storage and network bandwidth requirements?

Take our free DP-900T00 Microsoft Azure Data Fundamentals assessments to test and improve your data skills. Start now and advance your tech career!

DP-900T00: Microsoft Azure Data Fundamentals Assessment

DP-900T00: Microsoft Azure Data Fundamentals

Microsoft

AI CERTs™

Google Cloud

Cisco

Amazon Web Services

CompTIA

EC-Council

ISC2

ITIL

DP-900T00: Microsoft Azure Data Fundamentals

Test Your Skills

1.How is data in a relational table organized?

2.Which of the following is an example of unstructured data?

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