单选题 Case study - Overview - XYZ is an online training provider. Current Environment - The company currently has Microsoft SQL databases that are split into different categories or tiers. Some of the databases are used by Internal users, some by external partners and external distributions. Below is the List of applications, tiers and their individual requirements: Below are the current requirements of the company: * For Tier 4 and Tier 5 databases, the backup strategy must include the following: - Transactional log backup every hour - Differential backup every day - Full backup every week * Backup strategies must be in place for all standalone Azure SQL databases using methods available with Azure SQL databases * Tier 1 database must implement the following data masking logic: - For Data type XYZ-A `" Mask 4 or less string data type characters - For Data type XYZ-B `" Expose the first letter and mask the domain - For Data type XYZ-C `" Mask everything except characters at the beginning and the end * All certificates and keys are internally managed in on-premise data stores * For Tier 2 databases, if there are any conflicts between the data transfer from on-premise, preference should be given to on-premise data. * Monitoring must be setup on every database * Applications with Tiers 6 through 8 must ensure that unexpected resource storage usage is immediately reported to IT data engineers. * Azure SQL Data warehouse would be used to gather data from multiple internal and external databases. * The Azure SQL Data warehouse must be optimized to use data from its cache * The below metrics must be available when it comes to the cache: - Metric XYZ-A `" Low cache hit %, high cache usage % - Metric XYZ-B `" Low cache hit %, low cache usage % - Metric XYZ-C `" high cache hit %, high cache usage % * The reporting data for external partners must be stored in Azure storage. The data should be made available during regular business hours in connecting regions. * The reporting for Tier 9 needs to be moved to Event Hubs. * The reporting for Tier 10 needs to be moved to Azure Blobs. The following issues have been identified in the setup: * The External partners have control over the data formats, types and schemas * For External based clients, the queries can't be changed or optimized * The database development staff are familiar with T-SQL language * Because of the size and amount of data, some applications and reporting features are not performing at SLA levels. The Azure Data Factory instance must meet the requirements to move the data from the On-premise SQL Servers to Azure. Which of the following should you use as the masking function for Data type XYZA?
2021-11-19
共32道
相关试题
单选题 Case study - Overview - XYZ is an online training provider. They regularly conduct polls on the effectiveness of their training material. The polling data comes from various sources, such as online surveys and public events. The polling data would be stored into 2 locations: * An on-premise Microsoft SQL Server database * Azure Data Lake Gen 2 storage The data in the data lake would be queried using PolyBase. Each poll data also has associated metadata. The metadata is stored as JSON. The metadata has the date and number of people who have taken the poll. Polling data is also taken via phone calls. Below are the security requirements for polling data taken via phone calls: * The poll data must be uploaded by authorized users from authorized devices * External contractors can only access their own polling data * The access to the polling data would be given to users on a per-active directory user basis Other requirements: * All data migration processes must be carried out using Azure Data Factory * All of the data migrations must run automatically and be carried out during non-business hours * All services and processes must be resilient to regional Azure outages * All services must be monitored using Azure Monitor * The performance of the on-premise SQL Server must also be monitored * After 3 months all polling data must be moved to low cost storage * All deployments must be performed using Azure DevOps * Deployments must make use of templates * No credentials or secrets of any kind must be exposed during deployments You have to create the storage account that would be used to store the polling data. Which of the following would you use as the Account type?
单选题 Case study - Overview - XYZ is an online training provider. They regularly conduct polls on the effectiveness of their training material. The polling data comes from various sources, such as online surveys and public events. The polling data would be stored into 2 locations: * An on-premise Microsoft SQL Server database * Azure Data Lake Gen 2 storage The data in the data lake would be queried using PolyBase Each poll data also has associated metadata. The metadata is stored as JSON. The metadata has the date and number of people who have taken the poll. Polling data is also taken via phone calls. Below are the security requirements for polling data taken via phone calls: * The poll data must be uploaded by authorized users from authorized devices * External contractors can only access their own polling data * The access to the polling data would be given to users on a per-active directory user basis Other requirements: * All data migration processes must be carried out using Azure Data Factory * All of the data migrations must run automatically and be carried out during non-business hours * All services and processes must be resilient to regional Azure outages * All services must be monitored using Azure Monitor * The performance of the on-premise SQL Server must also be monitored * After 3 months all polling data must be moved to low cost storage * All deployments must be performed using Azure DevOps * Deployments must make use of templates * No credentials or secrets of any kind must be exposed during deployments You have to implement the deployment of Azure Data Factory pipelines. Which of the following would you use for authorization of the deployments?
单选题 Case study - Overview - A company is hosting a computational data analysis processing application on a set of virtual machines. The application runs daily jobs and then stores the results in virtual hard disk drives. The application uses data from the previous data and stores the results in a snapshot of the VHD. When a new month starts, the applications creates a new VHD. You need to implement a data lifecycle policy that would meet the following requirements: * Ensure that results are kept for 60 days * The data for the current year must be available for weekly reports * Data from the prior 10 years must be available for auditing purposes * Data that is required for auditing must be made available within 10 days of the request being made You have to enforce the data lifecycle policy and also ensure costs are kept to a minimum You need complete the below lifecycle policy JSON segment Which of the following would go into Slot 2?
单选题 Case study - Overview - XYZ is an online training provider. They regularly conduct polls on the effectiveness of their training material. The polling data comes from various sources, such as online surveys and public events. The polling data would be stored into 2 locations: * An on-premise Microsoft SQL Server database * Azure Data Lake Gen 2 storage The data in the data lake would be queried using PolyBase. Each poll data also has associated metadata. The metadata is stored as JSON. The metadata has the date and number of people who have taken the poll. Polling data is also taken via phone calls. Below are the security requirements for polling data taken via phone calls: * The poll data must be uploaded by authorized users from authorized devices * External contractors can only access their own polling data * The access to the polling data would be given to users on a per-active directory user basis Other requirements: * All data migration processes must be carried out using Azure Data Factory * All of the data migrations must run automatically and be carried out during non-business hours * All services and processes must be resilient to regional Azure outages * All services must be monitored using Azure Monitor * The performance of the on-premise SQL Server must also be monitored * After 3 months all polling data must be moved to low cost storage * All deployments must be performed using Azure DevOps * Deployments must make use of templates * No credentials or secrets of any kind must be exposed during deployments You have to implement the deployment of Azure Data Factory pipelines. Which of the following would you use for authentication of the deployments?
单选题 Case study - Overview - A company is hosting a computational data analysis processing application on a set of virtual machines. The application runs daily jobs and then stores the results in virtual hard disk drives. The application uses data from the previous data and stores the results in a snapshot of the VHD. When a new month starts, the applications creates a new VHD. You need to implement a data lifecycle policy that would meet the following requirements: * Ensure that results are kept for 60 days * The data for the current year must be available for weekly reports * Data from the prior 10 years must be available for auditing purposes * Data that is required for auditing must be made available within 10 days of the request being made You have to enforce the data lifecycle policy and also ensure costs are kept to a minimum You need complete the below lifecycle policy JSON segmentWhich of the following would go into Slot 1?
单选题 Case study - Overview - A company is hosting a computational data analysis processing application on a set of virtual machines. The application runs daily jobs and then stores the results in virtual hard disk drives. The application uses data from the previous data and stores the results in a snapshot of the VHD. When a new month starts, the applications creates a new VHD. You need to implement a data lifecycle policy that would meet the following requirements: * Ensure that results are kept for 60 days * The data for the current year must be available for weekly reports * Data from the prior 10 years must be available for auditing purposes * Data that is required for auditing must be made available within 10 days of the request being made You have to enforce the data lifecycle policy and also ensure costs are kept to a minimum You need complete the below lifecycle policy JSON segment Which of the following would go into Slot 5?
单选题 Case study - Overview - A company is hosting a computational data analysis processing application on a set of virtual machines. The application runs daily jobs and then stores the results in virtual hard disk drives. The application uses data from the previous data and stores the results in a snapshot of the VHD. When a new month starts, the applications creates a new VHD. You need to implement a data lifecycle policy that would meet the following requirements: * Ensure that results are kept for 60 days * The data for the current year must be available for weekly reports * Data from the prior 10 years must be available for auditing purposes * Data that is required for auditing must be made available within 10 days of the request being made You have to enforce the data lifecycle policy and also ensure costs are kept to a minimum You need complete the below lifecycle policy JSON segment Which of the following would go into Slot 3?
单选题 Case study - Overview - A company is hosting a computational data analysis processing application on a set of virtual machines. The application runs daily jobs and then stores the results in virtual hard disk drives. The application uses data from the previous data and stores the results in a snapshot of the VHD. When a new month starts, the applications creates a new VHD. You need to implement a data lifecycle policy that would meet the following requirements: * Ensure that results are kept for 60 days * The data for the current year must be available for weekly reports * Data from the prior 10 years must be available for auditing purposes * Data that is required for auditing must be made available within 10 days of the request being made You have to enforce the data lifecycle policy and also ensure costs are kept to a minimum You need complete the below lifecycle policy JSON segment Which of the following would go into Slot 4?
