A hospital is modernizing its patient record system. The system needs to store patient demographics (structured), physician's text notes (semi-structured), and medical images like X-rays and MRIs (unstructured). The solution must allow for fast retrieval of a patient's complete record, including their images. Which Azure data services combination is most appropriate for these requirements?
A data analyst is using Power BI to create a report that shows sales performance over time. The analyst needs to compare the total sales of the current month to the total sales of the previous month. Which Data Analysis Expressions (DAX) feature is specifically designed for this type of time-based calculation?
A data engineering team is designing a data ingestion process. They need to choose a file format for storing large datasets in Azure Data Lake Storage Gen2 that will be queried by Azure Synapse Analytics and Azure Databricks. The key requirements are high compression ratios and support for schema evolution. Which file format should they choose?
True or False: In a relational database designed for an Online Transaction Processing (OLTP) system, data is typically denormalized to improve query performance.
A development team is building a global-scale application that requires a database with guaranteed low-latency reads and writes for users in multiple geographic regions. The data is semi-structured (JSON). Which Azure service is specifically designed to meet these requirements? ```mermaid graph TD User1[User in USA] --> App[Global Application] User2[User in Europe] --> App User3[User in Asia] --> App App -->|Reads/Writes| DB{Multi-Region Database?} DB -->|Replicates| Region1[(USA)] DB -->|Replicates| Region2[(Europe)] DB -->|Replicates| Region3[(Asia)] ```
A data professional is responsible for designing, building, and maintaining data pipelines that move data from various sources into a central data warehouse. This role involves data cleaning, transformation, and ensuring data quality. Which data professional role best describes these responsibilities?
A company has several on-premises file servers hosting departmental data. They plan to migrate this data to Azure to provide a centralized, cloud-based file share that can be mounted by both Windows and Linux virtual machines using the standard SMB 3.0 protocol. Which Azure Storage service is designed for this 'lift and shift' file server scenario?
An administrator needs to grant a new user the ability to read data from all tables in a specific database but NOT the ability to modify any data. Which TWO types of SQL statements should the administrator use? (Select TWO)
A data architect is comparing Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) processes for a new analytics solution. In which process is the data transformation performed by the target data store, such as a modern data warehouse?
A company wants to migrate its on-premises SQL Server databases to Azure. They require an Azure service that provides the highest level of compatibility with their existing SQL Server applications, including support for SQL Server Agent and cross-database queries, while still being a fully managed Platform as a Service (PaaS) offering. Which Azure SQL service should they choose?