Microsoft Azure Data Fundamentals

• #1

  A Microsoft Power BI [...] enables users to create highly formatted, fixed-layout documents archiving.

  • Adashboard.
  • Binteractive report.
  • Cpaginated report.
  • Dsubscription.
  Show answer
• #2

  Batch processing can output data to a relational database.

  • AYes.
  • BNo.
  Show answer
• #3

  Batch processing must occur immediately and have latency in the order of second or milliseconds.

  • AYes.
  • BNo.
  Show answer
• #4

  Partition keys are used in Azure Cosmos DB to optimize queries.

  • AYes.
  • BNo.
  Show answer
• #5

  Which three actions are used when performing diagnostic analytics?

  • AIdentify data anomalies. Collect anomaly-related data. Discover relationships and trends that explain anomalies.
  • BIdentify data anomalies. Predict when anomalies are likely to recur. Use analytical tools such as decision trees and regression.
  • CApply serf-learning loops to draw inferences from anomalies. Predict when anomalies are likely to recur. Use analytical tools such as decision trees and regression.
  • DIdentify data anomalies. Use machine learning to find patterns in large datasets. Discover relationships and trends that explain anomalies.
  Show answer
• #6

  Azure Databricks is an Apache Spark-based collaborative analytics platform.

  • AYes.
  • BNo.
  Show answer
• #7

  Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart. Which type of data store will provide the lowest latency to retrieve the data?

  • Akey/value.
  • Bgraph.
  • Ccolumnar.
  • Ddocument.
  Show answer
• #8

  A [...] in a chcat of colored rectangles. The size of the rectangles represent the relative value of each item. The chart can be hierarchical, displaying data as a set of rectangles nest within the main rectangle.

  • Aline chart.
  • Bmatrix.
  • Cscatter.
  • Dtreemap.
  Show answer
• #9

  Analytics systems are more normalized than transactional systems.

  • AYes.
  • BNo.
  Show answer
• #10

  Platform as a service (PaaS) database offerings in Azure reduce the administrative overhead for managing hardware.

  • AYes.
  • BNo.
  Show answer
• #11

  [...] is responsible for creating visuals and charts that help a company make informed decisions.

  • AA data analyst.
  • BA data engineer.
  • CA data scientist.
  • DA database administrator
  Show answer
• #12

  The Azure Cosmos DB Table API supports multiple write regions.

  • AYes.
  • BNo.
  Show answer
• #13Choose 2

  Which two Azure services can be used to provision Apache Spark clusters?

  • AAzure Time Series Insights.
  • BAzure HDInsight.
  • CAzure Databricks.
  • DAzure Log Analytics.
  Show answer
• #14

  Which Azure Data Factory component provides the compute environment for activities?

  • AA linked service.
  • BAn integration runtime.
  • CA control flow.
  • DA pipeline.
  Show answer
• #15Choose 3

  Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution.

  • Aa report page.
  • Ba Microsoft PowerPoint slide.
  • Ca visualization from a report.
  • Da dataflow.
  • Ea text box.
  Show answer
• #16

  Which clause should you use in a select statement to combine rows in one table with rows in another table?

  • AJOIN.
  • BVALUES.
  • CSet.
  • DKEY.
  Show answer
• #17

  Azure SQL managed instance supports user-created backups.

  • AYes.
  • BNo.
  Show answer
• #18

  To configure an Azure Storage account to support both security at the folder level and atomic directory manipulation [...].

  • AEnable the hierarchical namespace.
  • BSet Account kind to BlobStorage.
  • CSet Performance to Premium.
  • DSet Replication to Read-access geo-redundant storage (RA-GRS).
  Show answer
• #19

  You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?

  • Astream processing.
  • Bbatch processing.
  • COnline Analytical Processing (OLTP).
  • DOnline Transaction Processing (OLTP).
  Show answer
• #20

  You have an application that runs on Windows and requires access to a mapped drive. Which Azure service should you use?

  • AAzure Files.
  • BAzure Blob storage.
  • CAzure Cosmos DB.
  • DAzure Table storage.
  Show answer

Want to track your score, take timed mock exams and get AI explanations? Create a free account