DP-900 practice questions - Explore roles and responsibilities in the world of data

Which job role manages databases, user permissions, backups and restores as well as optimising performance and availability?

Database Administrator

BI Developer

Data Analyst

Data Engineer

Correct! Wrong!

Which job role designs and implements data ingestion pipelines, data transformation and cleansing tasks, and data stores for analytical workloads?

BI Developer

Database Administrator

Data Engineer

Data Analyst

Correct! Wrong!

Which job role is responsible for designing and building scalable models and designing advanced analytics capabilities via reports and visualisations?

Database Engineer

Data Administrator

Data Analyst

BI Developer

Correct! Wrong!

Although BI developers do write reports and visualisations, they are not specifically by MS Learn. The answer you are looking for is data analyst.

Select all valid tasks undertaken by a Database Administrator?

Please select 2 correct answers

SQL Server Backups

Report writing

Designing high availability solutions

Designing ETL packages

Correct! Wrong!

In some smaller companies, DBAs may be expected to do some non standard tasks including writing reports and designing ETL packages but these are usually done by data analysts and data engineers respectively.

Which client tool is primarily used by SQL Server DBAs?

MySQL Workbench

pgAdmin

SQL Server Management Studio (SSMS)

Toad for SQL Server

Correct! Wrong!

Although 3rd party products such as Toad for SQL Server are available, the majority of SQL DBAs use SSMS. Cross platform tools like Azure Data Studio are also gaining prominence. pgAdmin is for PostgreSQL. MySQL Workbench is for MySQL.

Select an example of a cross platform database administration tool?

SQL Server Management Studio (SSMS)

Azure Data Studio

phpMyAdmin

Oracle Instant Client for Microsoft Windows (X64)

Correct! Wrong!

ADS currently provides connections to on-premises SQL Server databases, Azure SQL Database, PostgreSQL, Azure SQL Data Warehouse, and SQL Server Big Data Clusters, amongst others.

What does the S.Q.L. stand for in Transact-SQL?

Specific Query Language

Set-based Query Language

Standard Query Language

Structured Query Language

Correct! Wrong!

https://en.wikipedia.org/wiki/Transact-SQL

Select all valid tasks undertaken by a data engineer?

Please select 4 correct answers

Developing, constructing, testing, and maintaining databases and data structures

Developing processes for creating and retrieving information from data sets

Deploying sophisticated analytics programs, machine learning, and statistical methods

Using PowerShell to manage SQL Server Backups

Using programming languages and tools to examine the data

Performance tuning T-SQL queries using Java

https://docs.microsoft.com/en-us/learn/modules/explore-roles-responsibilities-world-of-data/4-review-tasks-tools-for-data-engineering

Show hint

Correct! Wrong!

https://docs.microsoft.com/en-us/learn/modules/explore-roles-responsibilities-world-of-data/4-review-tasks-tools-for-data-engineering

Select only the true statements below.

Please select 3 correct answers

Data Engineers may use languages such as HiveQL, R, or Python

Azure data engineers may use Databricks for developing data intensive applications

HDInsight is used in big data processing.

Azure BigQuery is used in big data processing

Correct! Wrong!

Which reporting tools might you expect a skilled data analyst to be comfortable with?

Please select 3 correct answers

SSAS

SSIS

SSRS

Power BI

Correct! Wrong!

SSIS is used for ETL so is the domain of the data engineer.

Select all valid tasks undertaken by a SQL Analyst.

Please select 3 correct answers

Making large volumes of data easy to understand through the use of charts and graphs

Finding hidden patterns in data

Installing Power BI Gateway

Combining data sets from multiple sources

Correct! Wrong!

https://docs.microsoft.com/en-us/learn/modules/explore-roles-responsibilities-world-of-data/5-review-tasks-tools-for-data-visualization-reporting

DP-900 practice questions - Explore roles and responsibilities in the world of data

DP-900 practice questions – Explore roles and responsibilities in the world of data

Which job role manages databases, user permissions, backups and restores as well as optimising performance and availability?

Which job role designs and implements data ingestion pipelines, data transformation and cleansing tasks, and data stores for analytical workloads?

Which job role is responsible for designing and building scalable models and designing advanced analytics capabilities via reports and visualisations?

Select all valid tasks undertaken by a Database Administrator?

Which client tool is primarily used by SQL Server DBAs?

Select an example of a cross platform database administration tool?

What does the S.Q.L. stand for in Transact-SQL?

Select all valid tasks undertaken by a data engineer?

Select only the true statements below.

Which reporting tools might you expect a skilled data analyst to be comfortable with?

Select all valid tasks undertaken by a SQL Analyst.

Related

Which job role manages databases, user permissions, backups and restores as well as optimising performance and availability?

Which job role designs and implements data ingestion pipelines, data transformation and cleansing tasks, and data stores for analytical workloads?

Which job role is responsible for designing and building scalable models and designing advanced analytics capabilities via reports and visualisations?

Select all valid tasks undertaken by a Database Administrator?

Which client tool is primarily used by SQL Server DBAs?

Select an example of a cross platform database administration tool?

What does the S.Q.L. stand for in Transact-SQL?

Select all valid tasks undertaken by a data engineer?

Select only the true statements below.

Which reporting tools might you expect a skilled data analyst to be comfortable with?

Select all valid tasks undertaken by a SQL Analyst.

Related

About John McCormack

Leave a ReplyCancel reply