A company has an application that uses Azure SQL Database as the data store. The application experiences a large increase in activity during the last month of each year. You need to manually scale the Azure SQL Database instance to…
You are designing an Azure SQL Data Warehouse. You plan to load millions of rows of data into the data warehouse each day. You must ensure that staging tables are optimized for data loading. You need to design the staging…
You need to optimize storage for CONT_SQL3. What should you recommend? A. AlwaysOn B. Transactional processing C. General D. Data warehousing
Case study This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam.…
HOTSPOT You need to design the image processing and storage solutions. What should you recommend? To answer, select the appropriate configuration in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
DRAG DROP You need to design the image processing solution to meet the optimization requirements for image tag data. What should you configure? To answer, drag the appropriate setting to the correct drop targets. Each source may be used once,…
Case study This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam.…
DRAG DROP You need to ensure that performance requirements for Backtrack reports are met. What should you recommend? To answer, drag the appropriate technologies to the correct locations. Each technology may be used once, more than once, or not at…
HOTSPOT You need to ensure that emergency road response vehicles are dispatched automatically. How should you design the processing system? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
HOTSPOT You need to design the data loading pipeline for Planning Assistance. What should you recommend? To answer, drag the appropriate technologies to the correct locations. Each technology may be used once, more than once, or not at all. You…