Microsoft Azure Data Fundamentals

• #101

  Match the types of data stores to the appropriate scenarios. [...] Application users and their and default language.

  • AGraph.
  • BObject.
  • CKey/value.
  Show answer
• #102

  [...] presents content defined by a query.

  • AA heap.
  • BA stored procedure.
  • CA view.
  • DAn index.
  Show answer
• #103

  Azure Data Factory orchestrates data integration workflows.

  • AYes.
  • BNo.
  Show answer
• #104

  Database administrators apply data cleansing routines and turn data into useful information.

  • AYes.
  • BNo.
  Show answer
• #105

  Transparent Data Encryption (TDE) encrypts [...].

  • Aa column to protect data at rest and in transit.
  • Bqueries and their results in order to protect data in transit.
  • Cthe database to protect data at rest.
  • Dthe server to protect data at rest.
  Show answer
• #106

  You implement Azure Data Lake Storage by creating an Azure Storage account.

  • AYes.
  • BNo.
  Show answer
• #107

  A logical grouping of activities that performs a unit of work and can be scheduled.

  • APipeline.
  • BDataset.
  • CLinked service.
  • DMapping data flow
  Show answer
• #108

  The massively parallel processing (MPP) engine of Azure Synapse Analytics [...].

  • Adistributes processing across compute nodes.
  • Bdistributes processing across control nodes.
  • Credirects client connections across compute nodes.
  • Dredirects client connections across control nodes.
  Show answer
• #109Choose 2

  Which two activities can be performed entirely by using the Microsoft Power BI service?

  • AReport and dashboard creation.
  • BReport sharing and distribution.
  • CData modeling.
  • DData acquisition and preparation.
  Show answer
• #110

  A visualization that illustrates a university's current student enrollment per department is an example of [...] analytics.

  • Acognitive.
  • Bdescriptive.
  • Cpredictive.
  • Dprescriptive.
  Show answer
• #111

  Normalization improves data integrity.

  • AYes.
  • BNo.
  Show answer
• #112

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

  • AAzure Databricks.
  • BAzure Log Analytics.
  • CAzure Time Series Insights.
  • DAzure HDinsight.
  Show answer
• #113

  Azure data Factory pipelines can execute other pipelines.

  • AYes.
  • BNo.
  Show answer
• #114

  [...] is an object associated with a table that sorts and stores data rows based on their key values.

  • AA clustered index.
  • BA FileTable.
  • CA foreign key.
  • DA stored procedure.
  Show answer
• #115

  [...] provides a full range of Power BI data modeling and report editing features.

  • AMicrosoft Power BI Desktop.
  • BThe Microsoft Power BI service.
  • CThe Microsoft Power BI phone app.
  Show answer
• #116

  Match the types of workloads the appropriate scenario. Updates to inventory data will be loaded to adata warehouse every 1,000 transactions.

  • ABatch.
  • BStreaming.
  Show answer
• #117

  A lightweight editor that can run on-demand SQL queries and view and save results as text. JSON, or Microsoft Excel files.

  • AAzure Data Studio.
  • BMicrosoft SQL Server Data Tools (SSDT).
  • CMicrosoft SQL Server Management Studio (SSMS).
  • DMicrosoft Visual Studio Code.
  Show answer
• #118

  Extract, load, and transform (ELT) transforms data by using a compute resource independent of the source system and destination system.

  • AYes.
  • BNo.
  Show answer
• #119

  Microsoft SQL Server Management Studio (SSMS) enables users to create and use SQL notebooks.

  • AYes.
  • BNo.
  Show answer
• #120

  Transcribing audio files is an example of [...] analytics.

  • ACognitive.
  • BDescriptive.
  • CPredictive.
  • DPrescriptive.
  Show answer

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