HomeMicrosoft Exams PracticeDP-203 Exam Questions and Answers (P10) DP-203 Exam Questions and Answers (P10) Welcome to your DP-203 Exam Questions and Answers (Part 10) Please, provide your Full Name and Email to get started! Please, enter your Full Name Please, enter your Email 1. Which type of transactional database system would work best for product data?OLTPOLAP2. Which of the following describes a good strategy for creating storage accounts and blob containers for your application?Create both your Azure Storage accounts and containers before deploying your application.Create Azure Storage accounts before deploying your app. Create containers in your application as needed.Create both your Azure Storage accounts and containers after deploying your application.Create Azure Storage accounts in your application as needed. Create the containers before deploying the application.3. OLTP systems commonly support fewer users, have longer response times, can be less available, and typically handle large and complex transactions.FalseTrue4. Azure Cosmos DB supports SQL for queries and every property is indexed by defaultTrueFalse5. Duplicating customer content for redundancy and meeting service-level agreements (SLAs) in Azure meets which cloud technical requirement?High availabilityScalabilityLift and shift6. OLAP systems commonly support lots of users, have quick response times, and handle large volumes of data.FalseTrue7. .................... is more readable, often used for configuration files that need to be written by people but parsed by programs.YAMLJSONXML8. A video is an example of which type of data?StructuredSemi-structuredUnstructured9. .................... are specialized blobs that support only appending new data (not updating or deleting existing data).Block blobsAppend blobsPage blobs10. Each storage account has ........... unique access keys that are used to secure the storage account.FourOneTwoThree11. Which services can be included in a storage account? Azure Cosms DB Azure Tables Azure SQL DB Azure Blobs Azure Queues Azure Files12. ................ is a container that groups a set of Azure Storage services together.Storage AccountSyetem AccountAzure Account13. Microsoft has Azure client libraries that support a number of languages and frameworks, including: React Go JS Python Java Node.js .NET14. You are working on a project with a 3rd party vendor to build a website for a customer. The image assets that will be used on the website are stored in an Azure Storage account that is held in your subscription. You want to give read access to this data for a limited period of time. What security option would be the best option to use?CDNStorage AccountShared Access SignaturesCORS Support15. The name of a storage account must be:Globally uniqueUnique within your Azure subscriptionUnique within the containing resource group16. The schema of ................... is typically defined at query time.Structured dataUnstructured data17. When configuring network access to your Azure Storage Account, what is the default network rule?To allow all connections from all networksTo deny all connections from all networksTo allow all connection from a private IP address range18. Which of the following can be used to initialize the Blob Storage client library within an application?A globally-unique identifier (GUID) that represents the application.The Azure Storage account connection string.The Azure Storage account datacenter and location identifiers.An Azure username and password.19. GetBlockBlobReference ...................Create a new blobDownload the blob contentDoes not make any calls to Azure Storage, it simply creates an object locally that can work with a stored blob.20. A blob container can store other containersFalseTrue21. You can store an unlimited number of blobs in a container and an unlimited number of containers in a storage account.FalseTrue22. A single Azure subscription can host up to ............ storage accounts, each of which can hold ........... TB of data.1000,500300, 500200, 500100, 50023. ............. is often delivered in files, such as photos or videos.Structured dataSemi-structured dataUnstructured data24. .................... is better choice for highly unstructured and variable data where you cannot predict what are the properties that should be indexed.Azure Cosmos DBAzure SQL Database25. Which Storage accounts authentication mechanism supports expiration and limited permissions for scenarios where you need to grant limited access?WindowsShared access signaturesMFAAccess keys26. Azure SQL Database only enables you to combine structured data, and doesn't support semi-structured data.TrueFalse27. .................... are composed of blocks of different sizes that can be uploaded independently and in parallel.Append blobsBlock blobsPage blobs28. .................... are designed for scenarios that involve random-access reads and writes.Append blobsPage blobsBlock blobs29. Blobs provide unstructured data storage. What does unstructured mean?Blobs can't be organized or named.There are no restrictions on the type of data you can store in blobs.Blobs can't contain structured data, like JSON or XML.Blobs can be sorted30. The schema of ................. is typically defined at the time of creation.Unstructured dataStructured data31. Azure Blob storage isUnstructuredStructured32. Suppose you have two video files stored as blobs. One of the videos is business-critical and requires a replication policy that creates multiple copies across geographically diverse datacenters. The other video is non-critical, and a local replication policy is sufficient. Which of the following options would satisfy both data diversity and cost sensitivity consideration.Create a single storage account that makes use of Local-redundant storage (LRS) and host both videos from here.Create two storage accounts. The first account makes use of Geo-redundant storage (GRS) and hosts the business-critical video content. The second account makes use of Local-redundant storage (LRS) and hosts the non-critical video content.Create a single storage account that makes use of Geo-redundant storage (GRS) and host both videos from here.33. In a typical project, when would you create your storage account(s)?After deployment, when the project is running.No need to storage account.At the beginning, during project setup.At the end, during resource cleanup.34. Azure SQL and Azure Cosmos DB can be included in a storage account.TrueFalse35. A JSON file is an example of which type of data?Semi-structuredUnstructuredStructured36. Which data processing framework will a data engineer use to ingest data onto cloud data platforms in Azure?ETLELTLETOLAP37. Which services are not included in Azure Storage? Azure Tables Azure Files Azure Cosms DB Azure SQL DB Azure Queues Azure Blobs38. In Azure Synapse Analytics, select a distribution column that is not used inGROUP BYHAVINGWhereJOIN39. Which type of shared access signatures allow access to specific resources in a storage account?Account-levelService-level40. Blobs in a container configured for public access can be downloaded without any kind of authentication or auditing by anyone who knows their storage URLsTrueFalse41. Blob storage provide any mechanism for searching or sorting blobs by metadataFalseTrue42. Which of the following is a good analogy for the access keys of a storage account?Cryptographic algorithmREST EndpointUsername and passwordIP Address43. .................... relies on curly braces to indicate data structure, less verbose and easier to read by humans, used by web services to return data.JSONYAMLXML44. .................. detects anomalies in account activity. It then notifies you of potentially harmful attempts to access your account.Encryption in resetAzure Defender for StorageAzure Storage Account Security FeatureEncryption in transit12 out of 11Are you sure, you would like to submit your responses on DP-203 Exam Questions and Answers (Part 10) and view your results? Time is Up! Related