The first option was to select either the Automatic Restore Points or User‐defined Restore Points radio button. Notice that the Newest Restore Point datetime in Figure 4.9 is the same as the one shown via the SQL query just provided and shown in Figure 4.7. So, you know there is a link between what you see when running the SQL query and the snapshot to be applied if this option is selected. It is also possible to select a previous snapshot and restore it from the portal blade shown in Figure 4.9. In addition to applying the newest snapshot (the default) or an older one, had you created a user‐defined snapshot, it would show in a drop‐down list box when the User‐defined Restore Points radio button is selected. To create a user‐defined restore point, simply choose the + New Restore Point menu item, shown in Figure 4.8, enter a name, and then click Apply. One last point is that the snapshot must be applied to a new dedicated SQL pool; it cannot be applied to the one it was taken from. This is a platform restriction and not something you can change.
There is also a similar capability available with ADLS where your data files are stored. By default, a feature called Enable Soft Delete for Blobs is enabled. It is configurable from the Data Protection blade for the Azure storage account, as shown in Figure 4.10.