I recently needed to deploy a SQL Server session database for Sitecore 9.0 Update-1 and Sitecore documentation said following:
Select the Sitecore.Sessions.dacpac file and click Next. Note: the file can be found in Databases folder in the root of the Sitecore archive.
However, this is kind of misleading as there is no Databases folder. Also, there are no *.dacpac files to be found anywhere on the hard-drive either. It turns out Sitecore 9.0.1 rev. 171219 (OnPrem)_single.scwdp.zip contains the Sitecore.Sessions.dacpac. This is the case when you are setting up XP0 configuration. Simply take the file out of zip and put it somewhere where you can select it in Microsoft Sql Management Studio and continue following Sitecore instructions.
Hope this helps someone :)