Microsoft Azure Data Fundamentals

• #241Choose 3

  What are three characteristics of an Online Transaction Processing (OLTP) workload?

  • ADenormalized data.
  • BHeavy writes and moderate reads.
  • CLight writes and heavy reads.
  • DSchema on write.
  • ESchema on read.
  • FNormalized data.
  Show answer
• #242

  Which statement is an example of Data Manipulation Language (DML)?

  • AREVOKE.
  • BDISABLE.
  • CCREATE.
  • DUPDATE.
  Show answer
• #243

  Azure Databricks can consume data from Azure Event Hubs.

  • AYes.
  • BNo.
  Show answer
• #244

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

  • AAzure Queue storage.
  • BAzure Data Lake Storage.
  • CAzure table storage.
  • DAzure Files.
  Show answer
• #245

  Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

  • AINSERT.
  • BMERGE.
  • CUPDATE.
  • DCREATE.
  Show answer
• #246

  What is the primary purpose of a data warehouse?

  • ATo provide answers to complex queries that rely on data from multiple sources.
  • BTo provide transformation services between source and target data stores.
  • CTo provide read-only storage of relational and non-relational historical data.
  • DTo provide storage for transactional line-of-business (LOB) applications.
  Show answer

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