Microsoft Azure Data Fundamentals

• #61

  You can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases.

  • AYes.
  • BNo.
  解答を表示
• #62

  When provisioning an Azure Cosmos DB [...], you need to specify which type of API you will use.

  • Aaccount.
  • Bcontainer.
  • Cdatabase.
  • Ditem.
  解答を表示
• #63

  A database view is a virtual table whose content is defined by a query.

  • AYes.
  • BNo.
  解答を表示
• #64

  Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network. Which type of data store should you use?

  • Agraph.
  • Bkey/value.
  • Cdocument.
  • Dcolumnar.
  解答を表示
• #65

  A relational database is appropriate for scenarios that involve a high volume of [...].

  • Achanges to realtionships between entites.
  • Bgeographically distributed writes.
  • Ctransactional writes.
  • Dwrites that have varying data structures.
  解答を表示
• #66

  Azure Synapse Analytics scales storage and compute independently.

  • AYes.
  • BNo.
  解答を表示
• #67

  Platform as a service (PaaS) database offerings in Azure provide built-in high availability.

  • AYes.
  • BNo.
  解答を表示
• #68

  Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

  • ADocument.
  • BColumnar.
  • CGraph.
  • DTime series.
  解答を表示
• #69

  Azure Analysis Services is used for transactional workloads.

  • AYes.
  • BNo.
  解答を表示
• #70

  A data engineer is responsible for which task?

  • ADesign and build analytical models.
  • BDesign and implement data stores for analytical workloads.
  • CExplore data to identify trends.
  • DImplement policies, tools. and processes for backup and recovery plans.
  解答を表示
• #71

  Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit. Which type of analysis is shown for the fourth quarter?

  • APredictive.
  • BPrescription.
  • CDescriptive.
  • DDiagnostic
  解答を表示
• #72

  Which storage solution supports role-based access control (RBAC) at the file and folder level?

  • AAzure Disk Storage.
  • BAzure Data Lake Storage.
  • CAzure Blob storage.
  • DAzure Queue storage.
  解答を表示
• #73

  You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours. You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data remains intact. What should you do on the SQL pool?

  • AScale down the data warehouse units (DWUs).
  • BPause the pool.
  • CCreate a user-defined restore point.
  • DDelete the pool.
  解答を表示
• #74

  Stream processing has access to the most recent data received or data within a rolling time window.

  • AYes.
  • BNo.
  解答を表示
• #75

  An extract, transform, and load (ETL) process requires [...].

  • Aa matching schema in the data source and the data target.
  • Ba target data store powerful enough to transform data.
  • Cdata that is fully processed before being loaded to the target data store.
  • Dthat the data target be a relational database.
  解答を表示
• #76

  Match the types of analytics that can be used to answer the business questions.

  • AWhy did sales increase last month?: Cognitive. How do I allocate my budget to buy different inventory items?: Predictive. Which people are mentioned in a company's business documents?: Prescriptive.
  • BWhy did sales increase last month?: Diagnostic. How do I allocate my budget to buy different inventory items?: Predictive. Which people are mentioned in a company's business documents?: Cognitive.
  • CWhy did sales increase last month?: Descriptive. How do I allocate my budget to buy different inventory items?: Prescriptive. Which people are mentioned in a company's business documents?: Predictive.
  • DWhy did sales increase last month?: Predictive. How do I allocate my budget to buy different inventory items?: Prescriptive. Which people are mentioned in a company's business documents?: Diagnostic.
  解答を表示
• #77

  In Azure Data Factory, you can use [...] to orchestrate pipeline ctivities that depend on the output of other pipeline activities.

  • Aa control flow.
  • Ba dataset.
  • Ca linked service.
  • Dan integration runtime.
  解答を表示
• #78

  Azure Databricks can consume data from Azure SQL Database.

  • AYes.
  • BNo.
  解答を表示
• #79

  To configure an Azure Storage account to support access control lists that have object-level permissions [...].

  • AEnable the hierarchical namespace.
  • BSet Account kind to BlobStorage.
  • CSet Performance to Premium.
  • DSet Replication to Read-access geo-redundant storage (RA-GRS).
  解答を表示
• #80

  You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP). Which Azure service should you use to support the application?

  • AAzure Cosmos D3.
  • BAzure Synapse Analytics.
  • CAzure HCMmtghi.
  • DAzure SQL Database.
  解答を表示

スコアの記録、時間制限付き模擬試験、AI解説をご利用になりますか？ 無料アカウントを作成