Which storage tier and method should you use?

HOTSPOT
You plan to deploy an Azure SQL Database instance.
After deployment, the solution must meet the following requirements:
– You must be able to restore the database to any point in time for the last 30 days.
– In the event of a restore, data must be recovered by using the fastest available method.
– SQL backups must be stored in up four secondary regions.
– You must minimize costs when configuring the databases.
You need to configure the secondary databases.
Which storage tier and method should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

HOTSPOT
You plan to deploy an Azure SQL Database instance.
After deployment, the solution must meet the following requirements:
– You must be able to restore the database to any point in time for the last 30 days.
– In the event of a restore, data must be recovered by using the fastest available method.
– SQL backups must be stored in up four secondary regions.
– You must minimize costs when configuring the databases.
You need to configure the secondary databases.
Which storage tier and method should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Answer:

Show Hint

Leave a Reply 12

Your email address will not be published. Required fields are marked *

fracks

fracks

I believe the answer is wrong. The standard tier can hold your DB for up to 35 days. https://docs.microsoft.com/en-us/azure/mysql/concepts-service-tiers

Reply

Starlin

Starlin

I guess the answer is premium because of this:

– In the event of a restore, data must be recovered by using the fastest available method.

Premium storage account would have a higher IOPS so the recovery method is faster than using a Standard storage account.

Reply

Starlin

Starlin

Ok, I’ve been digging about this and this is what I got:

First of all, these answers are either kind of wrong or they’re trying to confuse us with a couple terms:

In Azure SQL databases there’s no “Storage Tier” or “Storage Method” option. We have “Service Tier”, automated backups and optional replications

*In Service Tier every tier has an automated backup solution integrated (This is what makes Point-In-Time restore possible) but the retention days for the Point-In-Time restore depends on the tier selected.

Basic – 7 Days
Standard – 35 Days
Premium – 35 Days

*The optional replication is what makes the secondary copies on the same or different datacenters but the only one that synchronize 4 secondary copies is Active Geo-Replication.

*The Estimated Restore Time for AGR will depend on the tier that we selected:

Basic – Not Applicable in this case because of the retention days.
Standard – ERT < 30s
Premium – ERT < 30s

So with Active Geo Replication and Standard or Premium Tier we cover these requirements:

– You must be able to restore the database to any point in time for the last 30 days.

– In the event of a restore, data must be recovered by using the fastest available method.

– SQL backups must be stored in up four secondary regions.

So the only requirement left is Minimize Costs:

The higher Standard tier option cost – 150.00/Month
The lowest Premium tier option cost – 465.00/Month

So Standard tier and Active Geo-Replication

Reply

Gman

Gman

I think you’re right Starlin!

Reply

Ted Bundy

Ted Bundy

I agree.

Reply

Gilbert

Gilbert

Standard retention used to be 14 days. This is an old question that’s why the answer is Premium. Now, Which would be the right answer back in time as of November 22, 2016?

Reply

Rawal-Pindi Express!

Rawal-Pindi Express!

What about requirement ( In the event of a restore, data must be recovered by using the fastest available method.)?? Considering this premium should be selected.

Reply

Lars SCH

Lars SCH

New 70-533 Exam Questions and Answers Updated Recently (17/Nov/2017):

NEW QUESTION 219
A company uses Azure to host virtual machines (VMs) and web apps. You plan to deploy a new web app in the Shared App Service tier. The web app must support running up to 25 instances concurrently. You need to ensure that you can configure HTTPS for the new web app. What should you do?

A. Configure the domain name mapping.
B. Set the deployment credentials for the app service.
C. Create a new app service.
D. Scale up to the Premium App Service tier.

Answer: A

NEW QUESTION 220
A company uses Azure to host virtual machines (VMs) and web apps. A line of business (LOB) application that runs on a VM uses encrypted storage. You need to ensure that the VMs support the LOB application. What should you do?

A. Run the Set-AzureRmVMDiskEncryptionExtension Azure PowerShell cmdlet.
B. Use a Premium Storage disk for the VM.
C. Run the Add-AzureRmVmssSecret Azure PowerShell cmdlet.
D. Scan the environment from the Azure Security Manager.

Answer: A

NEW QUESTION 221
A company has an existing on-premises Active Directory environment that is synchronized using DirSync. They plan to transition the DirSync deployment to Azure Active Directory (Azure AD) Connect. You need to identify a transition path for the company. What should you do?

A. Install a new on-premises domain controller.
B. Create a new Azure AD instance.
C. Upgrade the on-premises Active Directory Domain Service (AD DS) forest functional level to Windows Server 2016.
D. Deploy Azure AD Connect in parallel.

Answer: D

NEW QUESTION 222
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You manage an Azure SQL Database. The database has weekly backups that are stored in an Azure Recovery Services vault. You need to maximize the time that previous backup versions are stored.
Solution: You configure a retention policy that is set to 20 years.
Does the solution meet the goal?

A. Yes
B. No

Answer: B
Explanation:
Store Azure SQL Database backups for up to 10 years. Many applications have regulatory, compliance, or other business purposes that require you to retain database backups beyond the 7-35 days provided by Azure SQL Database automatic backups. By using the long-term backup retention feature, you can store your SQL database backups in an Azure Recovery Services vault for up to 10 years.

NEW QUESTION 223
A company deploys Microsoft SQL Server on an Azure Standard_DS3 virtual machine (VM). You need to modify the disk caching policy. Which Azure PowerShell cmdlet should you run?

A. Set-AzureRmVmOperatingSystem
B. Set-AzureRmVmDataDisk
C. Update-Disk
D. Update-AzureDisk

Answer: B
Explanation:
The Set-AzureRmVMDataDisk cmdlet modifies properties of a virtual machine data disk.
Incorrect:
Not A: The Set-AzureRmVMOperatingSystem cmdlet sets operating system properties for a virtual machine. You can specify logon credentials, computer name, and operating system type.
Not C: The Update-Disk cmdlet updates cached information about the specified Disk object only.
Not D: The Update-AzureDisk cmdlet changes the label that is associated with a disk in the disk repository of the current Azure subscription.

NEW QUESTION 224
You create an Azure Recovery Services vault and download the backup agent installation file. You need to complete the installation of the backup agent. What should you do first?

A. Configure network throttling.
B. Set the storage replication option.
C. Download the vault credentials file.
D. Select the data to back up.

Answer: C
Explanation:
After you have created the vault, prepare your infrastructure to back up files and folders by downloading and installing the Microsoft Azure Recovery Services agent, downloading vault credentials, and then using those credentials to register the agent with the vault. You can install the agent after you have downloaded the vault credentials.
Note:
On the Prepare infrastructure blade, click Download.

NEW QUESTION 225
You plan to use Azure Monitor with AutoScale Services. You create a URI to be used with the monitoring service. You need to configure an alert that specifies the URI. Which Azure Command-Line Interface (CLI) command or Azure PowerShell cmdlet should you run?

A. New-AzureRmAlertRuleEmail
B. Azure insights logprofile add
C. New-AzureRmAlertRuleWebhook
D. New-AzureRmAutoscaleRule

Answer: C
Explanation:
The New-AzureRmAlertRuleWebhook cmdlet creates an alert rule webhook.
Incorrect:
Not A: The New-AzureRmAlertRuleEmail cmdlet creates an e-mail action for an alert rule.
Not B: The azure insights logprofile add command adds a log profile.
Not D: The New-AzureRmAutoscaleRule cmdlet creates an Autoscale rule.

NEW QUESTION 226
A company uses Azure to host virtual machines (VMs) and web apps. You need to ensure that you can configure a schedule to scale app services. How should you configure the app service?

A. Set the scale by metric setting to Queue.
B. Set the scale up by instances setting to 5.
C. Set the scale down by instances setting to 5.
D. Ensure that linked resources are also scaled.
E. Set the scale by metric setting to None.

Answer: A
Explanation:
The Automatic scale – Queue mode automatically scales if the number of messages in a queue goes above or below a specified threshold. Role instances are created or deleted when this happens.
Incorrect:
Not B, Not C: To set the scale up/scale down by instances setting you must first set the scale by metric setting to CPU.
Not D: Scale linked resources. Often when you scale a role, it’s beneficial to scale the database that the application is using also. If you link the database to the cloud service, you can access the scaling settings for that resource.

NEW QUESTION 227
You are an administrator of the Azure subscription for your company. You are updating an Azure Resource Manager (ARM) template. You need to ensure that the JSON file uses the latest version available. Which template element should you modify?

A. parameters
B. resources
C. $schema
D. variables

Answer: A

NEW QUESTION 228
You are the Azure administrator for your company. The company has developed a mobile application used to support sales people in the field. The application uses Azure Active Directory (Azure AD) accounts for authentication. The application sends and receives HTTP requests on publicly accessible endpoints. You need to provide the ability to authenticate the application using Azure. Which tool should you use?

A. OAuth 2.0 authorization code grant
B. Azure AD Connect
C. Azure Portal
D. Azure AD Graph API

Answer: A
Explanation:
Azure Active Directory (Azure AD) uses OAuth 2.0 to enable you to authorize access to web applications and web APIs in your Azure AD tenant.
Note:
The authorization code grant type is used to obtain both access tokens and refresh tokens and is optimized for confidential clients. Since this is a redirection-based flow, the client must be capable of interacting with the resource owner’s user-agent (typically a web browser) and capable of receiving incoming requests (via redirection) from the authorization server.

NEW QUESTION 229
……

P.S. These New 70-533 Exam Questions Were Just Updated From The Real 70-533 Exam, You Can Get The Newest 70-533 Dumps In PDF And VCE From — https://www.passleader.com/70-533.html (243q VCE and PDF)

Good Luck!

Reply