Use Real DP-900 - 100% Cover Real Exam Questions [Oct-2021]
Dumps Brief Outline Of The DP-900 Exam - VCE4Dumps
NEW QUESTION 80
Which command-line tool can you use to query Azure SQL databases?
sqlcmd
- A.
- B. Azure CLI
- C. azdata
- D. bcp
Answer: D
Explanation:
Section: Describe how to work with relational data on Azure
Explanation:
The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt.
Incorrect Answers:
B: The bulk copy program utility (bcp) bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format.
D: The Azure CLI is the defacto tool for cross-platform and command-line tools for building and managing Azure resources.
Reference:
https://docs.microsoft.com/en-us/sql/tools/overview-sql-tools?view=sql-server-ver15
NEW QUESTION 81
You manage an application that stores data in a shared folder on a Windows server.
You need to move the shared folder to Azure Storage.
Which type of Azure Storage should you use?
- A. file
- B. blob
- C. queue
- D. table
Answer: A
Explanation:
Section: Describe how to work with non-relational data on Azure
Explanation:
Azure file shares can be mounted concurrently by cloud or on-premises deployments of Windows, Linux, and macOS. Azure file shares can also be cached on Windows Servers with Azure File Sync for fast access near where the data is being used.
Reference:
https://azure.microsoft.com/en-us/services/storage/files/
NEW QUESTION 82
For each of the following statements. select Yes if the statement is true. Otherwise, select No.
NOTE Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 83
You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.
What should you use to query the files?
- A. PolyBase
- B. Microsoft SQL Server Integration Services (SSIS)
- C. Azure Data Factory
- D. Azure Functions
Answer: A
Explanation:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.databricks.com/data/data-sources/azure/synapse-analytics.html
NEW QUESTION 84
You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?
- A. stream processing
- B. batch processing
- C. Online Analytical Processing (OLAP)
- D. Online Transaction Processing (OLTP)
Answer: D
Explanation:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing
NEW QUESTION 85
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Explanation
Paginated Reports
https://powerbi.microsoft.com/en-us/blog/announcing-paginated-reports-in-power-bi-general-availability/
NEW QUESTION 86
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one point.
- A. light writes and heavy reads
- B. heavy writes and moderate reads
- C. schema on write
- D. denormalized data
- E. normalized data
- F. schema on read
Answer: B,C,F
NEW QUESTION 87
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 88
When can you use an Azure Resource Manager template?
- A. to automate the creation of an interdependent and develop can deploy from the Azure portal
- B. To set complex permissions automatically on existing objects in an Azure subscription
- C. to automate the creation of an interdependent group of Azure resources in a repeatable way
- D. To provision Azure subscriptions and apply policies for multi-tenant deployments
Answer: D
NEW QUESTION 89
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://azure.microsoft.com/en-us/services/cognitive-services/speech-services/
NEW QUESTION 90
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77
NEW QUESTION 91
Match the types of workloads to the appropriate scenarios.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
NEW QUESTION 92
Match the Azure services to appropriate requirements.
To answer, drag the appropriate services from the column on the left to its requirement on the right. Each service may be used once. more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
NEW QUESTION 93
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 94
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 95
You have the following SQL query.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 96
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/batch-processing
NEW QUESTION 97
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?
- A. Pause the pool.
- B. Scale down the data warehouse units (DWUs).
- C. Create a user-defined restore point.
- D. Delete the pool
Answer: A
Explanation:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage- compute-overview
NEW QUESTION 98
Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network.
Which type of data store should you use?
- A. Graph
- B. columnar
- C. Document
- D. Key/value
Answer: A
NEW QUESTION 99
Match the types of workloads to the appropriate scenarios.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
Explanation
Box 1: Batch
Batch processing refers to the processing of blocks of data that have already been stored over a period of time.
Box 2: Streaming
Stream processing is a big data technology that allows us to process data in real-time as they arrive and detect conditions within a small period of time from the point of receiving the data. It allows us to feed data into analytics tools as soon as they get generated and get instant analytics results.
Box 3: Batch
NEW QUESTION 100
You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down.
What should you use in Microsoft Power BI?
- A. a report
- B. Microsoft Power Apps
- C. a dataflow
- D. a dashboard
Answer: B
NEW QUESTION 101
Which setting can only be configured during the creation of an Azure Cosmos DB account?
- A. API
- B. multi-region writes
- C. production or non-reduction account type
- D. geo-redundancy
Answer: C
NEW QUESTION 102
......
Certification Training for DP-900 Exam Dumps Test Engine: https://www.vce4dumps.com/DP-900-valid-torrent.html
DP-900 Training & Certification Get Latest Microsoft Certified: Azure Data Fundamentals : https://drive.google.com/open?id=1aqQ3E64OGAeI2Ftb2RKdD2jY64cB7kRR