The .............. resource model reserves processing power for data stored in SQL tables and is not an ideal resource model to use for ad hoc data preparation.
You are developing a solution that will stream to Azure Stream Analytics. The solution will have both streaming data and reference data. Which input type should you use for the reference data?
Pipelines are a component of Azure Synapse Analytics that enables you to ingest, prepare, and serve data to other Azure Synapse Components or Azure services.
Diagnostic Analytics helps answer questions about
........... attempts to draw inferences from existing data and patterns, derive conclusions based on existing knowledge bases, and then add these findings back into the knowledge base for future inferences, a self-learning feedback loop.
By default, tables in dedicated SQL pool are created as
In Azure Blob Storage, Data in the ........................ access tier is stored offline.
Azure portal is the best place to centrally work with all Azure Synapse Analytics capabilities
What should you do to improve high availability of the real-time data processing solution?
.............. provisions and set up data platform technologies that are on-premises and in the cloud
Descriptive Analytics helps answer questions about
You have a partitioned table in an Azure Synapse Analytics dedicated SQL pool. You need to design queries to maximize the benefits of partition elimination. What should you include in the Transact-SQL queries?
A .............. is a core component of Business Intelligence (BI) solutions that provides a central repository of data stored in relational tables.
In Azure Blob Storage, The ............. access tier can only be set at the blob level.
In Azure SQL, the virtual network rule applies at the server-level as well as at the database-level.
You have Customer data, including name, contact information, and loyalty number, comes from Salesforce, What should you recommend using to secure sensitive customer contact information?
You are designing an Azure Stream Analytics solution that will analyze Twitter data. You need to count the tweets in each 20-second window. The solution must ensure that each tweet is counted only once. Which Window type should you use?
You develop data engineering solutions for a company. The company has on-premises Microsoft SQL Server databases at multiple locations. The company must integrate data with Microsoft Power BI and Microsoft Azure Logic Apps. The solution must avoid single points of failure during connection and transfer to the cloud. The solution must also minimize latency. You need to secure the transfer of data between on-premises databases and Microsoft Azure. What should you do?
............................. is a mature modeling approach widely adopted by relational data warehouses. It requires modelers to classify their model tables as either dimension or fact.
The Data Lake is primary storage location for source files that can be used within the various analytical engines
You have an Azure data factory. You need to examine the pipeline failures from the last 60 days. What should you use?
............................. is a distributed query system that enables you to implement data warehousing and data virtualization scenarios using standard T-SQL experiences familiar to data engineers.
You are designing the folder structure for an Azure Data Lake Storage Gen2 container. Users will query data by using a variety of services including Azure Databricks and Azure Synapse Analytics serverless SQL pools. The data will be secured by subject area. Most queries will include data from the current year or current month. Which folder structure should you recommend to support fast queries and simplified folder security?
A .............. allows you to interact with data without the need to understand how the data is formatted, structured, or what is its data type
In Azure Blob Storage, The hot access tier has ..............
...................................... brings together the best of SQL technologies used in enterprise data warehousing, Spark technologies used for big data, Pipelines for data integration and ETL/ELT, and deep integration with other Azure services such as Power BI, CosmosDB, and AzureML.
Predictive Analytics helps answer questions about
In Azure Blob Storage, Only the ......... and ............. access tiers can be set at the account level.
The first step in deploying Azure Synapse Analytics is to deploy
Which Azure Storage option is the cheapest way to store data in Azure?
Which options you can do to query Blob store?
In Azure Blob Storage, you can directly read or download a blob in Archive access.
If you create a storage account as a Blob store, you can query the data directly
Prescriptive Analytics helps answer questions about
You implement an enterprise data warehouse in Azure Synapse Analytics. you need to distribute the large fact table that is 10 terabytes (TB) in size across multiple nodes to optimize performance of the table. Which technology should you use?
In Azure Synapse Analytics dedicated SQL pool, Transparent Data Encryption encrypts the storage of an entire database by using a symmetric key called the ..............................
You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information. You need to recommend a solution to provide salespeople with the ability to view all the entries in Customers. The solution must prevent all the salespeople from viewing or inferring the credit card information. What should you include in the recommendation?
Which resource model, the Azure Synapse SQL offers?
You need to schedule an Azure Data Factory pipeline to execute when a new file arrives in an Azure Data Lake Storage Gen2 container. Which type of trigger should you use?
To open Azure Synapse Studio, Go to the ............................... and sign in to your workspace.
If you need to provision a data store that will store but not query data, your cheapest option is to set up a storage account as ..................
Which Integration runtime type should you recommend to import the daily inventory data from the SQL server to Azure Data Lake Storage?
You plan to create a retail store table that will contain the address of each retail store. The table will be approximately 2 MB. Queries for retail store sales will include the retail store addresses. You need to implement the surrogate key for the retail store table. What should you create?
You are a data architect. The data engineering team needs to configure synchronization of data between an on-premises Microsoft SQL Server database to Azure SQL Database. Ad-hoc and reporting queries are being overutilized in the on-premises production instance. The synchronization process must Perform an initial data synchronization to Azure SQL Database with minimal downtime and Perform bi-directional data synchronization after initial synchronization. Which synchronization method should you use to implement this synchronization solution?
In Azure Blob Storage, The .............. doesn't support all redundancy options.
You have an Azure subscription that contains a logical Microsoft SQL server named Server1. Server1 hosts an Azure Synapse Analytics SQL dedicated pool named Pool1. You need to recommend a Transparent Data Encryption (TDE) solution for Server1. What should you use to track the usage of encryption keys?
In Azure Synapse Analytics, the ............................ improve query performance on large fact tables.
An application will use Microsoft Azure Cosmos DB as its data solution. The application will use the Cassandra API to support a column-based database type that uses containers to store items. You need to provision Azure Cosmos DB. Which container name and item name should you use?
............ is where you can develop TSQL scripts and notebooks in Azure Synapse Analytics
Which resource model in Azure Synapse Analytics is the most effective to use the resources when required
In Azure Synapse Analytics dedicated SQL pool, The .................. helps protect against the threat of malicious activity by encrypting and decrypting your data at rest. Ex: When you encrypt your database, associated backups and transaction log files are encrypted without requiring any changes to your applications.
You are designing an HDInsight/Hadoop cluster solution that uses Azure Data Lake Gen1 Storage. The solution requires POSIX permissions and enables diagnostics logging for auditing. You need to recommend solutions that optimize storage. Which solution meets the goal?