Microsoft Azure Data Fundamentals

• #161

  You must apply patches to Azure SQL databases regularly,

  • AYes.
  • BNo.
  Tampilkan jawaban
• #162

  Azure SQL managed instance databases can be restored to SQL Server on a Azure virtual machine.

  • AYes.
  • BNo.
  Tampilkan jawaban
• #163

  A job that calculates average revenue per product for the last month in an example pf a streaming workload.

  • AYes.
  • BNo.
  Tampilkan jawaban
• #164Pilih 3

  Which three requirements must be met to query the table from the internet?

  • AYou must be assigned the Reader role for the resource group that contains the database.
  • BYou must have SELECT access to the Products table.
  • CYou must have a user in the database.
  • DYou must be assigned the Contributor role for the resource group that contains the database.
  • EYour IP address must be allowed to connect to the database.
  Tampilkan jawaban
• #165

  A Microsoft Power BY dashboard can display visualizations from a Microsoft Excel workbook.

  • AYes.
  • BNo.
  Tampilkan jawaban
• #166

  A Microsoft Power BI dashboard can only display visualizations from a single dataset.

  • AYes.
  • BNo.
  Tampilkan jawaban
• #167

  You can use MySQL Workbench to query Azure Database for MariaDB databases.

  • AYes.
  • BNo.
  Tampilkan jawaban
• #168Pilih 2

  You have an Azure Cosmos DB account that uses the Core (SQL) API. Which two settings can you configure at the container level?

  • Athe throughput.
  • Bthe read region.
  • Cthe partition key.
  • Dthe API.
  Tampilkan jawaban
• #169

  Azure SQL Database includes a fully managed backup service.

  • AYes.
  • BNo.
  Tampilkan jawaban
• #170

  A development tool for building Azure SQL databases, Microsoft SQL Server relational databases, SQL Server Analysis Services (SSAS) data models. SQL Server Integration Services (SSIS) packages, and SQL Server Reporting Services (SSRS) reports.

  • AAzure Data Studio.
  • BMicrosoft SQL Server Data Tools (SSDT).
  • CMicrosoft SQL Server Management Studio (SSMS).
  • DMicrosoft Visual Studio Code.
  Tampilkan jawaban
• #171

  You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics. What should you use?

  • ASynapse pipelines.
  • BA Synapse SQL pool.
  • CSynapse Link.
  • DSynapse Studio.
  Tampilkan jawaban
• #172

  Platform as a service (PaaS) database offerings in Azure provide administrators with the ability to control adn update the operating system version [...].

  • AYes.
  • BNo.
  Tampilkan jawaban
• #173

  Match the Azure services to appropriate requirements. [...] Persist a tabular representation of data that is stored in Parquet format.

  • AAzure Data Factory.
  • BAzure Synapse Analytics.
  • CAzure Data Lake Storage.
  • DAzure SQL Database.
  Tampilkan jawaban
• #174

  A visualization that shows a university's current student enrollment versus the maximum capacity is an example of [...] analytics.

  • Acognitive.
  • Bdescriptive.
  • Cpredictive.
  • Dprescriptive.
  Tampilkan jawaban
• #175

  Match the types of workloads the appropriate scenario.

  • AData for a product catalog will be loaded every 12 hours to a data warehouse: Batch. Data for online purchases will be loaded to a Gata warehouse as the purchases occur: Streaming. Updates to inventory data will be loaded to a data warehouse every 1,000 transactions: Batch.
  • BData for a product catalog will be loaded every 12 hours to a data warehouse: Streaming. Data for online purchases will be loaded to a Gata warehouse as the purchases occur: Streaming. Updates to inventory data will be loaded to a data warehouse every 1,000 transactions: Batch.
  • CData for a product catalog will be loaded every 12 hours to a data warehouse: Batch. Data for online purchases will be loaded to a Gata warehouse as the purchases occur: Streaming. Updates to inventory data will be loaded to a data warehouse every 1,000 transactions: Streaming.
  • DData for a product catalog will be loaded every 12 hours to a data warehouse: Batch. Data for online purchases will be loaded to a Gata warehouse as the purchases occur: Batch. Updates to inventory data will be loaded to a data warehouse every 1,000 transactions: Streaming.
  Tampilkan jawaban
• #176

  When ingesting data from Azure Data Lake Storage across Azure regions, you will incur costs for bandwidth.

  • AYes.
  • BNo.
  Tampilkan jawaban
• #177

  Match the types of data to the appropriate Azure data services.

  • ABox 1: Image files, Box 2: Key/value pairs, Box 3: Relationships between employees.
  • BBox 1: Relationships between employees Box 2: Image files, Box 3: Key-value pairs.
  • CBox 1: Key-value pairs, Box 2: Image files, Box 3: Relationships between employees.
  Tampilkan jawaban
• #178

  When you create an Azure SQL database, which account can always connect to the database?

  • AThe Azure Active director/ (Azure AO) account that created the database.
  • BThe Azure Active Directly Azure AD) administrator account.
  • CThe sa account.
  • DThe server admin login account of the logical server.
  Tampilkan jawaban
• #179

  Match the types of data stores to the appropriate scenarios. [...] Employee data that shows the realtionships between employees.

  • AGraph.
  • BObject.
  • CKey/value.
  Tampilkan jawaban
• #180

  If you have a platform as a service (PaaS) database in Azure, backups are performed automatically.

  • AYes.
  • BNo.
  Tampilkan jawaban

Ingin melacak skor, mengikuti ujian simulasi berwaktu, dan mendapat penjelasan AI? Buat akun gratis