Summer Certification Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: force70

Pass the Microsoft Microsoft Certified: Azure Data Fundamentals DP-900 Questions and answers with CertsForce

Viewing page 4 out of 10 pages
Viewing questions 31-40 out of questions
Questions # 31:

What can be used with native notebook support to query and visualize data by using a web-based interface?

Options:

A.

Azure Databricks


B.

pgAdmin


C.

Microsoft Power Bl


Expert Solution
Questions # 32:

Which type of Microsoft Power Bl visual can you use to examine trends over time for one or more series of values?

Options:

A.

funnel chart


B.

pie chart


C.

table


D.

line chart


Expert Solution
Questions # 33:

You need to analyze data by using Azure Databricks.

Which are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Options:

A.

Create a Microsoft Power Bl report.


B.

Create an Azure Data Factory pipeline.


C.

Use an Apache Spark job to process data stored in an Azure Cosmos DB database.


D.

Create a data flow in Azure Data Factory.


E.

Create an Apache Spark job that will run in a Spark cluster.


Expert Solution
Questions # 34:

Select the answer that correctly completes the sentence.

Question # 34


Expert Solution
Questions # 35:

Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract load, and transform (ELT) process.

Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct. Each location may be used once, or not at all, You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Question # 35


Expert Solution
Questions # 36:

What is the responsibility of a database administrator?

Options:

A.

applying data cleaning routines


B.

creating data visualizations


C.

managing data integration processes


D.

storing backup copies of data


Expert Solution
Questions # 37:

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)

NOTE: Each correct selection is worth one point.

Options:

A.

denormalized data


B.

schema defined when reading unstructured data from a database


C.

light writes and heavy reads


D.

normalized data


E.

schema defined in a database


F.

heavy writes and moderate reads


Expert Solution
Questions # 38:

Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?

Options:

A.

Azure Queue storage


B.

Azure Data Lake Storage


C.

Azure table storage


D.

Azure Files


Expert Solution
Questions # 39:

To complete the sentence, select the appropriate option in the answer area.

Question # 39


Expert Solution
Questions # 40:

You have a banking application that transfers money in to and out of accounts.

Of which type of solution is this is an example?

Options:

A.

extract transform, and load (ETL)


B.

a data warehouse


C.

online analytical processing (OLAP)


D.

online transaction processing (OLTP)


Expert Solution
Viewing page 4 out of 10 pages
Viewing questions 31-40 out of questions