Microsoft Azure Data Fundamentals

• #21

  [...] is a platform as a service (PaaS) relational data service that uses massively parallel processing (MPP).

  • AAzure SQL Database.
  • BAzure Synapse Analytics.
  • CAzure Database for MariaDB.
  • DSQL Server on Azure on Azure virtual machines.
  উত্তর দেখুন
• #22

  Azure Synapse Analytics can be paused to reduce compute costs.

  • AYes.
  • BNo.
  উত্তর দেখুন
• #23

  You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?

  • AOnline Transaction Processing (OLTP)
  • BBatch processing.
  • COnline Analytical Processing (OLAP).
  • DStream processing.
  উত্তর দেখুন
• #24

  A Microsoft SQL Server extension that supports connections to SQL Server and provides a rich editing experience for T-SQL.

  • AAzure Data Studio.
  • BMicrosoft SQL Server Data Tools (SSDT).
  • CMicrosoft SQL Server Management Studio (SSMS).
  • DMicrosoft Visual Studio Code.
  উত্তর দেখুন
• #25

  Normalization involves eliminating relationships between database tables.

  • AYes.
  • BNo.
  উত্তর দেখুন
• #26

  A bar chart showing year-to date sales by regionis an example of which type of analytics?

  • ADescriptive.
  • BDiagnostic.
  • CPredictive.
  • DPrescriptiv.
  উত্তর দেখুন
• #27

  Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?

  • Aconsistency.
  • Bdurability.
  • Cisolation.
  • Datomicity.
  উত্তর দেখুন
• #28

  Match the types of workloads the appropriate scenario. [...] Data for online purchases will be loaded to a data warehouse as the purchases occur.

  • ABatch.
  • BMicro-batch
  • CStreaming.
  উত্তর দেখুন
• #29

  Batch workloads [...].

  • Aprocess data in memory, row-by-row.
  • Bcollect and process data at most once a day.
  • Cprocess data as new data is received in near real-time.
  • Dcollect data and then process the data when a condition is met.
  উত্তর দেখুন
• #30

  Azure SQL Database has built-in high availability.

  • AYes.
  • BNo.
  উত্তর দেখুন
• #31

  Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?

  • AControl flow.
  • BLinked services.
  • CDatasets.
  • DThe integration runtime.
  উত্তর দেখুন
• #32

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

  • Aa data pipeline that includes a transformation engine.
  • Bseparate transformation engine.
  • Ca target data store powerful enough to transform data.
  • Ddata that is fully processed before being loaded to the target data store.
  উত্তর দেখুন
• #33

  Relational database tables contain columns and rows.

  • AYes.
  • BNo.
  উত্তর দেখুন
• #34

  A representation of data structures within data stores.

  • APipeline.
  • BDataset.
  • CLinked service.
  • DMapping data flow
  উত্তর দেখুন
• #352টি বাছুন

  At which two levels can you set the throughput for an Azure Cosmos DB account?

  • AContainer.
  • BItem.
  • CDatabase.
  • DPartition.
  উত্তর দেখুন
• #36

  Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?

  • AAzure HDInsight.
  • BAzure SQL Database.
  • CAzure Cosmos DB.
  • DSQL Server on Azure virtual machines.
  উত্তর দেখুন
• #37

  A [...] is a chart 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 nested within the main rectangle.

  • Aline chart.
  • Bmatrix.
  • Cscatter.
  • Dtreemap.
  উত্তর দেখুন
• #38

  Online analytical processing (OLAP) systems are particurarly suitable for analytical workloads because data is [...].

  • Alimited in size.
  • Boptimized for transactions.
  • Cpre-aggregated.
  • Dread-only.
  উত্তর দেখুন
• #39

  What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

  • ANative support for cross-database queries and transactions.
  • BBuilt-in high availability.
  • CSystem-Initiated automatic backups.
  • DSupport for encryption at rest.
  উত্তর দেখুন
• #40

  Platform as a service (PaaS) database offerings in Azure require less setup and configuration effort than infrastructure as a service (IaaS) database offerings.

  • AYes.
  • BNo.
  উত্তর দেখুন

নিজের স্কোর রাখতে, সময়সীমার মক পরীক্ষা দিতে ও AI ব্যাখ্যা পেতে চান? বিনামূল্যে অ্যাকাউন্ট খুলুন