Q1. DRAG DROP - (Topic 2)
You need to configure auditing to meet the technical requirements.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
References:
http://solutioncenter.apexsql.com/how-to-setup-and-use-sql-server-audit-feature/
Q2. - (Topic 1)
You are evaluating moving the data from WebData1 to an Azure SQL database.
You need to recommend a solution to generate the consolidated report for billing. The solution must meet the business requirements.
What should you include in the recommendation?
A. SQL Server Integration Services (SSIS)
B. SQL Server Analysis Services (SSAS)
C. an elastic database job
D. an elastic query
Answer: D
Q3. - (Topic 3)
A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04.
You are evaluating the use of active geo-replication for one of the research department databases.
You need to identify which service tier to use for the database. The solution must meet the department requirements and the business requirements.
What should you identify?
A. Premium 1
B. Premium 14
C. Standard S0
D. Basic
Answer: C
Explanation:
References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/
Q4. DRAG DROP - (Topic 1)
A marketing department manager reports that the marketing department database contains incorrect data. The manager reports that the data was correct yesterday.
You need to recommend a method to recover the data.
Which three actions should you recommend be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Q5. HOTSPOT - (Topic 1)
You need to identify which methods to use to migrate MovieReviewDB and CWDB.
Which method should you identify for each database? To answer, select the appropriate options in the answer area.
Answer:
Explanation:
References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-cloud-migrate-compatible-using-ssms-migration-wizard/
Q6. HOTSPOT - (Topic 1)
You are evaluating the migration of the databases from Host1 and WebData1 to Azure.
You need to recommend the most cost-effective solution for storing the database in Azure. The solution must meet the business requirements.
In the table below, recommend the most cost-effective storage solution for Host1 and WebData1. NOTE: Make only one selection in each column.
Answer:
Q7. HOTSPOT - (Topic 1)
You need to identify which methods to use to migrate MovieReviewDB and CWDB.
Which method should you identify for each database? To answer, select the appropriate options in the answer area.
Answer:
Explanation:
References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-cloud-migrate-compatible-using-ssms-migration-wizard/
Q8. DRAG DROP - (Topic 1)
A marketing department manager reports that the marketing department database contains incorrect data. The manager reports that the data was correct yesterday.
You need to recommend a method to recover the data.
Which three actions should you recommend be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Q9. - (Topic 3)
A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04.
You are evaluating the use of active geo-replication for one of the research department databases.
You need to identify which service tier to use for the database. The solution must meet the department requirements and the business requirements.
What should you identify?
A. Premium 1
B. Premium 14
C. Standard S0
D. Basic
Answer: C
Explanation:
References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/
Q10. DRAG DROP - (Topic 2)
You need to recommend a solution to implement high availability for the Listings database.
Which three actions should you recommend be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer: